Things are going to be busy over the next few months. I look
forward to meeting many of you from the MySQL community over the
next few months. I would also like to pass along my thanks for
the MySQL Community Award, we (not just Dave and I
but everyone here) are just getting started...
April 22nd -26th - starts things off for the MySQL Community
Team. Dave Stokes and I will be presenting at different two
sessions and available in the demo grounds at Collaborate in
Vegas.
May 2nd -- MySQL heads to the big apple for an OTN Developer Day in NYC. Ronald Bradford as
well as Calvin Sun are among some of the speakers for this …
Apr
17
2012
Apr
17
2012
Last week was full of exciting news for all things MySQL.
However, SkySQL also had some great individual news in that it announced 2 new partners:
I just wanted to take a moment and officially welcome both to the SkySQL fold!
PalominoDB and hastexo, it’s great to be partnered with you!
And we’re looking forward to all the exciting things the future has to hold!
For those interested, you can read more about each partnership here:
[Read more]
Apr
17
2012
The SkySQL & MariaDB: Solutions Day for the MySQL Database (the first of its kind) took place last Friday (April 13th) in Santa Clara, and we’d like to thank everyone who attended, participated and generally helped make it the successful day that it was!
Apr
17
2012
Well, as you or may not have heard, MariaDB 5.5 (5.5.23) was declared GA last week!
It was only about 6-ish weeks ago that MariaDB 5.5 had been released as alpha, so the fact it’s already GA is excellent news for all MariaDB users (and MySQL 5.5 users looking to migrate).
Some of the 5.5 enhancements include:
- Significantly more efficient thread pool, comparable in functionality to the closed source feature in MySQL Enterprise.
- Non-blocking client API Library (MWL#192)
- @@skip_replication option (MWL#234)
- SphinxSE updated to version 2.0.4.
- “extended keys” support for XtraDB and InnoDB
- New INSTALL SONAME statement
- New LIMIT ROWS EXAMINED optimization.
- mysql_real_connect() Changes
In MySQL, and in MariaDB versions before 5.5.21, mysql_real_connect() …
Apr
17
2012
Read the original article at Easy MySQL replication with hotbackups
Setting up replication in MySQL is something we need to do quite often. Slaves die, replication fails, or tables and data get out of sync. Whenever we build a slave, we must start with a snapshot of all the data from the master database.
MySQLdump is the tried and true method of doing this, however it requires that we lock all the tables in the database. If we’re dumping a large database, this could be a significant period, where no writing can happen to our database for the duration of the backup. For many environments read-only is still an outage.
Enter hotbackups to the rescue. Percona comes with a tool that allows you to …
[Read more]
Apr
17
2012
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
Apr
17
2012
The journey to the Hotel in Santa Clara took me something like 16 hours. It was long, arduous and at times despairing, but was it worth it? Absolutely! I made the epic journey with my Pythian (and former Nokia) colleague Andrew Moore, and once at the conference we met up with more members of our [...]
Apr
17
2012
MySQLBoy attends the annual MySQL Conference and Expo host by Percona. [part 1 of 2]
Apr
17
2012
Day 1 is the first official day of the Percona Live MySQL Conference. It began with two mini keynotes by Peter Zaitev and Baron Schwarz of Percona talking about the history of MySQL and his beginnings in the open source movement, respectively. It was very nostalgic, and I’m sure it brought a tear to a few people’s eyes.
Following the dynamic duo was full keynotes by Mårten Mickos (Eucalyptus Systems) on “Making LAMP a Cloud” and Brian Aker (HP) on “The New MySQL Cloud Ecosystem”. To be honest, I found the full keynotes to be quite disappointing. For me, the keynotes speeches should be about a topic that is visionary or notable in some way. What I got from the keynotes were: MySQL is good, MySQL is growing, let me show you my product around MySQL, and buy/use my product. They felt far more like glorified sales pitches.
I remember that at the last conference I attended, SXSW Interactive, the keynotes by Ray …
[Read more]
Apr
17
2012
Day 0 of the MySQL Conference was a day unlike any other day. It was, in fact, tutorial day. While regular days of the Percona Live MySQL Conference feature 50 minute sessions, usually split into a 40 minute talk and a 5-10 minute question period, tutorials are 3-hour-long sessions (with a generous 10 minute break in the middle for those that wish to go to the WC) that provide an in-depth dive into some aspect of MySQL. Due to the length of the tutorials, they are more in-depth and technical than individual sessions can be, but at the same time, we are limited to 2 tutorials slots per day instead of the 5 for sessions.The tutorial schedule for the conference is located here, and with so many good ones, it was hard to choose which one(s) to go to.For the morning session, I attended Peter Zaitev’s tutorial entitled “InnoDB and XtraDB …
[Read more]