6 messages in com.mysql.lists.clusterRe: cluster sql note can set to a mas...| From | Sent On | Attachments |
|---|---|---|
| huang mingyou | 12 Feb 2006 17:52 | |
| Alex Davies | 12 Feb 2006 17:55 | |
| huang mingyou | 12 Feb 2006 18:03 | |
| Stewart Smith | 12 Feb 2006 22:01 | |
| huang mingyou | 13 Feb 2006 00:01 | |
| Stewart Smith | 13 Feb 2006 02:47 |
| Subject: | Re: cluster sql note can set to a master node as a Replication |
|---|---|
| From: | Stewart Smith (stew...@mysql.com) |
| Date: | 02/13/2006 02:47:17 AM |
| List: | com.mysql.lists.cluster |
On Mon, 2006-02-13 at 16:01 +0800, huang mingyou wrote:
Because we database will service for 8 dns servers in 2 different net,so I want use cluster + Replication .the 2 net's connect speed is not very good,so if use cluster I think will not a good idea. but if the cluster can work on it. I think this is my only one choice. is it? hmy
with cluster to cluster replication (5.1), as long as the connection is good enough to run replication of your transactions over (there is a limit on bandwidth of transactions over the replication channel - this is a hardware limitation[1] as well as a software architecture limitation.[2]) you shouldn't have a problem.
I'd encourage you to start playing with 5.1 in a test environment and see how you go. Feedback is greatly appreciated.
[1] you need the bandwidth to pump everything over for one. [2] scaling the software up to do hundreds of thousands of updates per second is a much harder task. It's on our todo list however. The current implementation works great up to certain loads though. For DNS servers, you are unlikely to get anything like this much load.
-- Stewart Smith, Software Engineer MySQL AB, www.mysql.com Office: +14082136540 Ext: 6616 VoIP: 66...@sip.us.mysql.com Mobile: +61 4 3 8844 332
Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html