Database Solutions

  MySQL InnoDB Cluster vs Oracle RAC: Which to Choose? As a Database Administrator, I have seen organizations struggle with one recurring question: Should we choose a cost-effective distributed database solution or invest in a premium enterprise-grade clustering architecture? Two technologies that frequently appear in this discussion are MySQL InnoDB Cluster and Oracle Real Application Clusters . Both solutions provide high availability, scalability, and fault tolerance, but they are designed with different goals, architectures, and operational complexities in mind. Choosing the wrong platform can lead to performance bottlenecks, unnecessary licensing costs, or operational challenges. This blog explains the differences between MySQL InnoDB Cluster and Oracle RAC from a DBA’s perspective, including architecture, performance, scalability, administration, cost, and ideal use cases. Understanding the Technologies What is MySQL InnoDB Cluster? MySQL InnoDB Cluster is Oracle’s ...

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