Get the most out of your Centmin Mod LEMP stack
Become a Member

Sysadmin Transfer database to a new server using a Master to Master or a Master to Slave?

Discussion in 'System Administration' started by pamamolf, Jun 26, 2020.

  1. pamamolf

    pamamolf Premium Member Premium Member

    3,815
    370
    83
    May 31, 2014
    Ratings:
    +712
    Local Time:
    10:41 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Hello

    Do you recommend me to use for the database transfer a Master to Master setup and when is done to stop Mariadb from the old server and start using the new one or a Master to Slave setup and then stop the Master from the old server and change the configuration to the new server and start it?

    Thank you
     
  2. eva2000

    eva2000 Administrator Staff Member

    44,702
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,796
    Local Time:
    5:41 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    what are you aiming to do ???
     
  3. pamamolf

    pamamolf Premium Member Premium Member

    3,815
    370
    83
    May 31, 2014
    Ratings:
    +712
    Local Time:
    10:41 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Transfer from one server to another and avoid the time needed to import the database in .sql file format that will take much time...
     
  4. eva2000

    eva2000 Administrator Staff Member

    44,702
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,796
    Local Time:
    5:41 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    maintenance mode and/or mariabackup/xtrabackup physical backup/restores or even mydumper for parallel backup/restore processes would be one way if you don't want to do mysql replication like above. Up to you as what is most comfortable for you.
     
  5. pamamolf

    pamamolf Premium Member Premium Member

    3,815
    370
    83
    May 31, 2014
    Ratings:
    +712
    Local Time:
    10:41 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    I prefer mysql replication but i am not sure if it is better to do a master / master or a master / slave :)