/ Register

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

MariaDB Backup Large InnoDB Databases

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by BamaStangGuy, May 28, 2015.

Previous Thread Next Thread
Loading...
Page 2 of 2
  1. Feb 24, 2016 #21
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:39 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    @Revenge yeah that's what I mean about it being a bit more complicated for average folks compared to mysqldump and mydumper :)
     
  2. Feb 24, 2016 #22
    Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    6:39 PM
    1.9.x
    10.1.x
    @eva2000 thats why you created centminmod, to make a task that is complicated into something very easy even for the average user. And its a damn good work you have accomplished.
    Maybe in the future you can implement xtrabackup with automated commands from centminmod menu. ;)
     
  3. Feb 24, 2016 #23
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:39 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Thanks for kind words - I try to make things less complicated or less time consuming with Centmin Mod - time is more precious than money, so more time saved the better :)

    Yeah for some of my paying clients they're using a mixture of mydumper and xtrabackup and mysqldump via custom scripts. Centmin Mod has dbbackup.sh for premium members MariaDB - dbbackup.sh - quick mysql database backups for Centmin Mod stack | Centmin Mod Community It uses mysqldump right now but probably extend it further in future for mydumper and percona xtrabackup :D
     
  4. Feb 26, 2016 #24
    Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    6:39 PM
    1.9.x
    10.1.x
    I haven't used mydumper for a very long time, so i compiled 0.9.1 version and compared the times against mysqldump.
    This is for a 3Gb database in a vps from vpsdime, so its 4 vcpu's, 6Gb of Ram and SSD Drive.

    Mysqldump Backup: 46s
    Mysqldump Restore: 10m40s

    Mydumper: 16s
    Myloader: 6m10s

    I was specially impressed with the 16s of Mydumper. Its almost instant for a 3Gb Database. I might start using Mydumper when i backup my Database prior to the web software update.
     
  5. Feb 26, 2016 #25
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:39 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yeah i use mydumper and mysqldump together. More frequent backups can use mydumper :)
     
  6. Feb 26, 2016 #26
    Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    6:39 PM
    1.9.x
    10.1.x
    One strange thing. The restore of Mydumper have decreased the Database to 2.8GB. Its normal because of the fragmentation.
    But the Mysqldump restore have raised the Database to 3.1Gb. Very strange lol
     
  7. Feb 26, 2016 #27
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:39 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    try mysqldump single table of database and compare it's sql file to the individual mydumper sql file for that table and see what's different :)
     
Previous Thread Next Thread
Loading...
Page 2 of 2

.