Planet MySQL

Announcing MySQL Enterprise Backup 3.7.1

+2

-0

posted by Oracle MySQL Group on Wed 28 Mar 2012 18:28 UTC
Tags:

(edit) mysql, enterprise, Backup, database

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

[Read more...]

Surprises in store with ndb_restore

+1

-1

posted by SkySQL on Thu 16 Feb 2012 18:49 UTC
Tags:

(edit) Backup, cluster, ndb, restore, ndb_restore, gotcha

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

+3

-0

posted by MySQL Community on Thu 12 Jan 2012 07:24 UTC
Tags:

(edit) mysql, enterprise, Backup, incremental, MEB

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

+0

-0

posted by Oracle MySQL Group on Thu 12 Jan 2012 07:24 UTC
Tags:

(edit) mysql, enterprise, Backup, incremental, MEB

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

+5

-0

posted by MySQL Community on Wed 11 Jan 2012 02:09 UTC
Tags:

(edit) mysql, enterprise, Backup, community, incremental, MEB

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:

+0

-0

posted by MySQL Community on Wed 11 Jan 2012 02:09 UTC
Tags:

(edit) mysql, enterprise, Backup, incremental, MEB

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:

+5

-1

posted by MySQL Community on Tue 10 Jan 2012 22:39 UTC
Tags:

(edit) mysql, enterprise, Backup, database

The MySQL Enterprise Backup (http://mysql.com/products/enterprise/backup.html) (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,

+0

-0

posted by Oracle MySQL Group on Tue 10 Jan 2012 22:39 UTC
Tags:

(edit) mysql, enterprise, Backup, database

The MySQL Enterprise Backup (http://mysql.com/products/enterprise/backup.html) (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,

[Read more...]

Focus on Backup

+0

-0

posted by Oracle MySQL Group on Mon 28 Nov 2011 08:54 UTC
Tags:

(edit) mysql, 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 (http://www.mysql.com/products/enterprise/backup.html).

Enjoy the podcast!

Focus on Backup

+2

-0

posted by MySQL Community on Mon 28 Nov 2011 02:54 UTC
Tags:

(edit) mysql, 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 (http://www.mysql.com/products/enterprise/backup.html).

Enjoy the podcast!

My slides of MySQL Meetup Viadeo / LeMUG Paris

+1

-0

posted by Cedric PEINTRE on Tue 22 Nov 2011 20:00 UTC
Tags:

(edit) Backup, mysqldump, admin, lemug, zrm, Live !, Viadeo

I was glad to present how to schedule and monitor mysqldump with ZRM community last week in Paris as part of the MySQL Meetup Viadeo / LeMUG

You can find my slides below, enjoy ! :

MYSQLDUMP & ZRM COMMUNITY (EN) View more presentations from Cédric PEINTRE Thanks to Olivier and all the viadeo team in Paris for this event.
And, of course, thanks to all attendees. We need more events like that in France ! Related Posts :

Slides from MySQL

[Read more...]

Green HDs and RAID Arrays

+1

-1

posted by Open Query on Mon 26 Sep 2011 02:37 UTC
Tags:

(edit) mysql, Backup, green, raid, mariadb, hd, hdd, Software and tools, array, harddisk, SAS, SATA

Some so-called “Green” harddisks don’t like being in a RAID array. These are primarily SATA drives, and they gain their green credentials by being able reduce their RPM when not in use, as well as other aggressive power management trickery. That’s all cool and in a way desirable – we want our hardware to use less power whenever possible! – but the time it takes some drives to “wake up” again is longer than a RAID setup is willing to tolerate. First of all, you may wonder why I bother with SATA disks at all for RAID. I’ve written about this before, but they simply deliver plenty for much less money. Higher RPM doesn’t necessarily help you for a db-related (random access) workload, and for tasks like backups which do have a lot of speed may not be a primary concern. SATA disks have a shorter command queue than SAS, so that means they might need [Read more...]

Viewing RMAN jobs status and output

+0

-1

posted by Ben Mildren on Fri 26 Aug 2011 05:10 UTC
Tags:

(edit) Oracle, Backup, Group Blog Posts, metadata, views, query, restore, Technical Blog, rman, gv$rman_output, output, v$, V$BACKUP_SET, V$BACKUP_SET_DETAILS, V$RMAN_BACKUP_JOB_DETAILS, v$rman_output

Yesterday I was discussing with a fellow DBA about ways to check the status of existing and/or past RMAN jobs. Good backup scripts usually write their output to some sort of log file so, checking the output is usually a straight-forward task. However, backup jobs can be scheduled in many different ways (crontab, Grid Control, Scheduled Tasks, etc) and finding the log file may be tricky if you don’t know the environment well.
Furthermore, log files may also have already been overwritten by the next backup or simply just deleted. An alternative way of accessing that information, thus, may come handy.

Fortunately, RMAN keeps the backup metadata around for some time and it can be accessed through the database’s V$ views. Obviously, if you need this information because your database just crashed and needs to be restored, the method described here is useless.

+5

-0

posted by Rob Young of team blog Oracle MySQL Group on Tue 19 Jul 2011 17:03 UTC
Tags:

(edit) mysql, enterprise, Backup, innodb, recovery, mysql server, edition

All DBAs understand the importance and priority of quick, reliable database backup and recovery operations. In fact, dating back to my early days with MySQL, the most commonly requested product features from the MySQL user base have been around online, non-blocking backup solutions for running MySQL servers. In response, Oracle now provides MySQL Enterprise Backup (http://mysql.com/products/enterprise/backup.html) ("MEB") which performs high performant, online "hot" backups for MySQL databases. MEB provides all of the backup/recovery features and functionality DBAs expect, all from a scriptable command line interface. You can learn all about MEB in the related MySQL docs.

My congratulations and appreciation go out to Lars Thalmann and the MySQL Enterprise

[Read more...]

automysqlbackup 2.5.5

+1

-0

posted by Mark Grennan on Tue 12 Jul 2011 21:48 UTC
Tags:

(edit) code, Tools, Backup, automsyqlbackup

I spent my day doing updates to the automysqlbackup script. Here is some of what I’ve added over the last year.

The bug number fixes are from SourceForge. https://sourceforge.net/tracker/?atid=628964&group_id=101066&func=browse

# 2.5.5 MTG – (2011-07-21)
#    – Bug – Typo Ureadable Unreadable config file line 424 – ID: 3316825
#    – Bug – Change “#!/bin/bash” to “#!/usr/bin/env bash” – ID: 3292873
#    – Bug – problem with excludes – ID: 3169562
#    – Bug – Total disk space on symbolic links – ID: 3064547
#    – Added DEBUG option to only

+0

-0

posted by Addision on Thu 02 Jun 2011 09:08 UTC
Tags:

(edit) Backup, Mysql Repair, Repair MYSQL Database, mysql database recovery, corrupt, mysql recovery

MySQL organizes all the data as tables, irrespective of storage engine used. If you are using MySQL with InnoDB tables, these tables might get corrupt due to hardware faults, unexpected power failure, MySQL code errors, kernel bugs and other similar reasons. In such cases, InnoDB will typically give some errors indicating table corruption. As a data restoration source, you will need to use your latest database backup. But in case if backup fails to restore required information or doesn’t exist, you should scan your damaged database using third-party MySQL Repair or MySQL Recovery tools.

You might encounter the similar error message while accessing an InnoDB table:

“#1033 - Incorrect information in file: '"table name" .frm”

MySQL crashes after you receive this error

[Read more...]

MySQL Backup: Table By Table Backup With Auto Rotation, For Easy Restoration Of Partial/Full Database

+0

-3

posted by of team blog HowToForge on Mon 30 May 2011 16:50 UTC
Tags:

(edit) mysql, Backup

MySQL Backup: Table By Table Backup With Auto Rotation, For Easy Restoration Of Partial/Full Database

Here is a MySQL backup script which can take table by table backups (individual backup files of each table of each database) in a compressed format. It also provides an automatic rotation of old backup files. The backup script handles innodb and myisam tables separately.

On LVM: How to setup Volume Groups and Logical Volumes.

+0

-0

posted by Ovais Tariq on Sat 28 May 2011 11:46 UTC
Tags:

(edit) mysql, debian, Backup, ubuntu, lvm, DBA, partition, fdisk, lvs, filesystem, lvm2, disk, snapshot, ext4, mount, boot, create volume, df, fstab, logical volume, logical volume management, lvcreate, mkdir, partition table, physical volume, pvcreate, system startup, terminologies, vgcreate, vgs, volume group

LVM (Logical Volume Management) is a very important tool to have in the toolkit of a MySQL DBA. It allows you to create and extend logical volumes on the fly. This allows me to, say, add another disk and extend a partition effortlessly. The other very important feature is the ability to take snapshots, that you can then use for backups. All in all its a must have tool. Hence, this guide will allow you to understand various terminologies associated with LVM, together with setting up LVM volumes and in a later part will also show you how to extend...

Some More Replication Stuff

+0

-0

posted by Gerardo Narvaja on Thu 05 May 2011 23:37 UTC
Tags:

(edit) mysql, Replication, Tools, tips, Backup, tuning, monitoring, DBA, schema updates

Listening to the OurSQL podcast: Repli-cans and Repli-can’ts got me thinking, what are the issues with MySQL replication that Sarah and Sheeri didn’t have the time to include in their episode. Here’s my list:

Replication Capacity Index

This is a concept introduced by Percona in last year’s post: Estimating Replication Capacity which I revisited briefly during my presentation at this year’s MySQL Users Conference. Why is this important? Very simple: If
[Read more...]

OurSQL Episode 41: Zmanda [backup series #6]

+2

-0

posted by Technocation on Fri 08 Apr 2011 04:13 UTC
Tags:

(edit) Backup, Podcasts

Previously in the backup series:

Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Export Features (advanced mysqldump)
Backup Series #5: Xtrabackup

This week we talk with Chander Kant, CEO of Zmanda, about how Zmanda Recovery Manager makes backup and recovery of MySQL backups very easy, whether you are using storage level snapshots, hot backup tools or even logical backups. Full and incremental backups (and restores!) are made

+2

-0

posted by Stewart Smith on Fri 01 Apr 2011 07:22 UTC
Tags:

(edit) Backup, drizzle, Xtrabackup

With this revision, My xtrabackup branch has been merged into trunk.

What does this mean? It means that we now get a drizzlebackup.innobase binary which is the xtrabackup port for Drizzle. Exciting times.

MySQL data backup: going beyond mysqldump

+1

-0

posted by Open Query on Tue 29 Mar 2011 00:25 UTC
Tags:

(edit) Replication, Backup, mmm, recovery, mysqldump, restore, mariadb, Xtrabackup, Good practice / Bad practice, Software and tools

A user on a linux user group mailing list asked about this, and I was one of the people replying. Re-posting here as I reckon it’s of wider interest. > [...] tens of gigs of data in MySQL databases. > Some in memory tables, some MyISAM, a fair bit InnoDB. According to my > understanding, when one doesn’t have several hours to take a DB > offline and do dbbackup, there was/is ibbackup from InnoBase.. but now > that MySQL and InnoBase have both been ‘Oracle Enterprised’, said > product is now restricted to MySQL Enterprise customers.. > > Some quick searching has suggested Percona XtraBackup as a potential > FOSS alternative. > What backup techniques do people employ around these parts for backups > of large mixed MySQL data sets where downtime *must* be minimised? > > Has your backup plan ever been put to the test? You [Read more...]

On Hot Backups and Restore using XtraBackup

+3

-0

posted by Ovais Tariq on Sun 20 Mar 2011 10:48 UTC
Tags:

(edit) mysql, Backup, ubuntu, innodb, myisam, opensource, Backups, transactions, binlog, Percona, online backup, restore, incremental backup, Hot Backup, Xtrabackup, data consistency, cold backup, compressed backup, innobackupex, offline backup, point-in-time backup, prepare backup, read-lock, streaming backup, throttling, transaction log

Backups are an integral and very important part of any system. Backups allow you to recover your data and be up and running again, in the advent of problems such as system crashes, hardware failures or users deleting data by mistake. I had been evaluating backup solution for a while but to be honest I really wasn't satisfied with the solutions available until I came across XtraBackup and I am loving it since. In this post I intend on showing how to do backups and restores using XtraBackup.

OurSQL Episode 38: Xtrabackup (Backup Series #5)

+3

-0

posted by Technocation on Fri 18 Mar 2011 14:53 UTC
Tags:

(edit) Backup, Podcasts

Previous podcasts in the backup series:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Export Features (advanced mysqldump)

Special Guest Valentine Gostev, QA engineer at Percona, talks about Percona's Xtrabackup, an open source tool for consistent online physical backup of InnoDB and XtraDB.

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

MySQL Links

Top 20 Most Active Authors

Oracle MySQL Blogs

Top 10 Vendor Blogs

Replication Capacity Index