Tag: Galera

Feed: Planet MySQL; Author: MySQL Performance Blog; Borys Belinsky and Dmitriy Kostiuk  | April 20, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM PREVIOUS POST Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible. We focused mainly on two features in 1.10.0, but there are also several notable improvements worth highlighting: ... Read More

Feed: Planet MySQL; Author: Simon Mudd; The Madrid MySQL Users Group has been a bit quiet recently so we thought it would be good to have a meeting again. The next meeting will take place next on Wednesday, 25th April and will cover Galera Cluster (Presentation by Emanuele Mottola).  We will also talk about MySQL 8.0 and any latest updates that may have been announced.  Meetup details and location can be found here.   If you’re not attending Percona Live 2018 in sunny Santa Clara and are in Madrid come and join us ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This document describes how to configure a Galera cluster monitor. Configuring the Monitor Define the monitor that monitors the servers. [Galera-Monitor] type=monitor module=galeramon servers=dbserv1, dbserv2, dbserv3 user=monitor_user password=my_password monitor_interval=2000 The mandatory parameters are the object type, the monitor module to use, the list of servers to monitor and the username and password to use when connecting to the servers. The monitor_interval parameter controls how many milliseconds the monitor waits between each monitoring loop. This monitor module will assign one node within the Galera Cluster as the current master and other nodes as ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The object of this tutorial is to have a system that has two ports available, one for write connections and another for read connection that are load balanced across all servers. Setting up MariaDB MaxScale The first part of this tutorial is covered in MariaDB MaxScale Tutorial. Please read it and follow the instructions for setting up MariaDB MaxScale with the type of cluster you want to use. Once you have MariaDB MaxScale installed and the database users created, we can create the configuration file for MariaDB MaxScale. Creating Your MariaDB MaxScale ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The object of this tutorial is to have a system that appears to the client as a single database. MariaDB MaxScale will split the statements such that write statements will be sent to the current master server in the replication cluster and read statements will be balanced across the rest of the servers. Setting up MariaDB MaxScale The first part of this tutorial is covered in MariaDB MaxScale Tutorial. Please read it and follow the instructions for setting up MariaDB MaxScale with the type of cluster you want to use. Once you ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible. There are a number of significant updates in Percona Monitoring and Management 1.9.0 that we hope you will like, some of the key highlights include: Faster loading of the index page: We have enabled performance optimizations using gzip and HTTP2. AWS improvements: We have added metrics from CloudWatch RDS to 6 dashboards, ... Read More

Feed: Planet MySQL; Author: MariaDB; How to Restore a Single Database from MariaDB Backup Ulrich Moser Tue, 04/10/2018 - 17:01 Lately, I’ve been asked how to restore a single database or even a single table out of a complete backup of MariaDB Server that was created with MariaDB Backup. This blog provides step-by-step guidance on how to achieve a restore of a database. Another blog post will pick up the question on how to restore a single table which has a separate set of challenges. We will use the world sample database and a backup directory /opt/backup/ as an example ... Read More

Feed: Planet MySQL; Author: Severalnines; Running databases on cloud infrastructure is getting increasingly popular these days. Although a cloud VM may not be as reliable as an enterprise-grade server, the main cloud providers offer a variety of tools to increase service availability. In this blog post, we’ll show you how to architect your MySQL or MariaDB database for high availability, in the cloud. We will be looking specifically at Amazon Web Services and Google Cloud Platform, but most of the tips can be used with other cloud providers too. Both AWS and Google offer database services on their clouds, and ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In this blog post, we’ll look at how to approach pt-table-checksum errors. pt-table-checksum is one of the most popular tools in Percona Toolkit, and it is widely used to identify data differences between masters and slaves. Therefore, as Percona Support Engineers we have customers often asking questions related to the pt-table-checksum errors and warnings produced. Below are the most common issues raised with pt-table-checksum, and we decided to address those issues to help with how to mitigate related warnings or errors. Unable to detect slaves Cannot connect to h=127.0.0.1,p=...,u=percona Diffs cannot be detected ... Read More

Feed: Planet MySQL; Author: Severalnines; Server manufacturers and cloud providers offer different kinds of storage solutions to cater for your database needs. When buying a new server or choosing a cloud instance to run our database, we often ask ourselves - how much disk space should we allocate? As we will find out, the answer is not trivial as there are a number of aspects to consider. Disk space is something that has to be thought of upfront, because shrinking and expanding disk space can be a risky operation for a disk-based database. In this blog post, we are going ... Read More