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

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

Restore MySQL Database from mysqlbackup

Image
 Restore MySQL Database from mysqlbackup  In todays world, One of the most common activity is to perform database restore using old backup or performing PIT recovery for database.  In this blog , We will show you how to perform restore and recovery of the MySQL database using backup taken via mysqlbackup. In order to restore Mysql database from MySQL backup , We will follow below steps: 1) Shut down MySQL Database Server/Service Check the status of the mysql service using command : systemctl status mysql Shut down mysql service using command : systemctl stop mysql 2) Delete all existing file of MySQL Server Delete all files inside the server's data directory. Also delete all files inside the directories specified by the --innodb_data_home_dir, --innodb_log_group_home_dir, and --innodb_undo_directory options for restore, if the directories are different from the data directory. 3) Restore full Backup mysqlbackup  --defaults-file=/etc/mysql/mysql.conf.d/mysqld.cnf --d...
Read more

Add or Remove a node in MySQL Innodb Cluster

Add or Remove a node in MySQL Innodb Cluster In any database Cluster Solution ,it's regular activity to add or remove node from the cluster. In this blog , We will discuss about addition and removal of the cluster node from the MySQL Innodb cluster. Remove a node from the MySQL Innodb cluster . 1) Connect to primary node and check status. mysqlsh --uri clusteradmin@mysqlhost01:3306 MySQL  mysqlhost01:3306 ssl  JS > cluster.status() {     "clusterName": "mysqlcluster",     "defaultReplicaSet": {         "name": "default",         "primary": "mysqlhost01:3306",         "ssl": "REQUIRED",         "status": "OK",         "statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",         "topology": {     ...
Read more