DEV Community

Sihar Simbolon
Sihar Simbolon

Posted on • Updated on

Perbandingan backup dan restore database MariaDB menggunakan mysqldump,mydumper, mysql dan myloader

#mysql #mydumper #myloader

Backup menggunakan mydumper 

time mydumper -h ip_address -u nama_usernya -p passwordnya --database nama_databasenya --outputdir nama_foldernya --logfile alamat_logfilenya.log
0.46s user 0.17s system 17% cpu 3.542 total
Enter fullscreen mode Exit fullscreen mode

Backup menggunakan mysqldump 

time mysqldump -h ip_address -u nama_usernya --databases nama_databasenya -p > nama_backup_file.sql
Enter password: 
0.38s user 0.13s system 7% cpu 7.241 total
Enter fullscreen mode Exit fullscreen mode

Restore menggunakan myloader 

time myloader -u nama_usernya -p passwordnya --database=nama_databasenya --directory=nama_folder_hasil_export_dari_mydumper    
0.04s user 0.06s system 7% cpu 1.467 total
Enter fullscreen mode Exit fullscreen mode

Restore menggunakan mysql 

time mysql -u nama_usernya -p < nama_backup_file.sql
0.29s user 0.04s system 5% cpu 6.398 total
Enter fullscreen mode Exit fullscreen mode

Dari percobaan di atas, didapat hasil backup menggunakan mydumper lebih cepat begitu juga restore menggunakan mysql

Top comments (0)

Read next

digitalsamba profile image

Differences Between Broadcast and Multicast

Digital Samba -

meertanveer profile image

Understanding PropTypes in React: Ensuring Data Integrity and Component Consistency

Tanveer Hussain Mir -

blazy profile image

Unveiling DeFi Exchange Platform Development Services: Empowering the Decentralized Finance Ecosystem

blazyadam -

manavcodaty profile image

Version Control Throwdown: Git vs. Subversion

Manav Codaty -