Learn about Centmin Mod LEMP Stack today
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

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +837
    Local Time:
    5:52 AM
    Nginx-1.26.x
    MariaDB 10.6.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

    55,245
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,833
    Local Time:
    12:52 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    what are you aiming to do ???
     
  3. pamamolf

    pamamolf Premium Member Premium Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +837
    Local Time:
    5:52 AM
    Nginx-1.26.x
    MariaDB 10.6.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

    55,245
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,833
    Local Time:
    12:52 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +837
    Local Time:
    5:52 AM
    Nginx-1.26.x
    MariaDB 10.6.x
    I prefer mysql replication but i am not sure if it is better to do a master / master or a master / slave :)