View RSS Feed

siosios

  1. MySQL replication server configuration

    Main steps



    Note: Consider server1 as master and server2 as slave and replicating database as exampledb.

    On Server 1(Master)

    1) Configuring the Master


    ? To make sure that the replication can work, we must make MySQL listen on all interfaces on the master (server1), therefore we comment out the linebind-address = 127.0.0.1in/etc/mysql/my.cnf:


    Eg: #bind-address ...
    Categories
    Tech Space