In this post I want to show new possibilities which open with
Percona XtraDB Cluster.
We will create 3 nodes Cluster with nodes on different continents
(Europe, USA, Japan) and each node will accept write
queries.
Well, you theoretically could create 3 node traditional MySQL
ring replication, but this is not what you want to use
day-to-day.
To show how it works I will use Amazon m1.xlarge instances, by
one in Tokyo, Ireland and North California, running RedHat
Entreprise 6.2 64bit.
In fact to create instances is most time consuming task. After that using my script you will have cluster running in 5 min or less.
There however some precautions needed if you run Amazon
instances.
First, you need to open ports in the firewall. For the
communication the nodes need, …