Setting up MySQL replication

linux
1. Settings to be done in Master DB server: Edit my.cnf file (/etc/my.cnf) and enter the following: server-id = 1 log-bin 2. Login to mysql DB in master server and run the following command: mysql> show master status; (more…)
Read More

Defragmenting MySQL DB

linux
Whenever there is change in the structure of a MySQL database, or we remove lot of data from a table, the files can  become fragmented which may result in the loss of performance, while running the queries. (more…)
Read More