phpbu icon indicating copy to clipboard operation
phpbu copied to clipboard

Feature Request: Add support for mydumper for exporting Databases.

Open planetahuevo opened this issue 4 years ago • 4 comments

I just discover https://github.com/maxbube/mydumper/ which is an alternative for mysqldump as they explain on this link https://wikitech.wikimedia.org/wiki/MariaDB#Dumping_tables_with_mydumper

It is made for handling big databases and it could be a great addition to the database options.

What do you think?

planetahuevo avatar Nov 08 '21 17:11 planetahuevo

MyDumper doesn't look that wide spread in terms of usage, but it looks simple enough to add as a data source :)

sebastianfeldmann avatar Nov 10 '21 15:11 sebastianfeldmann

Agree, it seems is only required/useful once you reach huge databases (TBs?) , which I suppose is not that common either.

Thank you for considering it! 👍

planetahuevo avatar Nov 10 '21 16:11 planetahuevo

If you are looking to backup a huge database have a look at Perconas Xtrabackup

It is a great tool du backup huge MySQL databases and iIt is used by a lot of big companies.

sebastianfeldmann avatar Nov 14 '21 18:11 sebastianfeldmann

Yes I know about Xtrabackup, but that is different thing as those are binary backups, with their pros and cons. For big databases, it is good to have both options, Xtrabackup as binary and a logical solution like MyDumper which allow easy restoration from one table, for example. For that, mysqldump fails to provide the logical option.

planetahuevo avatar Nov 14 '21 19:11 planetahuevo