maxbube/mydumper: Official #mydumper project
▻https://github.com/maxbube/mydumper
What is mydumper? Why?
– Parallelism (hence, speed) and performance (avoids expensive character set conversion routines, efficient code overall)
– Easier to manage output (separate files for tables, dump metadata, etc, easy to view/parse data)
– Consistency - maintains snapshot across all threads, provides accurate master and slave log positions, etc
– Manageability - supports PCRE for specifying database and tables inclusions and exclusions
When it comes to backing up and restoring MySQL database, most people usually use the very popular mysqldump. Whilst, mysqldump can be very easy to use for a smaller database, it doesn’t work well with larger databases. It’s very slow for huge databases and very error prone when used for very big MySQL databases.
▻https://dotlayer.com/extremely-fast-mysql-backup-restore-using-mydumpermyloader
Semble être utilisé par wikmedia cf :
Its speed and parallelism makes it perfect to save time and load data a lot faster.
It is easier to recover single tables or rows.
It compress nicely
▻https://wikitech.wikimedia.org/wiki/MariaDB#Dumping_tables_with_mydumper