1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Backup solution for huge 150GB database

Discussion in 'Databases' started by asteraki1976, Nov 28, 2017.

  1. #1
    Hello

    I am using to backup a (MariaDB) database of size 150GB:
    SEMrush
    mysqldump --opt --single-transaction
    Code (markup):
    but server start to not respond at the time of backup for a few minutes so i am looking for any other solution to replace mysqldump.

    Any other solutions for huge databases?

    Thank you
     
    asteraki1976, Nov 28, 2017 IP
    SEMrush
  2. jestep

    jestep Prominent Member Premium Member

    Messages:
    3,640
    Likes Received:
    212
    Best Answers:
    18
    Trophy Points:
    330
    #2
    jestep, Nov 29, 2017 IP
  3. scylla

    scylla Notable Member

    Messages:
    1,021
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    225
    #3
    scylla, Apr 15, 2018 IP
  4. Komputerking

    Komputerking Greenhorn

    Messages:
    34
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    8
    #4
    With a database that size, this is probably your best bet. Xtrabackup is much much faster than performing a standard mysqldump. The other as to why your site is locking up, is that your database tables are being locked during the backup, which is preventing the site from responding.

    Your best option overall would be to setup a cluster, and have one of the servers in the cluster be a read only option, and then performing the dump via xtrabackup on that server. That would prevent the server from going down during the dump, and would allow the server to perform the dump, and then re-sync after the dump was complete.
     
    Komputerking, Jul 31, 2018 IP