PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. The default password is “no password.”) If you cannot connect to the server with those values (for example, if your account has a password), the ... MySQL Perl support requires that you have installed MySQL client programming support (libraries and header ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-binlog.html
After editing the file, apply the contents as follows: $> mysql -u root -p < tmpfile If you have more than one binary log to apply on the MySQL server, use a single connection to apply the contents of all binary log files that you want to process.
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
For EXPLAIN FOR CONNECTION, the output changes as follows if index dives are skipped: For traditional output, the rows and filtered values are NULL. Without FOR CONNECTION, EXPLAIN output does not change when index dives are skipped. The range ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
replication_connection_status: current status of the connection to the source, provides information on the last and current transaction the connection thread queued into the relay log. MySQL supports delayed replication such that a replica server ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
When a replica loses its connection to the source, the replica tries to reconnect immediately and retries periodically if that fails. A replica also is able to deal with network connectivity outages. It is safe to shut down a replication source ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
When a replica 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 source. The source must have GTID_MODE=ON set in order for the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html
If you are starting with new servers, see Section 19.1.2.3, “Creating a User for Replication” for information about adding a specific user for replication connections and Section 19.1.2.1, “Setting the Replication Source Configuration” for ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-implementation.html
Each replica that connects to the source requests a copy of the binary log. Because each replica is independent, the replaying of the changes from the source's binary log occurs independently on each replica that is connected to the source.
https://dev.mysql.com/doc/refman/8.0/en/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 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
If the server ID is set to 0, binary logging takes place, but a source with a server ID of 0 refuses any connections from replicas, and a replica with a server ID of 0 refuses to connect to a source. The following sections contain information about ...