Database Solutions

Install and Configure mysqlbackup in Mysql Enterprise Edition When you are using MySQL  Enterprise Edition ,You can check online utility mysqlbackup for taking online backup for the MySQL backup. In this blog, We will discuss about installation and configuration of the mysqlbackup.  1) Download the mysqlbackup rpm from the oracle.support.com 2) Install mysqlbackup on the server using below command dpkg -i mysql-commercial-backup_*.deb 3) Create backup admin user for taking backup. CREATE USER 'backupadmin'@'localhost' IDENTIFIED BY '**************'; GRANT SELECT ON *.* TO 'backupadmin'@'localhost'; GRANT BACKUP_ADMIN ON *.* TO 'backupadmin'@'localhost'; GRANT SELECT ON performance_schema.variables_info TO 'backupadmin'@'localhost'; GRANT SELECT ON performance_schema.log_status TO 'backupadmin'@'localhost'; GRANT RELOAD ON *.* TO 'backupadmin'@'localhost'; GRANT CREATE...

Rebuild a corrupted/filed MySQL InnoDB Node For MySQL DBA its a common issue that one of the MySQL InnoDB Cluster node got corrupted. In that case we need to restore MySQL cluster node from mysqlbackup. Usually backup in MySQL InnoDB cluster is taken from one of the node in the cluster, if the node corrupted and backup node are same then you can simply restore the backup and start group replication.  But if the backup is node taken from the corrupted node and even after restoration of the backup to corrupt node ,Node is unable to join the Group Replication. In that case, We need to rebuild that node from the backup of the existing node. In this blog we will discuss about the same scenario. Assume that we have three MySQL node mysqlhost01,mysqlhost02 & mysqlhost03. And the node which got corrupted is mysqlhost03 and backup is taken from the mysqlhost02.We will follow below steps to restore failed node mysqlhost03: 1) Move the MySQL backup from mysqlhost02 to mysqlhost03. 2) Cha...

Restoring a Failed member in InnoDB Cluster For MySQL DBA its a common issue that one of the MySQL InnoDB Cluster node got corrupted. In that case we need to restore MySQL cluster node from mysqlbackup. Usually backup in MySQL InnoDB cluster is taken from one of the node in the cluster, if the node corrupted and backup node are same then you can simply restore the backup and start group replication.  But if the backup is node taken from the corrupted node ,We need to take some additional steps. In this blog we will discuss about the same scenario. Assume that we have three MySQL node mysqlhost01,mysqlhost02 & mysqlhost03. And the node which got corrupted is mysqlhost03 and backup is taken from the mysqlhost02.We will follow below steps to restore failed node mysqlhost03: 1) Move the MySQL backup from mysqlhost02 to mysqlhost03. 2) Change parameter group_replication_start_on_boot to false. set parameter group_replication_start_on_boot to false so that post MySQL restart Grou...

Restore MySQL InnoDB Cluster from mysqlbackup(MySql Enterprise Backup) 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 todays blog , We will discuss about the restoration of the full InnoDB Cluster restoration. I nnoDB MySQL cluster restoration is done in two steps: 1)  Restore MySQL DB Backup on the first node of the Cluster. For that you can check our blog Restore MySQL Database from mysqlbackup. 2) Recreate and Start Cluster. We will follow below steps for Recreation of MySQL InnoDB Cluster . 2.1) Check if Cluster Admin user existing on the restore node in Step 1 select   User , Host from   user where User like '%cluster%' ;   2.2)  Perform MySQL InnoDB Cluster Prechecks mysqlsh --log-level=DEBUG3 dba.verbose=2 dba.checkInstanceConfiguration('clusteradmin@mysqlhost01:3306') dba...