Tuesday, January 22, 2013

THINGS TO BE CHECKED BEFORE INSTALLING MYSQL ON LINUX

1)check the operating system whether it is 32bit or 64bit.

USING: $ uname -a
            
             if i386,i686 - 32bit
             if x86_64 - 64bit 

2)check the disk space.

USING:$ df -h

3)check the RAM.

USING : $ free -m

4)check any other application is running or not.

USING : $ top

5)check which operating system is that.

USING : $ cat /etc/issue

6)check how many cores in CPU.

USING : $ cat /proc/cpuinfo |grep processor|wc -l

5 STEPS TO DO BEFORE MYSQL INSTALLATION FOR SLAVE SERVER

1)Take a backup of Master server databases.

2)Enable the binlog in master server.

3)Give the different base and data directory location in slave(not same as Master). 

4)Before install mysql in slave edit the slave my.cnf file   to change the server id,port number and socket number.

Note: Default port number for mysql is 3306.
change it as by your wish in slave.

Eg:  port = 3307
       socket = /tmp/mysql_3307.sock

       Server-id=2

5)Next install MySQL in slave.