Contact US

Comments

Post a Comment

Please do not enter any spam link in comment Section suggestions are Always Appreciated. Thanks.. !

Popular posts from this blog

Restart Innodb MySQL Cluster after Complete outage(All node Down)

Image
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...
Read more

Install & Configure MySQL Router - MySQL InnoDB Cluster

Image
Install & Configure MySQL Router -  MySQL InnoDB Cluster MySQL Router is one of the important component of MySQL InnoDB Cluster as it's used by applications to connect to the MySQL DBs running on cluster.  In this blog, We will show How we can install and configure MySQL Router either on application server or on dedicated server for MySQL Router. Below are the step to install and configure MySQL Router: 1) Install MySQL Router on the Server(In our case , We are restoring MySQL Router on the ubuntu server). Run command as root user : apt-get install MySQL-router 2) Bootstrap or Configure MySQL Router mysqlrouter --bootstrap clusteradmin@mysqlhost01:3306 --user=mysqlrouter In Case of any issue in configuring MySQL Router ,We can use -force option of the bootstrap. mysqlrouter --bootstrap clusteradmin@n4ldbdev5030:3306 --directory=/home/myrouter --user=mysqlrouter --force 3) Test Connectivity via MySQL Router. mysqlsh --uri clusteradmin@localhost:6446 you can learn more ...
Read more

Oracle RAC Grid Cluster Upgrade

Image
Oracle RAC Grid Cluster Upgrade As 12c Database version coming to EOS , it become important for DBAs to upgrade Oracle database and Grid Clusters to 19c. In this blog , We have come up with the steps to upgrade the Oracle RAC Grid Cluster.  Follow below steps to upgrade Oracle RAC Grid Cluster. 1)  Take backup of ASM information and ASM metadata backup. set line 240 col path for a30 col compatibility for a40 select INST_ID,group_number,NAME,COMPATIBILITY,STATE,total_mb,free_mb from gv$asm_diskgroup order by name; set line 240 col path for a30 select group_number,NAME,COMPATIBILITY,STATE,total_mb,free_mb from v$asm_diskgroup; set lines 200 pages 200 col name for a30 col path for a40 select name,path,state,mount_status,header_status from v$asm_disk order by path; set lines 200 set pages 9999 col path for a40 SELECT inst_id,name, header_status,OS_MB,TOTAL_MB,path FROM GV$ASM_DISK WHERE header_status <> 'MEMBER' order by OS_MB; ASM Metadata backup : ASMCMD [+] > md_backup...
Read more