If you're able to use MySQL 5.6 and enable GTIDs then it gets a whole lot
simpler as you don't need to worry about finding the correct positions in the
binary logs. Take a look at
http://www.mysql.com/why-mysql/white-papers/mysql-replication-high-availability/
and http://www.mysql.com/why-mysql
about partitioning, failover etc.
Regards, Andrew.
> -Original Message-
> From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
> Sent: 29 April 2013 14:50
> To: Andrew Morgan
> Cc: [MySQL]
> Subject: Re: MySQL Cluster or MySQL Cloud
>
> Hi Andrew,
>
> Thanks for
Hi Neil,
I hate just sending people off to white papers but you might get some good
insights by taking a look at the "MySQL Guide to High Availability Solutions"
paper -
http://www.mysql.com/why-mysql/white-papers/mysql-guide-to-high-availability-solutions/
Regards, Andrew.
And
Hi Kevin,
What do you mean by running MySQL in cluster mode - MySQL Cluster? If so then
the data is stored in the data nodes rather than the MySQL Servers and so if
bad data is written to one MySQL Server then that same bad data will be viewed
through the other MySQL Server too.
Regards, Andr
> -Original Message-
> From: Kevin Peterson [mailto:qh.res...@gmail.com]
> Sent: 27 March 2013 06:58
> To: mysql@lists.mysql.com
> Subject: Converting Mysql to mysql cluster
>
> Hi,
>
> My site is using mysql and PHP, now for the scale purpose want to
> introduce mysql-cluster. Few que
> -Original Message-
> From: Miguel Gonzalez [mailto:miguel_3_gonza...@yahoo.es]
> Sent: 21 March 2013 08:29
> To: Manuel Arostegui
> Cc: mysql@lists.mysql.com
> Subject: Re: Promoting MySQL 5.5 slave to master
>
>
>
>
>
> - Mensaje original -
> De: Manuel Arostegui
> Para:
> -Original Message-
> From: Mike Franon [mailto:kongfra...@gmail.com]
> Sent: 18 March 2013 13:34
> To:
> Subject: mysql cluster and auto shard
>
> I am looking at the best way to scale writes.
>
> Either using sharding with our existing infrastructure, or moving to
> mysql cluster.
Hi Neil,
MySQL Cluster *does* support stored procedures. There are some limitation that
MySQL Cluster has; this white paper would be a good place to start...
http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/
Regards, Andrew.
> -Original Message-
> From: Nei
Hi Bheemsen,
looks like a few different things going on there; if you have a MySQL support
contract/subscription then it would be worth raising SRs - it doesn't need to
be a bug, it's fine tyo ask questions too. A couple of things that spring to
mind in-line
> I am frequently seeing the f