Description:
Ran a cluster setup using mysql-cluster-gpl-7.3.1-linux-glibc2.5-x86_64 in
multiple machines
ran fabric in one node as
/usr/bin/python /export/home/tmp/qauser/prasad/trunk/build/bin/mysqlfabric
--param=storage.address=localhost:17001 --param=storage.user=root
--param=protocol.xmlrpc.password=rudra manage setup
/usr/bin/python /export/home/tmp/qauser/prasad/trunk/build/bin/mysqlfabric
--param=storage.address=localhost:17001 --param=storage.user=root
--param=protocol.xmlrpc.password=rudra manage start
Made the default engine as ndb so that replication happened
node 1(fabric started here):
mysql> show tables;
+-------------------+
| Tables_in_fabric |
+-------------------+
| checkpoints |
| error_log |
| group_replication |
| groups |
| permissions |
| role_permissions |
| roles |
| servers |
| shard_maps |
| shard_ranges |
| shard_tables |
| shards |
| user_roles |
| users |
+-------------------+
14 rows in set (0.00 sec)
Node2(replicated node):
mysql> show tables;
+-------------------+
| Tables_in_fabric |
+-------------------+
| checkpoints |
| error_log |
| group_replication |
| groups |
| servers |
| shard_maps |
| shard_ranges |
| shard_tables |
| shards |
+-------------------+
9 rows in set (0.00 sec)
The tables
*permissions*
*role_permissions*
*roles*
*user_roles*
*users*
are created with the ENGINE=InnoDB.
How to repeat:
Check the code.
Suggested fix:
Remove the option ENGINE=InnoDB.