![]() ![]() There are several other features available in MEB like parallelism, incremental backup, differential backup,backup compression backup encryption etc., Let’s not get into those now. So this is pretty much similar to mysqldump with -single-transaction in terms to locking and disruption to database operations, ain’t it? But mysqldump produces a sql file whereas MEB produces and backup of the data directory. When it comes to other engine tables like Myisam, CSV it has to read lock the tables. This is applicable only to InnoDB tables. ![]() So a hot backup is done online and doesn’t disrupt the normal operations of the database and it even captures the database operations happening during the backup process and applies it during the restoration process. It has been said that MEB(let us just call the MySQL Enterprise backup, MEB) provides hot online backups with zero downtime. ![]() Now let us talk about the MySQL Enterprise backup tool that is only available with the Enterprise edition. ![]() Myisam tables locked even with single transaction option. It’s a well know fact that we could take backups with almost zero downtime with the “mysqldump” tool provided with the community edition of MySQL with a magical option -single-transaction on one condition that all the tables are InnoDB. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |