Posts

Showing posts with the label Dissolve

Dissolve MySQL Innodb Cluster

Dissolve MySQL Innodb Cluster  In database world ,Decommissioning a database and DB Cluster is a regular activity. In case of MySQL Innodb cluster decommission a cluster is known as Dissolving a cluster. In this blog , We will discuss about how to dissolve a MySQL InnoDb Cluster . Dissolving MySQL InnoDB Cluster To dissolve an InnoDB cluster you connect to a read-write instance, for example the primary in a single-primary cluster, and use the Cluster.dissolve() command. This removes all metadata and configuration associated with the cluster, and disables Group Replication on the instances. Any data that was replicated between the instances is not removed. There is no way to undo the dissolving of a cluster, therefore you must pass force: true to confirm you want to dissolve the cluster. For example: to create it again use dba.createCluster(). var cluster = dba.getCluster() mysql-js> cluster.dissolve({force:true}) root@mysqlhost01:~# mysqlsh --uri clusteradmin@mysqlhost01:3...