This post is the third of a series focusing on the MySQL high availability solutions available in 2017. The first post looked at the elders, the technologies that have been around for more than ten years. The second post talked about the adults, the more recent and mature technologies. In this post, we will look […]
Read More
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:
|
1 2 3 4 5 6 7 |
[Splitter Service] type=service router=readwritesplit servers=percona1, percona2 max_slave_replication_lag=30 user=maxscale passwd=264D375EC77998F13F4D0EC739AABAD4 |
This router module is designed to spread […]
Read More
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:
|
1 2 3 4 5 6 7 8 9 |
[Replication Monitor] type=monitor module=mysqlmon servers=percona1, percona2, percona3 user=maxscale passwd=264D375EC77998F13F4D0EC739AABAD4 monitor_interval=1000 script=/usr/local/bin/failover.sh events=master_down |
But what are we monitoring? We are monitoring […]
Read More
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