Search Results
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
mysql> SELECT USER(), CURRENT_USER(); +------------------+-------------------+ | USER() | CURRENT_USER() | +------------------+-------------------+ | myuser@localhost | manager@localhost | +------------------+-------------------+ For simplicity, ...
https://dev.mysql.com/doc/refman/8.4/en/recovery-from-backups.html
To not lose them, we would have needed to have the MySQL server store its MySQL binary logs into a safe location (RAID disks, SAN, ...) different from the place where it stores its data files, so that these logs were not on the destroyed disk. Now, ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.4/en/replica-io-thread-states.html
Waiting to reconnect after a failed binlog dump request If the binary log dump request failed (due to disconnection), the thread goes into this state while it sleeps, then tries to reconnect periodically. The following list shows the most common ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
When the feature is disabled, you do not need to configure the replication channel on the secondary group members, but if the primary goes offline or into an error state, replication stops for the channel. You can use the asynchronous connection ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/replication-features-flush.html
If you replicate the privilege tables in the mysql database and update those tables directly without using GRANT, you must issue a FLUSH PRIVILEGES on the replicas to put the new privileges into effect. Some forms of the FLUSH statement are not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
If the issue is only missing transactions on the source, you can make the source into a replica instead, allow it to catch up with the other servers in the replication topology, and then make it a source again if needed. GTIDs replace the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
Copy the contents of the existing replica's relay log index file into the new replica's relay log index file, making sure to overwrite any content already in the file. You can add another replica to an existing replication configuration without ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-provision-replica.html
For example: sed '/GTID_PURGED/d' dumpM1.sql > dumpM1_nopurge.sql sed '/GTID_PURGED/d' dumpM2.sql > dumpM2_nopurge.sql Use the mysql client to import each edited dump file into the replica. If the sources in the multi-source replication topology ...