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
Tuesday, January 22, 2013
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.
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.