PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
If data_dir/auto.cnf is not found, generate a new UUID and save it to this file, creating the file if necessary. The following sections contain information about mysqld options and server variables that are used in replication and for controlling ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-gr.html
From MySQL 8.0.19, as well as securing asynchronous and semi-synchronous replication, you may choose to use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group Replication. The group_replication_applier ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/replication-solutions-scaleout.html
Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() safe_reader_connect() safe_reader_statement() safe_writer_statement() safe_ in each function name means that the function takes care of ...
https://dev.mysql.com/doc/refman/8.0/en/reserved-accounts.html
During data directory initialization, MySQL creates user accounts that should be considered reserved: 'root'@'localhost: Used for administrative purposes. One part of the MySQL installation process is data directory initialization (see Section ...
https://dev.mysql.com/doc/refman/8.0/en/reset.html
The following list describes the permitted RESET statement reset_option values: RESET MASTER 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. reset_option: { MASTER | ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
The following example creates a simple rule to match statements that select a single literal value: INSERT INTO query_rewrite.rewrite_rules (pattern, replacement) VALUES('SELECT ?', 'SELECT ? + 1'); The resulting table contents look like this: ...
https://dev.mysql.com/doc/refman/8.0/en/role-names.html
Specifying a role with a non-'%' host part can be useful if you intend to create a name that works both as a role an as a user account that is permitted to connect from the given host. MySQL role names refer to roles, which are named collections of ...