Skip to main content

Posts

Showing posts from August, 2021

MySQL InnoDB Cluster Limitations

  MySQL InnoDB cluster limitations: A group can consist of maximum 9 servers . Attempting to add another server to a group with 9 members causes the request to join to be refused. Limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old primary. Individual transactions that result in GTID contents which are large enough that it cannot be copied between group members over the network within a 5 second window can cause failures in the group communication . To avoid this issue try and limit the size of your transactions as much as possible. For example, split up files used with LOAD DATA INFILE into smaller chunks. Group Replication cannot currently make use of replication Event Checksums . The certification process does not take into account gap locks, table lock, and named locks . Setting a transaction isolation level to