No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)
If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/replication-delayed.html
replication_connection_status: current status of the connection to the master, provides information on the last and current transaction the connection thread queued into the relay log. MySQL supports delayed replication such that a slave server ...
https://dev.mysql.com/replication-features-shutdowns.html
When a slave loses its connection to the master, the slave tries to reconnect immediately and retries periodically if that fails. A slave also is able to deal with network connectivity outages. It is safe to shut down a master server and restart it ...
https://dev.mysql.com/replication-group-members-table.html
The network addresses shown are the addresses used to connect clients to the group, and should not be confused with the member's internal group communication address specified by group_replication_local_address. This is the address which clients ...
https://dev.mysql.com/replication-gtids-auto-positioning.html
When a replication slave has GTIDs enabled (GTID_MODE=ON, ON_PERMISSIVE, or OFF_PERMISSIVE ) and the MASTER_AUTO_POSITION option enabled, auto-positioning is activated for connection to the master. The master must have GTID_MODE=ON set in order for ... GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between master and ...
https://dev.mysql.com/replication-gtids-howto.html
If you are starting with new servers, see Section 17.1.2.3, “Creating a User for Replication” for information about adding a specific user for replication connections and Section 17.1.2.1, “Setting the Replication Master Configuration” for ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/replication-howto-masterbaseconfig.html
If you set a server ID of 0 on a master, it refuses any connections from slaves, and if you set a server ID of 0 on a slave, it refuses to connect to a master. To configure a master to use binary log file position based replication, you must ensure ...
https://dev.mysql.com/replication-howto.html
On each slave that you want to connect to the master, you must configure a unique server ID. Configure the slave with settings for connecting to the master, such as the host name, login credentials, and binary log file name and position. This ...
https://dev.mysql.com/replication-implementation.html
Each slave that connects to the master requests a copy of the binary log. Because each slave is independent, the replaying of the changes from the master's binary log occurs independently on each slave that is connected to the master. Replication ...
https://dev.mysql.com/replication-multi-source-configuration.html
A multi-source replication topology requires at least two masters and one slave configured. In these tutorials, we will assume you have two masters master1 and master2, and a replication slave slavehost. The slave will replicate one database from ...
https://dev.mysql.com/replication-multi-source-monitoring.html
To monitor the connection status of all channels: mysql> SELECT * FROM replication_connection_status\G; *************************** 1. To monitor the connection status of a named channel, use a WHERE CHANNEL_NAME=channel clause: mysql> SELECT * FROM ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-connection-p-46.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
