> -----Original Message-----
> From: Kevin Peterson [mailto:qh.resu01@stripped]
> Sent: 27 March 2013 06:58
> To: mysql@stripped
> Subject: Converting Mysql to mysql cluster
> My site is using mysql and PHP, now for the scale purpose want to
> introduce mysql-cluster. Few questions are - 1. Do I need to change
> any code which is written in PHP.
The answer is "yes and no". There's a good chance that your application will work fine
with MySQL Cluster without any changes *but* there are a few gotchas such as:
- the current GA version of MySQL Cluster (7.2) doesn't implement Foreign Keys (coming in
- (ignoring BLOBs) rows cannot be larger than 13 Kb
- no geo-spatial indexes
- no full-text search
A good place to get more information is
http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/ . That guide
also gives you some advice on scenarios where you *shouldn't* use MySQL Cluster.
In addition, as you should expect, to get the best performance out of MySQL Cluster you
may want to tweak your schema and/or application - you can get lots of tips from
> 2. What are the steps to convert mysql to mysql-cluster.
Basically, you need to backup your database (mysqldump), load it into a MySQL Server
that's part of your Cluster (use
http://www.clusterdb.com/mysql-cluster/auto-installer-labs-release/) to get your first
Cluster up and running and then issue ALTER TABLE <tab-name> ENGINE=ndb;
> Appreciate the help.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql