Question

Failed Resource Actions: * ms_mysql_start_0 on centreon-slave 'error'

  • 5 April 2024
  • 2 replies
  • 13 views

Badge

Hello,

Having the following issue with Centreon HA seup

Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave', last-rc-change='2024-04-05 11:13:59 +02:00', queued=0ms, exec=2724ms

 

Can you please help?

 

Regards

Thery


2 replies

Userlevel 1
Badge +2

Hello, @thieryl

 

First, you can check that your user account used for the replication can be accessed from A to B and from B to A

Then, make sure there are no typos in the config files in /etc/centreon-ha/*
You can use the pcs config show command to check that the account configured for the ms_mysql resource is also correct

Once this is done, you'll need to run a sync again, so run :

pcs resource unmanage ms_mysql

Shutdown the MariaDB service on the server that's supposed to be the least up to date : 

mysqladmin -p shutdown  

And then run the sync script (on the most up-to-date server) :

/usr/share/centreon-ha/bin/mysql-sync-bigdb.sh

Then you can check the replication status with the following script who should return a similar result : 

/usr/share/centreon-ha/bin/mysql-check-status.sh
    Connection MASTER Status 'el8-central2-2310' [OK]
    Connection SLAVE Status 'el8-central1-2310' [OK]
    Slave Thread Status [OK]
    Position Status [OK]

Don't forget to remanage the resource : 

pcs resource manage ms_mysql

After that, if it doesn't restart and to make the cluster forget failed operations from history of the resource and re-detect its current state, execute the following commands: 

pcs resource enable ms_mysql
pcs resource clear ms_mysql
pcs resource cleanup ms_mysql

 

 

Hope it helps! 

Badge

The error you’re seeing means the backup server can’t copy data from the main server. To fix it, you need to check the main server’s log file, update the backup server’s settings to match the main server and restart the copying process. After that, make sure everything is copied correctly. It’s like making sure two clocks are set to the same time so they tick together. If you’re not sure how to do this, it’s best to ask a database expert for help. And remember, always back up your data first! Publix Passport

Reply