How to Setup MySQL (Master-Slave) Replication in RHEL, CentOS, Fedora

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.95/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Ravi Saive

I am Ravi Saive, creator of TecMint. A Computer Geek and Linux Guru who loves to share tricks and tips on Internet. Most Of My Servers runs on Open Source Platform called Linux. Follow Me: Twitter, Facebook and Google+

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

You may also like...

146 Responses

  1. James says:

    mysql -u root -p < /root/dbdump.db
    Enter password:
    ERROR 1794 (HY000) at line 22: Slave is not configured or failed to initialize properly. You must at least set –server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log.

    I got this when I tried to do the restore on the slave.

    • Ravi Saive says:

      @James,

      Have you properly configured Slave server? added correct server-id in slave my.cnf file? please check and confirm..

Got something to say? Join the discussion.

Your email address will not be published. Required fields are marked *