!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 # Enable load data local functionality local-infile=true [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 [cluster_config.mysqld.5.1] NodeId=63 Dedicated=1 [cluster_config.mysqld.6.1] NodeId=127 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 [mysqld.5.1] ndb-nodeid=63 ndb-log-update-as-write=0 ndb-log-updated-only=1 ndb-log-update-minimal=1 [mysqld.6.1] ndb-nodeid=127 ndb-log-update-as-write=0 ndb-log-updated-only=0 ndb-log-update-minimal=1 [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 MASTER_MYPORT4= @mysqld.5.1.port MASTER_MYPORT5= @mysqld.6.1.port NDB_BACKUP_DIR= @cluster_config.ndbd.1.1.BackupDataDir