mysql-master-slave - Related information

• With regard to mysql master-slave replication, the master library restarts the log-bin file, position changes, can only manually update the slave library?

  background: Ali CVM, multiple instances of mysql built on a single host question: when tampering with master-slave replication, it is found that the log-bin file and position will change with the restart of the master library. Can only manually update...

  Linux-operation-and-maintenance php mysql--configure mysqldb mysql-master-slave

  Jun.01,2022
• Ask a relatively bad question of master-slave synchronization in the database.

  question 1 is the transmission between master and slave databases encrypted? If not, can it be set manually? question 2 can I configure the master-slave database in this way? Master database is placed in the cloud, such as Ali; slave databa...

  Mysql mysql-master-slave

  Mar.30,2022
• How does the MYSQL master and slave Synchronize automatically clean up the logs?

  at present, the master and slave Synchronize of MYSQL has been done. Now we are considering the issue of log capacity, which has been exploded by binlog. Master-slave mysql-bin and slave relay logs exist. I would like to ask if there is a way to automat...

  Mysql-master-slave mysql java

  Mar.28,2022
• Ask for advice, mysql master-slave replication, after the master table inserts data, the slave table is not Synchronize, and the status is abnormal

  The problem goes something like this: mysql master-slave replication. After configuration, check that the slave table has a normal status: Slave_IO_Running: Yes Slave_SQL_Running: Yes then insert data into the master table without Synchronize, an...

  Mysql mysql-master-slave operation-and-maintenance linux server

  Mar.28,2021
• When mysql is the master and slave of Synchronize, the incremental data is through binlog Synchronize, so how did the original data get past Synchronize?

  as mentioned above, after starting the master-slave Synchronize, the master may not have all the binlog, so how is the original data transmitted to the slave? for example, if there are 5000 data items on master, and then binlog and master-slave Synchron...

  Mysql-master-slave mysql

  Mar.18,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b313e3-2bd5f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b313e3-2bd5f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?