Geek asks and answers

MySQL Cluster Propagation

I created a MySQL cluster on Ubuntu after the guide: http://bieg.wordpress.com/2008/08/03/mysql-clustering-ubuntu/

I correctly initialize nodes (a node with MGM and NDB, and another NDB node) ndb_mgm> show;returns:

Connected to Management Server at: 10.168.222.24:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2    @10.168.222.24  (mysql-5.1.51 ndb-7.1.9, Nodegroup: 0)
id=3    @10.160.91.224  (mysql-5.1.51 ndb-7.1.9, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @10.168.222.24  (mysql-5.1.51 ndb-7.1.9)

[mysqld(API)]   1 node(s)
id=4    @10.168.222.24  (mysql-5.1.51 ndb-7.1.9)

However, when I move on to testing the cluster, I created a database on both nodes, but the tables that I create in the node do not apply to the others, nor to the content.

What could be the problem?

thank

+3
source share
1 answer

MySQL 5.1 MyISAM ( InnoDB MySQL 5.5). , , ndb/cluster, MySQL.

, , MySQL , , NDB . , ...

CREATE TABLE simples (id INT NOT NULL PRIMARY KEY) ENGINE = ndb;

...

ALTER TABLE: = ndb;

ndb_mgm , MySQL, config.ini, [mysqld] , mysqld-.

, node? engine = ndb, , .

, , , (, MySQL-, "apt-get install mysql-server", , https://www.mysql.com/downloads/cluster/

MySQL Cluster 7.2, 7.1.

http://www.clusterdb.com/mysql-cluster/deploying-mysql-cluster-over-multiple-hosts/

+3

More articles:


All Articles