Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
There are some generic tasks that are common to all setups: On the source, you must ensure that binary logging is enabled, and configure a unique server ID. Note Certain steps within the setup process require the SUPER privilege. This section ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Thus, only row-based logging should be employed for any new MySQL Replication setups. For the greatest possible durability and consistency in a replication setup that uses InnoDB with transactions, use these settings: sync_binlog=1. Startup Options ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
When this is true for all replicas, they can be reconfigured to the new setup. Once the new replication setup is in place, you need to tell each Web Client to direct its statements to Replica 1. You can tell a replica to change to a new source ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
RESET BINARY LOGS AND GTIDS without the TO clause can prove useful when you first set up a source and replica, so that you can verify the setup as follows: Start the source and replica, and start replication (see Section 19.1.2, “Setting Up Binary ... Note This statement takes the place of the old RESET MASTER statement, which is no longer ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
To backup a replica database, add the --replica-info option to your backup command. To restore the backup on a replica server, follow the same steps outlined in Section 8.1, “Setting Up a New replica”. MySQL Enterprise Backup does not include ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-group-replication.html
When working with a Group Replication setup, mysqlbackup makes the backup information available to all members of the server group by making sure that the backup_history, backup_sbt_history (when using the SBT API), and backup_progress tables are ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-wait-setup: Time (in seconds) for MySQL server to wait for NDB engine setup to complete. ndb-blob-read-batch-bytes: Specifies size in bytes that large BLOB reads should be batched into. ndb-blob-write-batch-bytes: Specifies size in bytes that ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
Page Setup: Enables you to set the paper size, orientation, and margins for printing purposes. Some menu items are not available in the MySQL Workbench Community Edition of this application, and are available only in the MySQL Workbench Commercial ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
MySQL Workbench represents each active data model as an icon in the models view of the home screen tab. Both models derive from MySQL database samples (see https://dev.mysql.com/doc/index-other.html), which you can download and use to explore the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers-macos.html
See the FreeTDS setup notes for Linux, Section 10.5.2.2, “Linux”.