top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Converting Mysql to mysql cluster

0 votes
297 views

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.
2. What are the steps to convert mysql to mysql-cluster.

Appreciate the help.

posted Mar 27, 2013 by Salil Agrawal

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

1) 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) 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 ENGINE=ndb;

answer Mar 27, 2013 by anonymous
Similar Questions
0 votes

I am running My-SQL in cluster mode with two machine. Want to know if mysql database get corrupted on one of the machine will it force the corruption on the other machine too or in this case sync between two mysql instances will stop after the corruption.

+1 vote

if you set up your LAN MySQL server in to cluster, will it make the new data's entered on a laptop MySQL database that is not connected on the LAN synchronize with the cluster, once that laptop got connected with the LAN again? Is it also possible to set up a cluster on a web host MySQL, so that when you log in on the online database, your offline data will synchronize with the MySQL cluster on your web host?

+1 vote

I am using PHP along with mysql. Mysql default configuration allows to have 100 simultaneous connection which I want to chane to 200. Please help.

0 votes

To source sqldump i can use the source command, but if I need to do the same stuff using command line without going to the sqlpromt, can I achieve that.

...