Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
Before setting the replication mode of an online server, it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-disable-gtids.html
This section describes how to disable GTID transactions on servers that are already online. This procedure does not require taking the server offline and is suited to use in production. However, if you have the possibility to take the servers ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules.html
If a replication source server does not write a statement to its binary log, the statement is not replicated. If the server does log the statement, the statement is sent to all replicas and each replica determines whether to execute it or ignore it. On the source, you can control which databases to log changes for by using the --binlog-do-db and --binlog-ignore-db options to control binary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
Before you proceed, ensure that you have: Configured the source with the necessary configuration properties. Obtained the source status information, or a copy of the source's binary log index file made during a shutdown for the data snapshot. On the ...
https://dev.mysql.com/doc/refman/8.4/en/replication.html
Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as replicas). Replication is asynchronous by default; replicas do not need to be connected permanently to receive ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. SET column values that consist of multiple set members are specified with members ...
https://dev.mysql.com/doc/refman/8.4/en/source-thread-states.html
The following list shows the most common states you may see in the State column for the Binlog Dump thread of the replication source. If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.incremental.html
Note The --incremental option is not needed when restoring an incremental backup. There are different ways to use incremental backups to restore a database server under different scenarios. The --backup-dir option is used to specify the temporary ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-codes.html
The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set column. For input, buffer_type indicates the type of the variable containing the value to be sent to the ...