Re: MySQL Cluster alerts

2012-12-18 Thread Andrew Morgan
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

RE: MySQL Cluster Solution

2013-03-07 Thread Andrew Morgan
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: Neil

RE: mysql cluster and auto shard

2013-03-18 Thread Andrew Morgan
-Original Message- From: Mike Franon [mailto:kongfra...@gmail.com] Sent: 18 March 2013 13:34 To: mysql@lists.mysql.com 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

RE: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Andrew Morgan
-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 man...@tuenti.com

RE: Converting Mysql to mysql cluster

2013-03-27 Thread Andrew Morgan
-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 questions

RE: Mysql Cluster Sync-UP

2013-04-10 Thread Andrew Morgan
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,

RE: MySQL Cluster or MySQL Cloud

2013-04-29 Thread Andrew Morgan
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. Andrew Morgan

RE: MySQL Cluster or MySQL Cloud

2013-04-30 Thread Andrew Morgan
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 your response and the useful white paper

RE: Chain Replication QUestion

2013-05-01 Thread Andrew Morgan
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