As of May 31, 2023, we have updated our Code of Conduct.

New answers tagged

0 votes

Write latency for adding an index on read replica

Since all writes occur on both the Primary and the Replica, it is unclear whether you will be saving anything. The Replica should normally be "readonly", but you should be able to turn it ...
Rick James's user avatar
  • 74.8k
0 votes

How to resolve GTID difference between Master and Slave servers in MariaDB replication using MaxScale?

I have found the solution in this article: I had to detect the last bin log from the Master node, and to execute the following ...
Lucian Tarbă's user avatar
0 votes

Does a single replica gives any performance improvement?

Using an ORM, The write on the replica are way faster because there is no need for constraint check : primary key, foreign key, etc... Be aware that there is lag between both server. You must take ...
bokan's user avatar
  • 204
0 votes

MySQL master slave replica interrupts after service restart or reboot

I had this issue and it wasn’t a delayed reconnect. It turned out that the permissions for the replication user account on each server allowing the slave to read the binlog index file on the master ...
user273973's user avatar

Top 50 recent answers are included