!include include/default_mysqld.cnf !include include/default_ndbd.cnf # Create cluster with 4 attached MySQLDs with different # binlog variants [cluster_config.1] NoOfReplicas= 2 ndbd=, ndb_mgmd= mysqld=,,, ndbapi=,,,,,,,,,,, [mysqld] # Make all mysqlds use cluster ndbcluster ndb-wait-connected=20 ndb-wait-setup=120 ndb-cluster-connection-pool=1 ndb-log-bin=1 binlog-format=row [cluster_config.mysqld.1.1] NodeId=49 Dedicated=1 [cluster_config.mysqld.2.1] NodeId=16 Dedicated=1 [cluster_config.mysqld.3.1] NodeId=32 Dedicated=1 [cluster_config.mysqld.4.1] NodeId=48 Dedicated=1 [mysqld.1.1] ndb-nodeid=49 ndb-log-update-as-write=1 ndb-log-updated-only=1 [mysqld.2.1] ndb-nodeid=16 ndb-log-update-as-write=1 ndb-log-updated-only=0 [mysqld.3.1] ndb-nodeid=32 ndb-log-update-as-write=0 ndb-log-updated-only=1 [mysqld.4.1] ndb-nodeid=48 ndb-log-update-as-write=0 ndb-log-updated-only=0 [ENV] NDB_CONNECTSTRING= @mysql_cluster.1.ndb_connectstring MASTER_MYPORT= @mysqld.1.1.port MASTER_MYPORT1= @mysqld.2.1.port MASTER_MYPORT2= @mysqld.3.1.port MASTER_MYPORT3= @mysqld.4.1.port