PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-if-not-exists.html
IF NOT EXISTS statements are replicated: Every CREATE DATABASE IF NOT EXISTS statement is replicated, whether or not the database already exists on the source. Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto.html
There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data in the database on the source that you want to replicate. If you do not ... This section describes how to set up a MySQL server to use binary log file position based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-adding-binlog-master.html
These steps assume that binary logging is enabled on the source (which is the default), the replica is using TABLE based replication applier metadata repositories (which is the default in MySQL 8.0), and that you have enabled a replication user and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the sources using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication applier metadata repositories, and provisioned the replica with data ...
https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Many users have lost time by not doing this soon enough after encountering problems. If you cannot tell from ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions.html
For performance or data distribution reasons, you may want to replicate different databases to different replicas. See Section 19.4.6, “Replicating Different Databases to Different Replicas” As the number of replicas increases, the load on the ... Replication can be used in many different environments for a range of ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin.html
The Rewriter plugin uses a database named query_rewrite containing a table named rewrite_rules. The query_rewrite database contains a stored procedure named flush_rewrite_rules() that loads the contents of the rules table into the plugin. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
Make sure that the only Unix user account with read or write privileges in the database directories is the account that is used for running mysqld. With this privilege, you can read any file into a database table. When you connect to a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) against all types of applicable attacks: eavesdropping, altering, playback, and denial of service. When running MySQL, follow ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
You can refer to a table within the default database as tbl_name, or as db_name.tbl_name to specify a database explicitly. SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] ...