Ubuntu-fr

dennis_fr

mysql ne démarre plus à l'activation du cluster

Bonjour,

J'ai installé mysql cluster sur 3 nœuds: 2 nœuds data et 1 nœud SQL et Management en même temps.
Le service mysql démarre sans problème sur les 3 noeuds quand le cluster n'est pas actif c'est à dire quand je commente les lignes suivantes de mysqld.cnf:

# Run ndb storage engine
#ndbcluster
# IP address management node
#ndb-connectstring=10.25.160.53

[mysql_cluster]
# IP address management node
#ndb-connectstring=10.25.160.53

Dans les log de mysql, je trouve les lignes suivantes:

2017-06-06T08:58:18.213414Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-0ubuntu0.16.04.1) starting as process 57731 ...
2017-06-06T08:58:18.222063Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-06-06T08:58:18.222157Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-06-06T08:58:18.222178Z 0 [Note] InnoDB: Uses event mutexes
2017-06-06T08:58:18.222193Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-06-06T08:58:18.222207Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-06-06T08:58:18.222220Z 0 [Note] InnoDB: Using Linux native AIO
2017-06-06T08:58:18.222688Z 0 [Note] InnoDB: Number of pools: 1
2017-06-06T08:58:18.222923Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-06-06T08:58:18.225767Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-06-06T08:58:18.242757Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-06-06T08:58:18.246277Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2017-06-06T08:58:18.259300Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-06T08:58:18.275134Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-06-06T08:58:18.275292Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait
2017-06-06T08:58:18.308780Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-06-06T08:58:18.310534Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-06-06T08:58:18.310592Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-06-06T08:58:18.311602Z 0 [Note] InnoDB: Waiting for purge to start
2017-06-06T08:58:18.361886Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2778905
2017-06-06T08:58:18.362601Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-06-06T08:58:18.363059Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-06-06T08:58:18.363668Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170606  9:58:18
2017-06-06T08:58:18.368387Z 0 [ERROR] unknown option '--ndbcluster'
2017-06-06T08:58:18.368448Z 0 [ERROR] Aborting

Quelqu'un peut m'aider SVP?

MERCI

Modération : merci à l'avenir d'utiliser les balises code (explications ici).

Dernière modification par cqfd93 (Le 06/06/2017, à 18:56)

dennis_fr

Re : mysql ne démarre plus à l'activation du cluster

J'ajoute que les noeuds sont bien reconnus au niveau du management du cluster comme suite:

id=2 (not connected, accepting connect from 10.25.160.51)
id=3    @10.25.160.52  (mysql-5.6.31 ndb-7.4.12, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @10.25.160.53  (mysql-5.6.31 ndb-7.4.12)

Modération : merci à l'avenir d'utiliser les balises code (explications ici).

Dernière modification par cqfd93 (Le 06/06/2017, à 18:55)