Buy Percona ServicesBuy Now!

Read-write split routing in MaxScale

 | March 29, 2016 |  Posted In: Maxscale, MySQL

Read-write split routing performance in MaxScale

In this blog post, we’ll discuss read-write split routing in MaxScale. The two previous posts have shown how to setup high availability (HA) with Maxscale using asynchronous replication and how we monitor replication. Now let’s focus on the routing module performing read-write splits. This is our current configuration:

This router module is designed to spread […]

Read More

How MaxScale monitors servers

 | March 2, 2016 |  Posted In: High-availability, Maxscale, MySQL

maxscale monitors servers

In this post, we’ll address how MaxScale monitors servers. We saw in the We saw in the previous post how we could deal with high availability (HA) and read-write split using MaxScale. If you remember from the previous post, we used this section to monitor replication:

But what are we monitoring? We are monitoring […]

Read More

High availability with asynchronous replication… and transparent R/W split

 | February 25, 2016 |  Posted In: GTID, High-availability, MariaDB, Maxscale, MySQL

High availability with asynchronous replication

In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication. When we talk about high availability with asynchronous replication, we always think about MHA or PRM. But if we want to transparently use the slave(s) for READs, what can we use ? Description: […]

Read More