Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Tables are created or their structure modified, and data is inserted, deleted, and updated according to the changes that were originally made on the source. Replication is based on the source server keeping track of all changes to its databases ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source.html
In a multi-source replication topology, a replica creates a replication channel for each source that it should receive transactions from. Multi-source replication in MySQL 8.4 enables a replica to receive transactions from multiple immediate ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-gr.html
For example: mysql> STOP GROUP_REPLICATION; mysql> CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = 'gr_repl'@'%.example.com' FOR CHANNEL 'group_replication_recovery'; mysql> FLUSH PRIVILEGES; mysql> START GROUP_REPLICATION; For Group ... You ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups.html
Using the raw data files option also means that you can back up the binary and relay logs that make it possible to re-create the replica in the event of a replica failure. To use replication as a backup solution, replicate data from the source to a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-partitioning.html
Use mysqldump to create a separate dump file for each database and load the appropriate dump file on each replica. There may be situations where you have a single source server and want to replicate different databases to different replicas. For ...
https://dev.mysql.com/doc/refman/8.4/en/reset.html
The following list describes the permitted RESET statement reset_option values: RESET BINARY LOGS AND GTIDS Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file.
https://dev.mysql.com/doc/refman/8.4/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. For example, these two statements ...
https://dev.mysql.com/doc/refman/8.4/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.
https://dev.mysql.com/doc/refman/8.4/en/selinux-file-context.html
Installing the MySQL Server RPM creates a /var/lib/mysql-files/ directory but does not set the SELinux context for it. The MySQL Server reads from and writes to many files. If the SELinux context is not set correctly for these files, access to the ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. The optimizer uses semijoin strategies to improve subquery execution, ...