Note: DO NOT use this procedure in production, this is a proof of concept (POC). MaxScale 1.1.0 does not yet fully support that procedure and things could go wrong in some situations (see at the end of the post for the details).
In my talk at PLMCE 2015, I presented an architecture to promote a slave as a new master without touching any other slave and I claimed that I tested it. This HOWTO
In the Install and Configure HOWTO, we learned how to install and configure a MaxScale Binlog Server. In this HOWTO, I will present the common operations that you might need to perform when using this software. Those operations include:
Purging Binary Logs, Chaining Binlog Servers, Saving Binary Log Files in the Non-Default Directory, Downloading Binary Logs other than First, Listing Connected
Introduction
One of the primary objectives of MySQL replication is providing an easy failover process i.e. switching to a redundant system if the primary MySQL server fails. In MySQL this translates to switching to the most appropriate slave server in the eventuality of a failure of the master server.
The promotion of a candidate slave to become a new master is based on a lot of factors, undoubtedly the most important factor being that the chosen slave should be most up to date with the primary server (the old master) before we lost it! This blog explains how to use new features in MySQL 5.7.4 and later to make failover easier.
To find the most up to date slave server, a failover script looks at the set of transactions received by the slave and compares it with every other slave to find the one that has received the biggest set of transactions. There could be more sophisticated ways of doing this, for instance you …
[Read more]Dealing with the failure of a MySQL master is not simple. The most common solution is to promote a slave as the new master but in an environment where you have many slaves, the asynchronous implementation of replication gets in your way. The problem is that each slave might be in a different state:
some could be very close to the dead master, some could be missing the latest transactions, and
Itchy Ninja Software is pleased to announce the release of Analyst for MySQL v1.1. Revolutionize the way you work and administrate MySQL, MariaDB, Galera, and Percona XtraDB installations.
Make More Efficient Use of Your Time
Gathering all of the metrics to diagnose a database installation is a very time consuming process, and many simply do not have the experience to know where to begin. With Analyst for MySQL, you will be able to get your hands on hundreds of metrics within moments. It really takes all of the guesswork, as well as tedious long sessions of writing queries out of managing a MySQL database server.
Cross-Platform
Not only can you run the program on Windows, Mac, or Linux, you can also generate server reports from each of those platforms as well! No need to install anything on the server at any time. All diagnostics are run from your laptop or desktop machine. The …
[Read more]http://blog.booking.com/evaluating_mysql_parallel_replication_2-slave_group_commit.html
Follow the link above to read my latest article on the Booking.com developer blog. It is about MySQL Parallel Replication and a very nice side effect of the MariaDB implementation: Slave Group Commit.
This is also a good opportunity to remind you that I will speak at Percona Live Santa Clara 2015 about
On March 10, 2015, we released MySQL-5.7.6 and among many other things it includes multi-source replication which …
[Read more]http://blog.booking.com/better_parallel_replication_for_mysql.html
Follow the link above to read my latest article on the Booking.com developer blog. It is about MySQL Parallel Replication and Binlog Servers.
This fulfills my promise made at Percona Live London 2014 during my talk High Availability, Disaster Recovery and Extreme Read Scaling using Binlog Servers: I finally took the time to
The MySQL Utilities Team is pleased to announce the general availability (GA) release of MySQL Utilities. This release includes a number of improvements for useabilty, stability, and a few enhancements. A complete list of all improvements can be found in our release notes.
New Enhancements!
This release represents a stable release of the product. Along with several defect patches, we also include the following enhancements.
Improved support for MySQL 5.7 early releases
Improved output for mysqldbcompare
Improved SSL support
How Can I Download MySQL Utilities?
You can download MySQL Utilities 1.5.2 GA from the following link using one of the pre-built installation repositories including a source download.
http://dev.mysql.com/downloads/tools/utilities/
Where is the Documentation?
You …
[Read more]The MySQL Utilities Team is pleased to announce a new alpha release of MySQL Utilities. This release includes a number of improvements for useability, stability, and a few enhancements. A complete list of all improvements can be found in our release notes.
New Enhancements!
This release represents a stable release of the product. Along with several defect patches, we also include the following enhancements.
Improved support for MySQL 5.7 early releases
Improved output for mysqldbcompare
Improved SSL support
New Utilities!
This release also has three new utilities for you to try out:
mysqlslavetrx – skip transactions on one or more slaves to solve
errant transactions and consistency errors – docs
mysqlbinlogpurge – purge old binary logs – docs
mysqlbinlogrotate – rotate the binary logs – docs
How Can I Download MySQL Utilities?
You can …
[Read more]