9 messages in com.mysql.lists.clusterRe: Wide area MySQL Cluster| From | Sent On | Attachments |
|---|---|---|
| Michael Gruetzner | 22 Nov 2007 01:48 | |
| Luis Motta Campos | 22 Nov 2007 02:11 | |
| Martin Skold | 22 Nov 2007 02:44 | |
| Luis Motta Campos | 22 Nov 2007 03:56 | |
| Rayson Ho | 22 Nov 2007 11:02 | |
| Eric Frazier | 22 Nov 2007 11:13 | |
| Geert Vanderkelen | 23 Nov 2007 02:43 | |
| Martin Skold | 23 Nov 2007 04:36 | |
| Martin Skold | 23 Nov 2007 04:45 |
| Subject: | Re: Wide area MySQL Cluster |
|---|---|
| From: | Rayson Ho (rayr...@gmail.com) |
| Date: | 11/22/2007 11:02:32 AM |
| List: | com.mysql.lists.cluster |
I read "MySQL Clustering" from MySQL Press a few months ago. It has answers to some of your questions:
1) usually it's the latency that kills performance, you can see the section "Physical Factors" for the bandwidth/latency needed. The whole chapter is available online: http://dev.mysql.com/tech-resources/articles/mysql_clustering_ch5.html
2) split-brain: MySQL cluster will warn you if you only have 2 nodes. The min number of nodes required/recommended is 3. And if the network communication breaks, then the side with the majority of nodes would take over.
Rayson
On Nov 22, 2007 6:56 AM, Luis Motta Campos <luis...@yahoo.co.uk> wrote:
I'm believing that if I'm able to provide optics fiber and a huge bandwidth, it's possible to have a cluster operating from two different physical locations. Please correct me if I'm getting this wrong.
I have more questions in the subject, though. Can someone here point me to documentation about how to calculate the needed bandwidth per transaction per time unit for a data node?
Any chance of having a mathematical formula for this, or even an equation system that I could use to estimate the needed bandwidth in function of the transaction count per time unit?
* * *
Another issue bugging me at the moment is how will a cluster implemented in two different physical locations will handle split-brain situations?
What will happen to the cluster if part of it become unreachable for certain clients, while the other part is unreachable to a different set of clients?
Is there a recommended procedure to handle this situations?
Many thanks in advance. Kind regards.
-- Luis Motta Campos (a.k.a. Monsieur Champs) is a software engineer, Perl fanatic evangelist, and amateur {cook, photographer}
--
MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/cluster?unsub=rayr...@gmail.com