Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-log-formats.html
With mixed logging, statement-based logging is used by default, but the logging mode switches automatically to row-based in certain cases as described below. In deciding whether or not a given statement is safe for statement-based replication, MySQL ... The server uses several logging formats to record information in the binary log: Replication capabilities in MySQL originally were based on propagation of SQL statements from source to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
If MySQL still has trouble starting because of InnoDB consistency problems, see Section 17.20.3, “Forcing InnoDB Recovery” for steps to start the instance in recovery mode, which permits you to dump the data. The current maximum auto-increment ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-sles-repo.html
Adding the MySQL SLES Repository Add or update the official MySQL SLES repository for your system's repository list: Note The beginning part of the configuration file name, such as mysql84, describes the default MySQL series that is enabled for ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-what-is-new.html
Previously, when SQL nodes performing binary logging used log_replica_updates=OFF, any replicated updates which were applied on a replica NDB cluster were sent on to the SQL nodes performing binary logging. These updates were not actually applied or ... What is New in NDB Cluster 8.4 Changes in NDB 8.x Innovation Releases The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
On the client side, an X Protocol connection request can specify several parameters for compression control: The compression mode. The connection mode has these permitted values: disabled: The connection is uncompressed. required: Compression ... X ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
When the client program connects, the server places the client session in sandbox mode if the device must be registered, so that registration must occur before anything else can be done. Sandbox mode used for FIDO/FIDO2 device registration is ...
https://dev.mysql.com/doc/mysql-installer/en/preface.html
This document describes MySQL Installer, an application that simplifies the installation and updating process for a wide range of MySQL products, including MySQL Workbench and MySQL Shell. If you use this software or hardware in dangerous ...If you ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-binary.html
This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by Oracle. For setting up a cluster using precompiled binaries, the first step in the installation process ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/set-replicaset-primary.html
Use the ReplicaSet.setPrimaryInstance() operation to safely perform a change of the primary of a ReplicaSet to another instance. All other secondary instances are updated to replicate from the new primary. For a safe change of the primary to be ...