How to Setup MariaDB (Master-Slave) Replication in CentOS/RHEL 7 and Debian 8

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. Use our Linode referral link if you plan to buy VPS (it starts at only $10/month).
  4. Support us via PayPal donate - Make a Donation
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux course in 5 Days

We are thankful for your never ending support.

Gabriel Cánepa

Gabriel Cánepa is a GNU/Linux sysadmin and web developer from Villa Mercedes, San Luis, Argentina. He works for a worldwide leading consumer product company and takes great pleasure in using FOSS tools to increase productivity in all areas of his daily work.

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

Receive Your Free Complimentary eBook NOW! -

Download Free Linux eBooks

Advanced Bash-Scripting Guide
Linux Bible
A Newbie's Getting Started Guide to Linux
Introduction to Linux - A Hands on Guide

You may also like...

5 Responses

  1. Tim says:

    Beautiful instructions. Worked like a charm on Ubuntu 14.04. Very simple and to the point. This is a rare commodity in Linux ‘How-To’s’
    Thank you VERY much!

  2. Yusuf Eka says:

    i have error when i start slave. the error is no query specified, what should i do?

    • Ravi Saive says:

      @Yusuf,

      Could you share the status output of the salve MySQL server?

      show slave status\G;
      

      Also, if possible try to re-sync the data from master to slave again, will solve the problem

  3. krx says:

    Hello,
    i have problem with replication. When i add bind-address MY_IP _ADDRESS then my web apps on mysql not work… but when bind-address is 127.0.0.1, then apps work but not work replication….

  4. Jagan says:

    This post is very helpful!
    Can you please make a post on how to take full and incremental backup on Maria DB?

Got something to say? Join the discussion.

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

Join Over 95000+ Linux Users
  1. 77,543
  2. 4,213
  3. 35,218

Enter your email to get latest Linux Howto's