Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
The Event Scheduler is controlled by the event_scheduler system variable (default ON), so events that are active on the original server run by default when the new replica starts up. To stop all events from running on the new replica, set the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...The following instructions describe how to do this for a source and for a ...
https://dev.mysql.com/doc/internals/en/x-protocol-use-cases-use-cases.html
Topics in this section: Prepared Statements with Single Round-Trip Streaming Inserts SQL with Multiple Resultsets Inserting CRUD Data in a Batch Cross-Collection Update and Delete Prepared Statements with Single Round-Trip In the MySQL ...Figure ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-combining-versions.html
Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of ...For example, if a member is running MySQL 8.4.8 then that is the version of the Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-pkg.html
Note Before proceeding with the installation, be sure to stop all running MySQL server instances by using either the MySQL Manager Application (on macOS Server), the preference pane, or mysqladmin shutdown on the command line. For example, for MySQL ... The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-general.html
A replication channel requires two MySQL servers acting as replication servers (one each for the source and replica). This means that the replication source MySQL server must be running with --binlog-format=ROW or --binlog-format=MIXED, as ...For ...
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/mysql-enterprise-backup/8.4/en/advanced.replica.html
MySQL Enterprise Backup allows you to set up a replica server (referred to as the “replica” below) by backing up the source server (referred to as the “source” below) and restoring the backup on a new replica, without having to stop the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers-windows.html
Microsoft Windows XP and newer includes at least one ODBC driver for Microsoft SQL Server, so additional actions are likely not required on your system. Multiple SQL Server driver options exist, as described in this section. Figure 10.39 Windows ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-ssl-wizard.html
In this simple example, MySQL Workbench is installed on the same host as the MySQL Server, and we created "C:\certs" on the system. This wizard helps create SSL certificates for both MySQL clients and MySQL servers. Start the SSL wizard from the ...