Steps for database replication in mysql

1. Configure the master database server to allow replication by adding the following lines to the MySQL configuration file (my.cnf):

Copy code
server-id=1
log-bin=mysql-bin
binlog-do-db=database_name

2. Restart the MySQL service to apply the changes.
3. Create a user account on the master database server with replication privileges:

Copy code
GRANT REPLICATION SLAVE ON *.* TO 'replication_user'@'%' IDENTIFIED BY 'password';

4. Take a snapshot of the master database and copy it to the slave database server.
5. Import the snapshot into the slave database server.
6. On the slave database server, add the following lines to the MySQL configuration file (my.cnf):

Copy code
server-id=2
relay-log=mysql-relay-bin
log-slave-updates

7. Restart the MySQL service on the slave database server to apply the changes.
8. Connect to the slave database server and set it as a slave of the master database server:

Copy code
CHANGE MASTER TO MASTER_HOST='master_server_ip', MASTER_USER='replication_user', MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=4;

9. Start the slave database server replication process:

Copy code
START SLAVE;

10. Monitor the replication process using the following command:

Copy code
SHOW SLAVE STATUS\G