MySQL InnoDB cluster is a high-availability solution that provides automatic failover, disaster recovery, and scalability for MySQL databases. It uses the InnoDB storage engine which is a transactional and ACID-compliant storage engine for MySQL.
InnoDB cluster requires at least three MySQL server instances to form a cluster. These servers can be connected using a variety of network topologies such as single-primary, multi-primary, or even hybrid configurations.
MySQL server instances in an InnoDB cluster communicate with each other using a group replication communication protocol. This protocol ensures that all changes made to one MySQL instance are propagated to all other instances in the cluster. This ensures that data consistency is maintained across all nodes in the cluster.
In summary, the connection between MySQL and InnoDB cluster involves the use of the InnoDB storage engine, group replication communication protocol, and a network topology that enables the creation of a highly available, scalable, and resilient MySQL database cluster.
