This blog post will discuss what is necessary of the Percona Live Advanced Percona XtraDB Cluster tutorial.
Percona Live 2016 is happening in April! If you are attending, and you are registered to the Percona XtraDB Cluster (Galera) tutorial presented by Kenny and myself, please make sure that you:
Bring your laptop, this is a hands-on […]
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:
Shell
[Splitter Service]
type=service
router=readwritesplit
servers=percona1, percona2
max_slave_replication_lag=30
user=maxscale
passwd=264D375EC77998F13F4D0EC739AABAD4
1234567
[Splitter Service]type=servicerouter=readwritesplitservers=percona1, percona2max_slave_replication_lag=30user=maxscalepasswd=264D375EC77998F13F4D0EC739AABAD4
This router module is designed to spread […]
Read more
In this blog post, we’ll discuss JSON document fast lookup with MySQL 5.7.
Recently I attended Morgan Tocker’s talk on MySQL 5.7 and JSON at FOSDEM, and I found it awesome.
I learned some great information from the talk. Let me share one of them here: a very useful trick if you plan to store JSON documents […]
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:
Shell
[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
123456789
[Replication Monitor]type=monitormodule=mysqlmonservers=percona1, percona2, percona3user=maxscalepasswd=264D375EC77998F13F4D0EC739AABAD4monitor_interval=1000script=/usr/local/bin/failover.shevents=master_down
But what are […]
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:
Three MySQL servers, […]
Read more