Here is the scenario -
- We have completed and made Mysql 5 Clustering to work on Linux.
- We already know how to Cluster and Replicate the existing database tables by using the command "ALTER TABLE table_name ENGINE=NDBCLUSTER;"
Only thing is though we have around 1 Million Database Tables, it is impractical to manually issue the command ALTER TABLE to all of the million database table just to cluster and replicate them to the second clustered server.
Can anyone kindly give me tips and info on how can I make the 1 million database table be clustered and replicated much easier to the 2nd clustered server rather than issueing the command ALTER TABLE to all of the 1miillion database table?
Thanks in advance.
For further helpful info I have used the Mysql how to of this websites -
- http://www.howtoforge.com/loadbalanc...cluster_debian
- http://dev.mysql.com/doc/refman/5.0/...l-cluster.html
- http://www.samag.com/documents/s=100...04a/0604a.html
- http://www.davz.net/static/howto/mysqlcluster
- http://www.oreillynet.com/pub/a/data...l_cluster.html
- We have completed and made Mysql 5 Clustering to work on Linux.
- We already know how to Cluster and Replicate the existing database tables by using the command "ALTER TABLE table_name ENGINE=NDBCLUSTER;"
Only thing is though we have around 1 Million Database Tables, it is impractical to manually issue the command ALTER TABLE to all of the million database table just to cluster and replicate them to the second clustered server.
Can anyone kindly give me tips and info on how can I make the 1 million database table be clustered and replicated much easier to the 2nd clustered server rather than issueing the command ALTER TABLE to all of the 1miillion database table?
Thanks in advance.
For further helpful info I have used the Mysql how to of this websites -
- http://www.howtoforge.com/loadbalanc...cluster_debian
- http://dev.mysql.com/doc/refman/5.0/...l-cluster.html
- http://www.samag.com/documents/s=100...04a/0604a.html
- http://www.davz.net/static/howto/mysqlcluster
- http://www.oreillynet.com/pub/a/data...l_cluster.html