Questions tagged [master-slave-replication]
The master-slave-replication tag has no summary.
294 questions
0 votes
0 answers
32 views
Should I Switch from Master–Slave to Master–Master Database Replication in VoIP Environments?
I have two Asterisk+FreePBX servers that share a common database. The services are active on one server at a time, and in the event of a failure of the main server, the services are then started on ...
- 1
0 votes
0 answers
32 views
MariaDB replication issue between versions 10.6.19 (master) and 10.11.10 (slave)
I’m running into a replication problem between two MariaDB servers: Master: MariaDB 10.6.19 Slave: MariaDB 10.11.10 Replication appears to start correctly. SHOW SLAVE STATUS\G under the slave shows ...
- 1
0 votes
0 answers
27 views
Infinite Loop in SQL Server Merge Replication When Using Delete + Insert for Detail Records
I have a typical master-detail table relationship (e.g., Orders and OrderDetails). My application updates the detail records by: Deleting all existing detail records for a given master record. ...
0 votes
0 answers
17 views
mariadb replication main > replica1 > replica2 ... troubleshooting
I have very few experience with MariaDB and am on call with a main > replica1 > replica2 situation where I have binlogs directory running full. my question is ... can I switch of the 2nd replica ...
- 293
0 votes
0 answers
71 views
MySQL multi-source replica with GTID enabled in unrecoverable state when rotating relay logs
MySQL multi-source replica server restarts quite frequently on midnight due to not finding relay log files. This also stops replication channels and they need to be reset to start them up again. Has ...
- 1
0 votes
0 answers
21 views
Does MySQL InnoDB cluster allow data lost by default?
Group replication use asynchronies replication by default (https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html#sysvar_group_replication_consistency). Does it mean, by ...
- 155
0 votes
1 answer
281 views
Switch to master auto position from master_log_file and master_log_pos MySQL 5.7.44
MySQL Server - 5.7.44 I have a master and three slaves running on MySQL 5.7.44. The GTID is enabled and I am using gtid_enforce_consistency. I took a backup from a slave and built a fourth slave using ...
- 216
1 vote
0 answers
44 views
Master - Slave - Galera cluster
The current setup is comprised of two nodes, a Master-Slave setup. No encryption, no compression. I would love to switch this to a Galera Cluster, with encryption, compression and, to make things ...
