mysql cluster with 3 db/data and 2 mgm nodes

--0016e65b5844b039ea048d5e6070
Content-Type: text/plain; charset=UTF-8

Hi,

i am about to configure mysql-cluster setup with 3 data+sql nodes and 2 mgm
nodes, i would like to know if it's ok to go ahead with this setup, because
somewhere i read it's preferred to setup _even_ number of data nodes instead
e.g. 2, 4, or 6. please advice me.

thanks and best regards,

-m

--
Ghulam Mustafa
cell: +92 333.611.7681
sip: cyrenity@ekiga.net
mail: mustafa.pk@gmail.com
web: cyrenity.wordpress.com

--0016e65b5844b039ea048d5e6070--

Re: mysql cluster with 3 db/data and 2 mgm nodes

Unless you have a very good reason, you probably shouldn't go with
cluster in the first place. If it is HA you want to have, check out
other options like MMM for MySQL (http://mysql-mmm.org), DRBD
+Heartbeat and others.
Can you tell us a bit more about your goals/desires?

Walter Heck
Engineer @ Open Query (http://openquery.com)

On Mon, Aug 9, 2010 at 14:46, Ghulam Mustafa wrote:
> Hi,
>
> i am about to configure mysql-cluster setup with 3 data+sql nodes and 2 mgm
> nodes, i would like to know if it's ok to go ahead with this setup, because
> somewhere i read it's preferred to setup _even_ number of data nodes instead
> e.g. 2, 4, or 6. please advice me.
>
> thanks and best regards,
>
> -m
>
> --
> Ghulam Mustafa
> cell: +92 333.611.7681
> sip: cyrenity@ekiga.net
> mail: mustafa.pk@gmail.com
> web: cyrenity.wordpress.com
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql cluster with 3 db/data and 2 mgm nodes

On Sun, Aug 8, 2010 at 11:49 PM, Walter Heck - OlinData.com
wrote:
> Unless you have a very good reason, you probably shouldn't go with
> cluster in the first place. If it is HA you want to have, check out
> other options like MMM for MySQL (http://mysql-mmm.org), DRBD
> +Heartbeat and others.
> Can you tell us a bit more about your goals/desires?
>
> Walter Heck
> Engineer @ Open Query (http://openquery.com)

Walter is spot on and yes, 3 is not a good number for data nodes. The
only recommended (and somewhat well tested) number of replicas is 2,
so 3 would not be useful. You may want to buy another box so that do 2
replicas with 2 shards, OR just use the third node as a warm standby.

--
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org