Category Archives: MySQL

Copy Oracle Home Binary from One RAC Node to Another RAC Node

For some reason on RAC node 2 ( racnode2) , RAC oracle home binary needs to be copied from another node racnode1. 1)As RAC Oracle home owner, go to ORACLE_HOME/oui/bin  on racnode1: oracle@racnode1:/u01/app/oracle/product/11.2.0/dbhome_1/oui/bin$ ./ “CLUSTER_NEW_NODES={racnode2}” Performing pre-checks for node addition … Continue reading

Posted in GI and RAC, Install and Upgrade | Tagged , , , , | Leave a comment

How to Start MySQL Server

1) /etc/init.d/mysql script , which are called when system start up or shut down. It calls “mysqld_safe” when start up mysqld server. Usage: mysql  {start|stop|restart|reload|force-reload|status}  [ MySQL server options ] # find /etc/ -name *mysql* -exec ls {} -ltr \; … Continue reading

Posted in MySQL, Startup and Shutdown | Tagged , , , , , , | Leave a comment

How to Install MySQL on Linux Using RPM Packages

1) Download RPM packages zip file “” for MySQL 5.6.23 with files below: 2) unpack the zip file # unzip Archive: extracting: MySQL-shared-advanced-5.6.23-1.el7.x86_64.rpm extracting: MySQL-test-advanced-5.6.23-1.el7.x86_64.rpm extracting: MySQL-devel-advanced-5.6.23-1.el7.x86_64.rpm extracting: MySQL-shared-compat-advanced-5.6.23-1.el7.x86_64.rpm extracting: MySQL-embedded-advanced-5.6.23-1.el7.x86_64.rpm extracting: MySQL-server-advanced-5.6.23-1.el7.x86_64.rpm extracting: MySQL-client-advanced-5.6.23-1.el7.x86_64.rpm extracting: README.txt 3)To … Continue reading

Posted in Install and Upgrade, MySQL | Tagged , , | 1 Comment

How to Install MySQL on Unix/Linux Using Generic Binaries

1) Download “” which contains: There are two files – ASC and MD5 for “mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz” a: Verify MD5 checksum: $ cat mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz.md5 f2ace50e757f1a63736e8dcbf5cfeb19 mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz $ md5sum mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz f2ace50e757f1a63736e8dcbf5cfeb19 mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz b) Signature Checking Using GnuPG 1. To obtain a copy of … Continue reading

Posted in Install and Upgrade, MySQL | Tagged , , , , , , | 1 Comment

How to Install MySQL onto Linux Using the MySQL Yum Repository

1) Update libaio to date because MySQL is dependend on libaio [root@racnote1 ~]# yum install libaio Loaded plugins: langpacks Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast adobe-linux-x86_64 | 951 B 00:00:00 ol7_UEKR3 | 1.2 … Continue reading

Posted in Install and Upgrade, MySQL | Tagged , , , | Leave a comment