Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 223 10 Older Entries

Displaying posts with tag: Backup (reset)

OurSQL Episode 160: More Free Hot Backup
+0 Vote Up -0Vote Down

This week we finish our 2-part series on xtrabackup. Ear Candy is changing the sorting behavior of GROUP BY and At the Movies is a talk on performance schema.

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 …


  [Read more...]
OurSQL Episode 159: Free Hot Backup
+0 Vote Up -0Vote Down

This week, we talk about Percona's Xtrabackup. Ear Candy talks about .frm files and how many fields an InnoDB table can have, and At the Movies is a talk about indexes.

Xtrabackup
Episode 38 where we previously talked about Xtrabackup

Installing Percona's Xtrabackup

Operating system …


  [Read more...]
Backing up full server instance using MySQL Enterprise Backup
Employee +0 Vote Up -0Vote Down

Introduction:

MySQL Enterprise Backup(MEB) takes fast, consistent backups of MySQL server data, and helps in restoring the server to source server's data at the time of backup. But most of the times it is as much important to have same source server's state(server configuration like server global variables, plugins), as data. As backups become more frequent, server variables modified, plugins added or removed, it is very difficult to keep track …


  [Read more...]
TokuMX Hot Backup – Part 3
+0 Vote Up -0Vote Down

Last week I described TokuDB’s new Hot Backup feature.  This week we are going to briefly discuss the same feature, but as it was added to TokuMX, our version of MongoDB.

Since the Hot Backup library is essentially a shim between MySQL and the Linux kernel, intercepting file system calls for the life of the process, it should be easy to add this to any other system, including TokuMX.  Indeed with our addition of transactions and logging to TokuMX we can gain a consistent backup of any data set at any time.

  [Read more...]
Skip Unused Pages with MySQL Enterprise Backup 3.9.0
Employee +2 Vote Up -0Vote Down

Disclaimer
The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Introduction
There are database usage patterns, where tables grow big at times and many rows are deleted from them later. InnoDB does never shrink a table space. In these cases we can end up with big data files, which contain a lot of unused pages. It is a waste of disk- and I/O- resources to back them up.

Users have manifold requested that MySQL Enterprise Backup does not back up unused InnoDB data pages. Some want smaller backups, some want less I/O, some want shrinked table spaces.









  [Read more...]
MySQL Enterprise Backup: PITR Partial Online Recovery
Employee +3 Vote Up -0Vote Down

Here’s a look at using MySQL Enterprise Backup in a specific example:

Consider a Backup Policy – Full Backup of the environment. – Complemental Incremental backups & online BinLogs. And the Restore: – Logical Restore. – Online, Zero impact. – Partial, single database, group of tables. The Backup A working environment, with 4 databases, of which 2 will require restoration. Full backup with MySQL Enterprise Backup:

mysqlbackup --user=root --socket=/tmp/mysql.sock \
  --backup-dir=/home/mysql/voju5/backup/ \
  --with-timestamp backup

Test preparation Create 4 different databases, …

  [Read more...]
MySQL Enterprise Backup: PITR Partial Online Recovery
Employee +0 Vote Up -0Vote Down

Here’s a look at using MySQL Enterprise Backup in a specific example:

Consider a Backup Policy – Full Backup of the environment. – Complemental Incremental backups & online BinLogs. And the Restore: – Logical Restore. – Online, Zero impact. – Partial, single database, group of tables. The Backup A working environment, with 4 databases, of which 2 will require restoration. Full backup with MySQL Enterprise Backup:

mysqlbackup --user=root --socket=/tmp/mysql.sock \
  --backup-dir=/home/mysql/voju5/backup/ \
  --with-timestamp backup

Test preparation Create 4 different databases, …

  [Read more...]
Improved Backup Progress in MySQL Enterprise Backup(MEB) 3.8.2
Employee +0 Vote Up -0Vote Down

Nowadays huge amount of data is stored in databases and it is very inevitable for business needs. With parallel backup, MEB has best in class performance and continues to improve. With terabytes of data, it can take hours to backup the data. As a DBA you'd like to know how much of the backup is done, how much data in MB still remains and also what's currently happening in backup.

So MEB 3.8.2 has an enhanced progress indicator which will help the DBA in many ways like

  • You can analyze current and expected space requirements so that you can release some space by removing files on a file system or stop the backup …

  [Read more...]
MySQL Enterprise Backup 3.8.2 has been released!
Employee +3 Vote Up -0Vote Down

MySQL Enterprise Backup v3.8.2, a maintenance release of online MySQL backup tool, is now available for download from My Oracle Support  (MOS) website as our latest GA release.  It will also be available via the Oracle Software Delivery Cloud in approximately 1-2 weeks. A brief summary of the changes in MySQL Enterprise Backup version 3.8.2 is given below.


  A. Functionality Added or Changed: 

  • MySQL Enterprise Backup has a new --on-disk-full command line option. mysqlbackup could hang when the disk became full, rather than detecting the low space condition. mysqlbackup now monitors disk …

  [Read more...]
mylvmbackup 0.14 has been released
+2 Vote Up -0Vote Down

It's my great pleasure to announce the release of mylvmbackup version 0.14.

This release includes a large number of improvements, code cleanups, and new functionality.

I would like to thank Ask Bjørn Hansen, Ben Bonnel, Norbert Tretkowski, Neil Wilson, Klaus Ethgen and Alexandre Anriot for their feedback and contributions to this release.

The release is available as a source tarball and …

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 223 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.