[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: Converting Mysql to mysql cluster
From:       Andrew Morgan <andrew.morgan () oracle ! com>
Date:       2013-03-27 13:10:23
Message-ID: 5846a2f2-ae24-4c38-a18d-73646237989b () default
[Download RAW message or body]



> -----Original Message-----
> From: Kevin Peterson [mailto:qh.resu01@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 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
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql


[prev in list] [next in list] [prev in thread] [next in thread]