List:General Discussion« Previous MessageNext Message »
From:Andrew Morgan Date:March 27 2013 1:10pm
Subject:RE: Converting Mysql to mysql cluster
View as plain text  

> -----Original Message-----
> From: Kevin Peterson [mailto:qh.resu01@stripped]
> Sent: 27 March 2013 06:58
> To: mysql@stripped
> 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 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
Cluster 7.3)
 - (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
http://www.mysql.com/why-mysql/white-papers/guide-to-optimizing-performance-of-the-mysql-cluster/

> 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
> 
Thread
Converting Mysql to mysql clusterKevin Peterson27 Mar
  • RE: Converting Mysql to mysql clusterAndrew Morgan27 Mar