MySQL Cluster node distribution is as follows:
USES the Ip (hostname) OS
The management node 192.168.1.201 (MGM1) redhat 6.2 64 - bit
SQL node 1 192.168.1.202 (SQL1) redhat 6.2 64 - bit
SQL node 2 192.168.1.203 (SQL2) redhat 6.2 64 - bit
1 192.168.1.204 NDB node (NDB1) redhat 6.2 64 - bit
2 192.168.1.205 NDB node (NDB2) redhat 6.2 64 - bit
MGM configuration is as follows:
[NDBD default]
NoOfReplicas=2
DataMemory=80 m
IndexMemory 18 m=
[ndb_mgmd]
The hostname=192.168.0.201
Datadir=/home/mysql/dbdata
[NDBD]
The hostname=192.168.0.204
Datadir=/home/mysql/dbdata/
[NDBD]
# the Options for the data node "B" :
The hostname=192.168.0.205
Datadir=/home/mysql/dbdata/
[mysqld]
# SQL node options:
The hostname=192.168.0.202
[mysqld]
The hostname=192.168.0.203
SQL configuration is as follows:
[client]
Socket=/var/lib/mysql/mysql. The sock
[mysqld]
Max_connections=100
Datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql. The sock
Ndbcluster
NDB - connectstring=192.168.0.201
[mysqld_safe]
The log - error=/var/log/mysqld. Log
Pid - pold=/var/run/mysqld/mysqld. Pid
[mysql_cluster]
NDB - connectstring=192.168.0.201 # # management node
NDB configuration is as follows:
[mysqld]
Datadir=/home/mysql/dbdata/
Socket=/var/lib/mysql/mysql. The sock
User=mysql
# Disabling -- - the links is it to prevent assorted security risks
-- - the links=0
Ndbcluster
NDB - connectstring=192.168.0.201
[MYSQL_CLUSTER]
NDB - connectstring=192.168.0.201
[mysqld_safe]
The log - error=/var/log/mysqld. Log
Pid - file=/var/run/mysqld/mysqld. Pid
SQL nodes using mysql user command: mysqld start - explicit_defaults_for_timestamp starts log is as follows:
[mysql @ SQL2 ~] $mysqld start - explicit_defaults_for_timestamp
The 2015-08-30 21:40:42 0 [Note] mysqld (mysqld 5.6.25 - NDB - 7.4.7 - cluster - the GPL) starting as the process of 9367...
The 9367 21:40:42 2015-08-30 [Warning] Buffered Warning: Changed limits: max_open_files: 1024 (5000) requested
The 9367 21:40:42 2015-08-30 [Warning] Buffered Warning: Changed limits: table_open_cache: 457 (2000) requested
The 9367 21:40:42 2015-08-30 [Note] the Plugin 'FEDERATED is disabled.
9367 21:40:42 2015-08-30 [Note] NDB: Changed global value of binlog_format from the STATEMENT to MIXED
Mysqld start - explicit_defaults_for_timestamp2015 30 21:41:17 9367-08 - [Warning] NDB: server id is set to zero - changes logged to bin the log with zero server id will be logged with another server id by slave mysqlds
The 9367 21:41:17 2015-08-30 [Note] NDB Binlog: Starting...
The 9367 21:41:17 2015-08-30 [Note] NDB Binlog: Started
The 9367 21:41:17 2015-08-30 [Note] NDB Binlog: Setting up
The 9367 21:41:17 2015-08-30 [Note] NDB Binlog: Created schema NDB object, the reference: 0 x0, name: 'NDB Binlog schema change monitoring'
The 9367 21:41:17 2015-08-30 [Note] NDB Binlog: Created injector NDB object, the reference: 0 x0, name: 'NDB Binlog data change monitoring'
The 9367 21:41:17 2015-08-30 [Note] NDB Binlog: Setup completed
The 9367 21:41:17 2015-08-30 [Note] NDB Binlog: Wait for the server start completed
The 9367 21:41:17 2015-08-30 [Note] NDB Util: Starting...
The 9367 21:41:17 2015-08-30 [Note] NDB Util: Wait for the server start completed
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Using atomics to ref count buffer pool pages
The 2015-08-30 21:41:17 9367 InnoDB [Note] : The InnoDB heap memory is disabled
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-30 21:41:17 9367 InnoDB [Note] : the Memory barrier is not 2
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Compressed tables use zlib 1.2.3
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Using Linux native AIO
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Using CPU crc32 instructions
The 9367 21:41:17 2015-08-30 [Note] NDB Index Stat: Starting...
The 9367 21:41:17 2015-08-30 [Note] NDB Index Stat: Wait for the server start completed
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Initializing buffer pool, size=128.0 M
The 2015-08-30 21:41:17 InnoDB [Note] : 9367 Completed initialization of buffer pool
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Highest supported file format is Barracuda.
The 9367 21:41:17 2015-08-30 [Note] InnoDB: The log sequence Numbers 1626057 and 1626057 in ibdata files do not match The log sequence number 1626087 in The ib_logfiles!
The 9367 21:41:17 2015-08-30 [Note] InnoDB: the Database was not shutdown normally!
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Starting crash recovery.
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Reading in tablespace information from the. Ibd files...
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Restoring possible half - written data pages
The 2015-08-30 21:41:17 9367 [Note] InnoDB: from the doublewrite buffer...
21:41:17 InnoDB [Note] : 9367 2015-08-30 128 the rollback segment (s) are active.
The 2015-08-30 21:41:17 9367 [Note] InnoDB: Waiting for purge to start
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
