CentOS

though meanwhile if anybody has any answers to my actual underlying query feel free to jump in

Corosync Cluster Engine, version '2.4.5'
pcs version 0.9.169
centos 7.9.2009

aha!

found one

https://lists.clusterlabs.org/mailman/listinfo/users

Is there a generic pacemaker forum for queries? In short I trying to find out exactly what the impact/point of such cluster error messages as from running pcs status mysql_VIP01_monitor_30000 on wp-vldyn-rafeiro 'unknown error' (1): call=467, status=Timed Out, exitreason='', last-rc-change='Mon Oct ...

k... no errors currently (double yes scenario).

though its not yet "caught up" as demonstrated by the heartbeat check still being out.


Next time...


didds

If you do the set global sql_slave_slip_counter then it skips over a replication packet. What happens if you do not do that? show slave status \G never moves on. It continues to show the same error. Are you running the same version of the server at both ends of the connection? yes. cheers ian

And when it stops, what do you have to do to restart it? Is it as simple as stop slave;start slave; ? Or more complicated. My first - and so far only - thought when I saw your log was that you have a duplicate ip address on the network, either slave or master end, so that it occasionally talks to t...

I just checked - mysql logging is set to its maximum level of 3 (by default).

last night we reset replication from scratch - broke slave, dumped with master host status and locked tables etc, copied then imported and reset slave ...

still saying its broken wrt the heartbeat check.

Im in despair.

looking in mysqld.log there are no errors showing that we typically see when trying show slave status \G etc (replication now allegedlty fine as noted before) - but there is a lot of this going on... 2021-04-29T07:58:19.472259Z 11491 [Warning] Storing MySQL user name or password information in the m...

TrevorH wrote: ↑

2021/05/04 10:46:40

Edit: actually this may only be required if you're running in master-master mode

ah - no its not. master-slave. so not needed after all?

cheers

ian

First thing that springs out at me is that you do not have auto_increment_increment = 2 auto_increment_offset = x on either side and you need them. The offset should be even on one side and odd on the other (i.e 1 and 2) so that it never tries to insert rows with duplicate ids. All your replicated ...