EmergencyEMERGENCY? Get 24/7 Help 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

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.