Database Solutions

Upgrade MySQL InnoDB Cluster  Database upgrade are day-to-day activity which DBA perform on regular basic either due to EOS or application demand. In today blog , We will discuss about upgrading MySQL Inno D B. Upgrade in case of the MySQL InnoDB cluster can be divided primarily into three steps: 1) Upgrade MyShell on all Cluster nodes. 2) Upgrade all the MySQL Routers configured with InnoDB Cluster. 3) Upgrade InnoDB metadata /Innodb metadata schema. 4) Upgrade Individual MySQL Server running on all Cluster nodes. Below is the details about all above steps: 1) Upgrade MySQL Shell on all Cluster node or server used to manage Cluter: cd /tmp curl -OL https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb dpkg -i mysql-apt-config* apt update apt-get update apt-get install mysql-shell Repeate above steps on all the server having MySQL-SHELL. Connect to Cluster using mysqlsh and run: var cluster = dba.getCluster() cluster.status() cluster.listRouters()    ==...

Restart Innodb MySQL Cluster after Complete outage(All node Down) In DBA World, Their could be activity(like DC Migration) where all node of an MySQL Innodb cluster need to brought down. In MySQL Innodb cluster, We need to follow below steps in order to bring up cluster. 1) Start all node in the MySQL Innodb cluster. systemctl start myql 2) Try to connect cluster using mysqlsh and check status. 3) Strat cluster using complete outage command. Restart Cluster using below command: var cluster = dba.rebootClusterFromCompleteOutage(); root@mysqlhost01:~# mysqlsh --uri clusteradmin@mysqlhost01:3306 Please provide the password for 'clusteradmin@mysqlhost01:3306': ************************ Save password for 'clusteradmin@mysqlhost01:3306'? [Y]es/[N]o/Ne[v]er (default No): MySQL Shell 8.0.17 Copyright (c) 2016, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of...

Installing and Configuring InnoDB Cluster  Now a days HA(High Availability) and DR(Disaster Recovery) Solutions are mandatory and required for mission critical databases. In  MySQL  world , HA solution are provided using the InnoDB or NDB Clustering Solution.  In this blog , We will discuss about the Installation and Configuration of the I nnoDB Cluster . Installation Standards and Prerequisites Before installing a production deployment of InnoDB cluster, ensure that the server instances you intend to use meet the following requirements. InnoDB cluster uses Group Replication and therefore your server instances must meet the same requirements. AdminAPI provides the dba.checkInstanceConfiguration() method to verify that an instance meets the Group Replication requirements, and the dba.configureLocalInstance() method to configure an instance to meet the requirements Group Replication members can contain tables using a storage engine other than Innodb, for example MyIS...

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...