Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
In the following section, we provide answers to questions that are most frequently asked about MySQL Replication. Must the replica be connected to the source all the time? A.14.2. Must I enable networking on my source and replica to enable ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
There is also the Secure Deployment Guide, which provides procedures for deploying a generic binary distribution of MySQL Enterprise Edition Server with features for managing the security of your MySQL installation. Where can I find documentation ...
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
To add a collation for full-text indexing, use the following procedure. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
[mysqld] # # Disable other storage engines # disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" # # Replication configuration parameters # server_id=2 gtid_mode=ON enforce_gtid_consistency=ON # # Group Replication configuration # ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-connection-security.html
MySQL 8.4 Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-instances.html
The first step is to deploy at least three instances of MySQL Server, this procedure demonstrates using multiple hosts for the instances, named s1, s2, and s3. It is assumed that MySQL Server is installed on each host (see Chapter 2, Installing ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. The most recent backup of group member s2 can be used to restore s3. Here are the steps for performing the restore: Copy the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
Warning This procedure uses group_replication_force_members and should be considered a last resort remedy. The group needs to achieve consensus whenever a change that needs to be replicated happens. This is the case for regular transactions but is ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-plugin-architecture.html
The recovery component manages distributed recovery, and is responsible for getting a server that is joining the group up to date by selecting the donor, managing the catch up procedure and reacting to donor failures. MySQL Group Replication is a ...