Questions tagged [master-slave]
The master-slave tag has no usage guidance.
6
questions
0
votes
0
answers
126
views
MySQL slave replication fails with error code 1032
We are running a MySQL DB master server version 8.0.36-0ubuntu0.22.04.1 and MySQL DB slave server version 8.0.39-0ubuntu0.22.04.1, where replication fails after a few hours with this in /var/log/mysql/...
0
votes
0
answers
39
views
How do I convert master-slave to multimaster database replication in MySQL?
Currently, I have one master and two slaves in my setup. How can I convert it so that I have three masters instead? I need all three nodes to be writable and to update each other accordingly.
Most of ...
0
votes
0
answers
51
views
MASTER-MASTER replication failed on Production: Coordinator stopped because there were error(s) in the worker(s) [duplicate]
I'm not DBA but under my responsiblity to fix this issue. cause we are small company
I need help to fix this issue
could not find related issue on forums
ERROR occured after I was importing dump DB to ...
0
votes
1
answer
132
views
High Availability postgres db cluster with Patroni and Etcd
I am building a HA Postgres db cluster with one master and multiple slaves. Please look at the below points and correct me if I am wrong:
For each slave node, I need to use pg_basebackup to sync and ...
0
votes
1
answer
256
views
Myloader error during Restorin MariadDB Slave: Duplicate entry 'ТОБАР' for key 'UX_B_SEARCH_STEM'
I have lost my slave. To restore it I have locked tables on the master host and then have created a dump using mydumper tool. After that I have tried to restore my slave using myloader tool but during ...
0
votes
1
answer
452
views
MySQL slave stuck at 'System lock'
We have Master-Slave replication but since +1h none changes are replicated because slave is stuck on 'System lock':
(dh@DB02) [(none)]> show slave status \G
*************************** 1. row ******...