Search Results
https://dev.mysql.com/doc/refman/8.4/en/purge-binary-logs.html
PURGE BINARY LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. This statement has no effect if the server was not started with the --log-bin ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-relaylog.html
For the default replication channel, relay log file names have the default form host_name-relay-bin.nnnnnn, where host_name is the name of the replica server host and nnnnnn is a sequence number. This causes the names to be independent of server ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs.html
A replica server creates several repositories of information to use for the replication process: The replica's relay log, which is written by the replication I/O (receiver) thread, contains the transactions read from the replication source server's ...The transactions in the relay log are applied on the replica by the replication SQL (applier) ...
https://dev.mysql.com/doc/refman/8.4/en/replication-configuration.html
For a guide to setting up two or more servers for replication using GTID transactions, Section 19.1.3, “Replication with Global Transaction Identifiers”, deals with the configuration of the servers. This section describes how to configure the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can cause problems if no corresponding directory exists in the replica host file system ...The result is that MyISAM data and index files are created in the table's database ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-shutdowns.html
It is safe to shut down a replication source server and restart it later. Setting sync_binlog=1 in the source server's my.cnf file helps to minimize this problem because it causes the source to flush its binary log more frequently. A similar ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions.html
The functions described in the following sections are used with MySQL Replication.
https://dev.mysql.com/doc/refman/8.4/en/replication-security.html
To protect against unauthorized access to data that is stored on and transferred between replication source servers and replicas, set up all the servers involved using the security measures that you would choose for any MySQL instance in your ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before halting. Updates to the applier metadata repository are committed ...This ...
https://dev.mysql.com/doc/refman/8.4/en/security-plugins.html
MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. (MySQL Enterprise Edition only) MySQL Enterprise Audit, implemented using a server plugin, ...