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

Best Affordable Linux and WordPress Services For Your Business
Outsource Your Linux and WordPress Project and Get it Promptly Completed Remotely and Delivered Online.

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.45/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.

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.

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

You may also like...

29 Responses

  1. Robson Rissato says:

    In mariadb version 10.4 this does not work log-bin
    server_id = 1
    replicate-do-db = employees
    bind-address =

    of mysql_upgrade errors: unknown option ‘–log-bin’

  2. Tapan Thapa says:


    In step 2, below command is not required.
    MariaDB [(none)]> GRANT ALL PRIVILEGES ON employees.* TO 'slave'@'localhost' WITH GRANT OPTION;

  3. Mela says:


    When i tried to install MariaDb showed error message that /boot is full . Why?

    Are there specific requirement in partitioning side?

  4. Ed Greenberg says:

    You write that on master: CREATE USER 'slave'@'localhost' IDENTIFIED BY 'SlavePassword';

    Shouldn’t this be: slave CREATE USER 'slave'@'' IDENTIFIED BY 'SlavePassword';?

    Slave will not log in from localhost, but rather, from the slave server.

  5. madhav says:

    ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

    I got this error after i hit # mysql < employees.sql this command to import sample database.

Got something to say? Join the discussion.

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.