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 database is in the same local local area network (not a fixed public network IP).

question 3

if question 2 can, then, if slave A changes, can synchronize directly with slave B after synchronization with master is completed, that is, direct synchronization between local databases, master does not participate in

Mysql mysql-master-slave

Mar.30,2022

can be. Just enable ssl encryption.
Yes.
Yes.

Previous: How do redux asynchronous requests state and props be properly controlled?

Next: Wechat developer tool, the necessary files are missing, please uninstall and reinstall

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

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-1b2bb9a-33e85.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-1b2bb9a-33e85.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?