MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 101 to 110 of 113 total results

19.1.2.4 Obtaining the Replication Source Binary Log Coordinates

https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html

If the source has been running previously with binary logging disabled, the log file name and position values displayed by SHOW MASTER STATUS or mysqldump --master-data are empty. To configure the replica to start the replication process at the ...

19.1.6.5 Global Transaction ID System Variables

https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html

The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional information, see Section 19.1.3, “Replication with Global Transaction Identifiers”.

19.1.2.6 Setting Up Replicas

https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html

If you used mysqldump, start the replica server, ensuring that replication does not start by using the --skip-slave-start option, or from MySQL 8.0.24, the skip_slave_start system variable. Before you proceed, ensure that you have: Configured the ...

19.4.6 Replicating Different Databases to Different Replicas

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 ...

8.3.5 Reusing SSL Sessions

https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html

In addition to mysql and mysqlshow, SSL session reuse applies to mysqladmin, mysqlbinlog, mysqlcheck, mysqldump, mysqlimport, mysqlpump, mysqlslap, mysqltest, mysql_migrate_keyring, mysql_secure_installation, and mysql_upgrade. As of MySQL 8.0.29, ...

7.6.4.2 Using the Rewriter Query Rewrite Plugin

https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html

This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, mysqldump, and mysqlpump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...

15.4.1.3 SET sql_log_bin Statement

https://dev.mysql.com/doc/refman/8.0/en/set-sql-log-bin.html

mysqldump adds a SET @@SESSION.sql_log_bin=0 statement to a dump file from a server where GTIDs are in use, which disables binary logging while the dump file is being reloaded. SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether ...

8.4.1.3 SHA-256 Pluggable Authentication

https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better ...

6.2.7 Connection Transport Protocols

https://dev.mysql.com/doc/refman/8.0/en/transport-protocols.html

For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. This section describes how to ...

2.6 Installing MySQL Using Unbreakable Linux Network (ULN)

https://dev.mysql.com/doc/refman/8.0/en/uln-installation.html

If a change of build is involved, we recommend the backup be a dump (mysqldump or mysqlpump or from MySQL Shell's backup utility) just in case you need to rebuild your data after the new binaries are in place. Linux supports a number of different ...

Displaying 101 to 110 of 113 total results