Making the impossible: 3 nodes intercontinental replication-

原文：http://www.percona.com/blog/2012/01/11/making-the-impossible-3-nodes-intercontinental-replication/

In this post I want to show new possibilities which open with?.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.

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,by default,4444,4567,4568 ports(see??why)

Second,please take into account that the communication is done using open channels,and you may want to establish an encrypted connection,using it in real life.

Now,as we have running instances,you can install Cluster packages from RPM repositories.You can follow steps?.

Or I prepared simple script which does all the work:?,you also can follow steps from the script to adjust it for your environment.

You just need to change nodes host names and your keys in the file:?install.nodes.sh

When all nodes start,we have running 3 nodes EU<->USA<->JAPAN,and each node is ready to execute both read and write queries.

Of course you may wonder what is query response time in such environment. We can check it.

Simple table:?CREATE TABLE t (ID INT)?and simple query:?INSERT INTO t VALUES (1)

Response time on single node in EU (no cluster setup):?0.005100 secResponse time on two-nodes (EU<->JAP) cluster:?0.275642 secResponse time on three-nodes (EU<->JAP<->USA) cluster:?0.294754 sec

Well,one may argue that 0.27 sec for single query is kind of big,but this is the physic law,you cannotgo faster than speed of light,and the round trip between Europe and Japan takes time (or at least until scientists figure out how to attach transaction to?).Also note,that XtraDB Cluster can apply events in parallel and throughput should be less affected by big distance.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!