Bug #72448 FAILS TO REPLICATE FABRIC DATABASE USING NBD CLUSTER SETUP
Submitted: 25 Apr 2014 2:41 Modified: 13 Jan 2015 7:53
Reporter: Alfranio Correia Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Fabric Severity:S3 (Non-critical)
Version:1.4.2 OS:Any
Assigned to: Alfranio Correia CPU Architecture:Any

[25 Apr 2014 2:41] Alfranio Correia
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.