Search found 14 matches

by didds1962
2021/05/06 15:35:56
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: mysql replication problems

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
by didds1962
2021/05/06 11:48:21
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: DRBD "failing"?

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
by didds1962
2021/05/05 15:15:40
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: DRBD "failing"?

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...
by didds1962
2021/05/05 07:57:51
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: DRBD "failing"?

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.
by didds1962
2021/05/04 12:39:57
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: DRBD "failing"?

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...
by didds1962
2021/05/04 12:03:43
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: DRBD "failing"?

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
by didds1962
2021/05/04 12:03:05
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: DRBD "failing"?

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 ...
by didds1962
2021/05/04 09:49:49
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: DRBD "failing"?

MASTER: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default-storage-engine=MYISAM symbolic-links=0 bind-address=10.108.248.162 max_connections=1500 max_user_connections = 150 binlog_cache_size = 131072 key_buffer_size = 32M max_allowed_packet = 1024M table_definition_cache = 163...
by didds1962
2021/05/04 07:08:39
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: DRBD "failing"?

You have to set it up properly or not at all. You either have to run the commands manually each time you start up to make the DRBD device primary and mount it/whatever. You have to make sure it's not primary and mounted on the other system even momentarily. Doing so will corrupt the filesystem meta...
by didds1962
2021/04/29 18:01:36
Forum: CentOS 7 - General Support
Topic: mysql replication problems
Replies: 19
Views: 579

Re: DRBD "failing"?

the drbdam has been run when it was initally set up etc etc etc. Are you meaning that it needs to run everytime it boots eg in a rc script or similar? I'm rather loath to spend more time to test the entire setup all the way through (as you describe) if the whole thing fails/falls apart because we ha...

Go to advanced search