The MySQL Enterprise Backup (MEB) Team is pleased to
announce the release of MEB 3.7.1, a maintenance release version
that includes bug fixes and enhancements to some of the existing
features.
The most important feature introduced in this release is
Automatic Incremental Backup. The new argument syntax for
the --incremental-base option is introduced which makes it
simpler to perform automatic incremental backups. When the
options --incremental & --incremental-base=history:last_backup
are combined, the mysqlbackup command uses the metadata in
the mysql.backup_history table to determine the LSN to use as the
lower limit of the incremental backup. You no longer need to keep
track of the actual LSN (as in the option --start-lsn=LSN) or
even the location of the previous backup (as in the option
--incremental-base=dir:directory_path)
…
While doing some routine fiddling regarding some topic I've now
forgotten, I discovered that ndb_restore was doing
something quite surprising. It's been common wisdom for some time
that one can use ndb_restore -m to restore metadata
into a new cluster and automatically have your data
re-partitioned across the data nodes in the destination cluster.
In fact, this was the recommended procedure for adding nodes to a
cluster before online add node came along. Since MySQL Cluster
7.0, though, ndb_restore hasn't behaved that way,
though that change in behavior doesn't seem to be documented and
most don't know that the change ever took place.
I'll go through some of the methods you can use to find
information about the partitioning strategy for an NDB table,
talk a bit about why ndb_restore stopped working the
way most everyone expected (and still expect) it to, and discuss
some possible …
The latest release of MySQL Enterprise Backup (MEB 3.7.0) introduces a new method for performing incremental hot backups - the redo-log-only incremental backup. This new method of incremental backups allows for highly compact and fast incremental backups and MEB users now have the choice between data-file based incremental backups and the redo-log-only incremental backups.
In data-file based incremental backups (performed using the '--incremental' option) MEB scans all InnoDB datafiles but copies to the backup only modified pages. The main benefit of this is …
[Read more]The latest release of MySQL Enterprise Backup (MEB 3.7.0) introduces a new method for performing incremental hot backups - the redo-log-only incremental backup. This new method of incremental backups allows for highly compact and fast incremental backups and MEB users now have the choice between data-file based incremental backups and the redo-log-only incremental backups.
In data-file based incremental backups (performed using the '--incremental' option) MEB scans all InnoDB datafiles but copies to the backup only modified pages. The main benefit of this is …
[Read more]In its latest release MySQL Enterprise Backup (MEB 3.7.0) rolled out a new feature called 'incremental-base' which can save a lot of time and effort of the users when taking incremental backups. Let us understand this new feature and how it can be helpful:
[Read more]In its latest release MySQL Enterprise Backup (MEB 3.7.0) rolled out a new feature called 'incremental-base' which can save a lot of time and effort of the users when taking incremental backups. Let us understand this new feature and how it can be helpful:
[Read more]
The MySQL Enterprise Backup (MEB) Team is pleased
to announce the release of MEB 3.7.0, with several exciting and
advanced features to benefit a wide audience. Included in this
release are,
- Redo Log only Incremental Backup
- Incremental Backup without specifying LSN
- Validation of Backup Image using checksums
- …
The MySQL Enterprise Backup (MEB) Team is pleased
to announce the release of MEB 3.7.0, with several exciting and
advanced features to benefit a wide audience. Included in this
release are,
- Redo Log only Incremental Backup
- Incremental Backup without specifying LSN
- Validation of Backup Image using checksums
- …
In the latest episode of our “Meet The MySQL Experts” podcast, Sveta Smirnova from the MySQL technical support organization gives us an overview of the common MySQL backup practices and tools, and talks about the benefits of using MySQL Enterprise Backup.
In the latest episode of our “Meet The MySQL Experts” podcast, Sveta Smirnova from the MySQL technical support organization gives us an overview of the common MySQL backup practices and tools, and talks about the benefits of using MySQL Enterprise Backup.