MySQL Forums
Forum List  »  NDB clusters

Re: What happens when an MGM fails?
Posted by: Carlo Sogono
Date: June 26, 2006 12:56AM

Stewart,

Thanks for a quick reply. We are actually making SMS/MMS software for a large telecom company to handle thousands of queries per second. Hardware is not an issue as we expect to run them on 4 CPU machines with an abundant amount of RAM running RHEL AS4. What concerns me is that after 9/11 our client wants us to host these synchronized databases across states. We are not interested in splitting the database into partitions and we intend to make replicas of the whole database across the states. It is also important that we are able to update the cluster using the nearest database...much like replication but with all master servers (no slaves).

Is this setup possible?

State1: mysqld, ndbd, mgmd
State2: mysqld, ndbd, mgmd
State3: mysqld, ndbd, mgmd
State4: mysqld, ndbd, mgmd

Since you said it's possible to run multiple (identical MGMs) I was thinking of running them on all state servers. By the way, we expect to have bandwidth of at least 10Mbps between all of them. As you can see we're more interested in redundancy and synchronization more than high

We are in the process of making our own sync'ing software but will consider a cluster solution if this will reduce our production time significantly.

Thanks in advance.

Options: Reply• Quote


Subject
Views
Written By
Posted
2285
June 25, 2006 11:19PM
Re: What happens when an MGM fails?
1257
June 26, 2006 12:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.