Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-configuration.html
This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions.html
The functions described in the following sections are used with MySQL Replication.
https://dev.mysql.com/doc/refman/8.4/en/replication-security.html
To protect against unauthorized access to data that is stored on and transferred between replication source servers and replicas, set up all the servers involved using the security measures that you would choose for any MySQL instance in your ...In ...Encrypt the binary log files and relay log files on sources and replicas, which protects this data at rest, and also any data in use in the binary log ...
https://dev.mysql.com/doc/refman/8.4/en/show-binlog-events.html
Note Issuing a SHOW BINLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the binary log (which includes all statements executed by the server ...
https://dev.mysql.com/doc/refman/8.4/en/timezone-problems.html
This should be done for the environment in which the server runs (for example, in mysqld_safe or mysql.server). You can set the time zone for the server with the --timezone=timezone_name option to mysqld_safe. If you have a problem with SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/too-many-connections.html
If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other clients. By granting the privilege to administrators and not to normal users (who should not need it), ...The permitted number of connections is controlled by the max_connections system ...
https://dev.mysql.com/doc/refman/8.4/en/updating-yum-repo.html
Upgrading MySQL Upgrade MySQL components using standard yum (or dnf) commands, such as MySQL Server: sudo yum update mysql-server For platforms that are dnf-enabled: sudo dnf upgrade mysql-server Alternatively, you can update MySQL by telling Yum to ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version using the old data files) with the MySQL Yum ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-crashing.html
If you have examined all other possibilities and concluded that the MySQL server or a MySQL client is causing the problem, it is time to create a bug report, see Section 1.6, “How to Report Bugs or Problems”. Other programs that are not related ...This can normally be checked by pressing the Caps Lock ...
https://dev.mysql.com/doc/refman/8.4/en/windows-and-ssh.html
This section describes how to get an encrypted connection to a remote MySQL server with SSH. Either do a remote forward (Set local_port: 3306, remote_host: yourmysqlservername_or_ip, remote_port: 3306 ) or a local forward (Set port: 3306, host: ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...