1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
!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
# Use smaller than default cache size to save resources
ndb-log-cache-size=32768
# 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
|
