MySQL master-slave replication, SSL-based master-slave replication, master-master replication, and semi-synchronous Replication

Master-slave Replication refers to a master server with one or more servers as slave servers. The slave server does not write any data. The data source is the master server. The purpose of replication is

Master-slave Replication refers to a master server with one or more servers as slave servers. The slave server does not write any data. The data source is the master server. The purpose of replication is

The slave server does not need to close the binary log or the account relay log, because the server will automatically open or close your account. If binary logs are not disabled, the SQL statements copied from the master server are not recorded in binary logs during execution. Only the SQL statements executed on the local machine are used ,, to be recorded in binary logs. Relay logs are stored in the data directory by default, with the file name being host name. relay-00000N. If you want to save it to another location, you can specify it in the configuration file.