Primary Server

On your Primary server, perform the following actions:

  1. Install both the “mysql” and “mysql-server” rpm packages if they do not exist on your system.

Apply any required dependencies as well

# yum install mysql mysql-server

  1. Verify that your Shared iSCSI LUN is still mounted at /var/lib/mysql via the “df” command
  1. If this is a fresh MySQL install, initialize a sample MySQL database:

# /usr/bin/mysql_install_db —datadir=”/var/lib/mysql” —user=mysql

  1. Ensure that all files in your MySQL data directory (/var/lib/mysql) have correct permissions and ownership

# chown –R mysql:mysql /var/lib/mysql

# chmod 755 /var/lib/mysql

  1. Finally, manually start the MySQL daemon from the command line. Note: Do Not start it via the “service” command, or the /etc/init.d/ scripts

# mysqld_safe —user=root —socket=/var/lib/mysql/mysql.sock —port=3306 — datadir=/var/lib/mysql —log &

  1. Verify MySQL is running by connecting with the mysql client:

[root@LinuxPrimary mysql]# mysql

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.0.77-log Source distribution

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> exit

Bye

[root@LinuxPrimary mysql]#

  1. Update the root password for your mysql configuration. In this example we set the MySQL root password to “SteelEye”

# echo “update user set Password=PASSWORD where User=‘root’; flush

privileges” | mysql mysql

  1. Verify your new password:

# mysql mysql –u root –p

(Enter “SteelEye” as the password)

#exit

  1. Create a MySQL configuration file. We will place this in the same shared directory (/var/lib/mysql/my.cnf)

# vi /var/lib/mysql/my.cnf

Example
# cat /var/lib/mysql/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
pid-file=/var/lib/mysql/mysqld.pid
user=root
port=3306
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
user=root
password=SteelEye

  1. Delete the original MySQL configuration file, located in /etc

# rm /etc/my.cnf

Secondary Server

On your Secondary Server:

  1. Install both the “mysql” and “mysql-server” rpm packages if they do not exist on your system.

Apply any required dependencies as well

# yum install mysql mysql-server

  1. Ensure that all files in your MySQL data directory (/var/lib/mysql) have correct permissions and ownership

# chown –R mysql:mysql /var/lib/mysql

# chmod 755 /var/lib/mysql

  1. There is no need to perform any of the additional steps taken on the Primary Server

Feedback

Thanks for your feedback.

Post your comment on this topic.

Post Comment