What is replication in MySQL

        -- On the Master server:
        -- Step 1: Edit the MySQL configuration file (my.cnf)
        [mysqld]
        server-id=1
        log_bin=mysql-bin
        
        -- Step 2: Create a replication user
        CREATE USER 'replicator'@'%' IDENTIFIED BY 'password';
        GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'%';

        -- Step 3: Obtain the binary log coordinates for the master
        FLUSH TABLES WITH READ LOCK;
        SHOW MASTER STATUS;
        -- Note down the File and Position

        -- Step 4: Unlock the tables
        UNLOCK TABLES;

        -- On the Slave server:
        -- Step 1: Edit the MySQL configuration file (my.cnf)
        [mysqld]
        server-id=2

        -- Step 2: Start replication
        CHANGE MASTER TO 
            MASTER_HOST='master_ip_address', 
            MASTER_USER='replicator', 
            MASTER_PASSWORD='password', 
            MASTER_LOG_FILE='mysql-bin.000001', 
            MASTER_LOG_POS=12345; -- Use the File and Position noted earlier

        -- Step 3: Start the slave
        START SLAVE;

        -- Step 4: Check the slave status
        SHOW SLAVE STATUS\G