Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-cluster-binary-log-purging.html
In MySQL 8, the binary log is automatically purged (as defined by binlog_expire_logs_seconds). This means that a cluster which has been running for a longer time than binlog_expire_logs_seconds could eventually not contain an instance with a ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-cluster-fencing.html
Following an emergency failover, and there is a risk of the transaction sets differing between parts of the ClusterSet, you have to fence the cluster either from write traffic or all traffic. If a network partition happens, then there is the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-rejoin.html
If an InnoDB Cluster is part of an InnoDB ClusterSet deployment, MySQL Shell automatically restores it to its role in the topology immediately after a reboot, provided that it is functioning acceptably and has not been marked as invalidated.
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-user-accounts.html
The member servers in an InnoDB Cluster make use of three types of user accounts. One InnoDB Cluster server configuration account is used to configure the server instances for the cluster. One or more InnoDB Cluster administrator accounts can be ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-clone-deployment.html
InnoDB Cluster integrates the MySQL Clone plugin to provide automatic provisioning of joining instances. The process of retrieving the cluster's data so that the instance can synchronize with the cluster is called distributed recovery. When an ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-working-with-cluster.html
This section explains how to change an InnoDB Cluster from single-primary to multi-primary mode or the other way around, how to remove server instances from an InnoDB Cluster, and how to dissolve an InnoDB Cluster that you no longer need. When you ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-clusterset-setting-options-channels.html
The following options can be set with clusterSet.createReplicaCluster() and cluster.setOption(): clusterSetReplicationConnectRetry: corresponds to the replication option SOURCE_CONNECT_RETRY. Specifies the interval in seconds between the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-dba-upgrade-metadata.html
As AdminAPI evolves, some releases might require you to upgrade the metadata of existing ClusterSets, ReplicaSets, and Clusters to ensure they are compatible with newer versions of MySQL Shell. For example, the addition of InnoDB ReplicaSet in ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-replicaset-setting-options-channels.html
The following options can be set with replicaSet.addInstance() and replicaSet.setInstanceOption(): replicationConnectRetry: corresponds to the replication option SOURCE_CONNECT_RETRY. Specifies the interval in seconds between the reconnection ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-replicaset.html
The AdminAPI includes support for InnoDB ReplicaSet, which enables you to administer a set of MySQL instances similarly running asynchronous GTID-based replication, which is completely transaction-based, to InnoDB Cluster. An InnoDB ReplicaSet ...