Hi Folks,
Just a quick note to let you know that I am planning to add
support to XtraBackup Manager to work with XtraBackup 2.0 series
releases fairly soon.
Using the XtraBackup 2.0 series will mean that XtraBackup Manager
will no longer need to stage the incremental backups to a
location on the remote host before copying them back to the
XtraBackup Manager storage.
This can be a remarkable efficiency saving for systems with a lot
of page changes between backups.
I will also be trying to address some of the feedback/requests
that I have received in the Google Code Issues section.
Please check out the project in Google Code here, if you have not
already. Feedback and contributions are welcomed!
http://code.google.com/p/xtrabackup-manager/
Cheers,
Lachlan
Hi Everyone,
Just a quick note to let you know that I've just finished up
adding some new features to XtraBackup Manager.
You can now get better visibility into what is going on inside
XtraBackup Manager with the "xbm status"
command.
It will allow you to see which backup jobs are running and also
those which may be waiting to start, due to the maximum number of
concurrent backup tasks already running.
It looks/works as follows:
[xbm@localhost ~]$ xbm status[Read more]
XtraBackup Manager v0.8 - Copyright 2011-2012 Marin Software
Currently Running Backups:
+--------+-----------+-------------+---------------------+-------------------+------+
| Job ID | Host | Backup Name | Start Time | …
Aloha Everybody!
I'm happy to announce XtraBackup Manager Pre-Release
v0.8!
Now that XtraBackup 1.6.4 is released and I have completed some
of my final show-stopper bug fixes, I feel that XtraBackup Manager is now in a state ready for
more general consumption.
I have yet to package up tarballs, but the Quick Start Guide in the Project Wiki contains all the steps you should
need to get up and running from the svn trunk.
There is also some great detailed documentation, including
diagrams of all of the different Backup Strategies …
Hello again!
This week I have been spending some time adding support for
throttling to XtraBackup Manager as it has been considered a
pre-requisite for us using the tool against our production
databases.
In order to add support for throttling, the first thing I did was
to look into what kind of means are available to throttle.
It seems there are two methods, both of which are mentioned in
Percona's docs or blogs.
#1. Use the --throttle=N parameter. You can give this to
innobackupex or to xtrabackup directly. According to the
documentation this will limit xtrabackup to use N IOPs/sec when
running in --backup mode.
For local machine backups this means N total read/write IOPS/sec
and for incrementals this simply means N read IOPS/sec. When
using streaming mode --throttle does not take effect (see
#2).
#2. Use a nifty tool called "pv" (Pipe Viewer). It has a …
Hi Folks,
Just another quick update.
I've been working really hard these past couple of weeks on
getting what I'm hoping is some great documentation happening for
XtraBackup Manager.
There is still more work to be done, but I'm really pleased with
how it's coming along.
Stay tuned… awesome things are coming :)
Meanwhile, to those of you who celebrate Thanksgiving this week
-- have a safe and happy holiday, however you choose to spend
it!
Cheers,
Lachlan
Howdy all,
Just a quick update in the world of XtraBackup Manager
development. In the last couple of weeks I have not been doing a
great deal of work on XtraBackup Manager itself, but rather doing
a lot of testing of XtraBackup Manager and implicitly XtraBackup
along with it.
I hit upon some bugs that were basically roadblocks in the way
that we intend to use XtraBackup and I'm sure issues that other
folks will run into eventually once adoption of XtraBackup
increases even more...
I have been working with Percona and SkySQL Support, as well
as dabbling in some of the code myself to get fixes for these
issues.
The main issues we hit were:
* tar4ibd crashes on certain InnoDB data files (unable to use
streaming backups at all) - This was a regression in pre-release
build of xtrabackup-1.6.3, For now "fixed" by using an older
tar4ibd binary from stable 1.6.2 release. …
Over the past two weeks I have been working on XtraBackup Manager
as much as I can and I'm pleased to say that the command-line
configurator is coming along very nicely!
There is now a generic "xbm" command that will be the way to
manage hosts, storage volumes and backup schedules as well as
doing restores, etc.
So far I have built the volume and host management in and will
begin work on the backup schedules next!
Once this command-line interface is complete, I'll work to
document it on the project wiki on Google Code and it should be
ready for public consumption.
Here is a little preview of how it looks in action - forgive the
ugly wrapping…
[Read more]
xbm@mslvlxbp01:~/xtrabackup-manager$ ./xbm
XtraBackup Manager v0.5 - Copyright 2011 Marin Software
Error: Context missing.
Usage: xbm <context> <action> <args> ... …
It has been a while since I have posted any updates on the
XtraBackup Manager front and I apologise for that. Between taking
some time off for vacation (how dare I!?) and various different
tasks at work snagging my focus away from XBM, I really haven't
had much time to work on it.
(Un)fortunately last week we encountered a DB failure that would
have been much faster and less painful to recover from had we had
XtraBackup Manager finished and in place. While it was a pretty
rough week for us DBAs working on addressing the failure, the
silver lining is that we now have a concrete example to point to
for the importance of the XtraBackup Manager project.
The silver lining in the long story cut short is that I now have
the support I need to focus most of my time on XBM again.
So what have I been working on?
I have added support for materialzed backups to the "Continuous
Incremental" backup strategy.
I have proceeded with …