there are three existing servers (all mysql5.7 installed by centos7,): br 10.19.6.6 BRV 192.168.3.101 CRAV 192.168.3.102 use xtrabackup to back up A s MYSQL data, then restore to B A s database to deactivate, and B updates the primary database d...
problem description take over a new database, today found table data 50G, and then various indexes 75G, of which three large indexes are each around 23g, and most of the large indexes are bound to timestamps. what result do you expect? What is the e...
for example, in the master-slave replication architecture of mysql, SQL threads often fail to execute and lead to replication being stranded. I want to know how people generally deal with this situation ...
High performance MySQL (3rd edition, 1st edition, May 2013) on page 390, it is mentioned that the current generation of RDBMS technology has been optimized for mechanical hard drives for decades, and the same mature and in-depth research work has not re...