Forum Stats

  • 3,874,176 Users
  • 2,266,677 Discussions
  • 7,911,754 Comments

Discussions

Mysql innodb cluster broken after server reboot

User_F5BDX
User_F5BDX Member Posts: 4 Green Ribbon

Request help.

I've 3 instances in my cluster : 1 primary(rw) and 2 secondary(rw). Due to maintenance I had to reboot all 3 instances. After reboot cluster doesnt startup. Before shutting down servers, I had executed shutdown for each instance

mysqladmin -S /tmp/mysql.sock --user=root --password='xxxxx' shutdown

Answers

  • User_F5BDX
    User_F5BDX Member Posts: 4 Green Ribbon

    In primary instance log I see these errors :

    2022-11-13T03:41:19.233621Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 4306'

    2022-11-13T03:41:19.273870Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 4306'

    2022-11-13T03:41:32.943861Z 2 [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group'

    2022-11-13T03:41:32.944022Z 2 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'

    2022-11-13T04:17:01.950967Z 231 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.31-commercial).

  • User_F5BDX
    User_F5BDX Member Posts: 4 Green Ribbon

    I Was able to start up cluster. Connected to primary changed group_replication_bootstrap_group to "ON" and executed "start group_replication" . Executed same cmd without changing system variable