We have been focusing on providing the best possible backup solution for following scenario: 100 GB+ of data stored in MySQL database, Transaction intensive workload (i.e. rapid rate of change of data), with a business requirement to be able to perform point-in-time restoration of the MySQL database. Oh, the solution also needs to take into account that the database can grow to 1TB or more very quickly.

For such a scenario, we believe that the best possible solution today is a combination of:

1. Storage level snapshots - a capability built into ZFS (Solaris), NetApp, LVM (Linux), VxFS, and VSS (Windows)
2. Transaction logs generated by MySQL
3. Point-and-click restore capability provided by Zmanda Recovery Manager for MySQL

Two reports came out today which go into nitty-gritty of above. First is a joint report written by …

Ponder ponder... you work it out and answer!

MySQL UC is coming up in a few days and I already flew in today (friday).

What a lucky day. Not only it is nice and warm today in San Francisco, no, I also got upgrade to Business to could sleep every well in those cozy seats. The 747 was packed and looks like to had to kick out some frequent flyers to Business to get everyone in. Well, glad I could help.

Now I'm in the 21st floor of the Hilton looking over the Bay to Alcatraz, to Telegraph Hill and Embarcadero. Life is tough.

For monday, expect a nice tutorial on MySQL Proxy given by Giuseppe and me and another session on Proxy on Thursday. See you in Santa Clara.

It's been four years since I started working with open source software and started on the journey to create opentaps Open Source ERP + CRM. Sometimes I look back and think about all the things that have happened, and what I've learned from the open source experience, which is a lot, but a few things stand out:

It's All About Great Software

When you give away the code, there's nothing left to hide. People can -- and will -- judge every aspect of your software: stability, ease of use, code quality, even architecture. Because of this, open source software tends to stand much more on merits. This is why you often will see new open source projects leapfrog past projects with big-name backers or lots of hype.

There is Only One Community

It took me three years to figure this one out: when you create open source software, you're not off on an …

I am happy to announce the release of mylvmbackup version 0.8. mylvmbackup is a tool for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations, while the actual file backup proceeds.

Below is the list of changes since version 0.6. You may wonder what happened to version 0.7 - it had a rather short life cycle as I was informed about a bug that I fixed quickly before I made a wider release announcement of 0.7.

• Fixed a bug in the InnoDB recovery function: the second mysqld process …

Kevin Murphy just posted Tip of the Day ? max_connections and I thought it might be nice to know what people actually set this to so I’ve created a Survey “What’s your max_connections” (totally anonymous).

For the record, while a consultant the record for a production system was 9,500. Yes you read right, and I might add the client was running a 32-bit OS as well, just to boot.
Apparently they had also tested they could get 9,500 connections, problem is they didn’t do anything with the connections, so didn’t see any per thread memory usage, and I did not get confirmation of how the actually system memory usage was used during the test.

I got my registration for Google App Engine this morning after being Waitlisted previously.

Between flying for about 15 hrs tomorrow and then the 2008 MySQL Conference & Expo where I’m presenting and running an Exhibitors booth, fat chance I’ll get to look into this much over the next week.

Pity!

I’ve noticed a change of buttons lately on sites where you can bookmark/share the relevant information. So I’ve done a cross sample of A Computer Site - www.dell.com, The MySQL Acquirer - www.sun.com, A News site - www.cnn.com and a technology information site - www.techcrunch.com

What got me to go back and research is I’d never seen a FaceBook icon before, or perhaps I’d never paid enough attention.

At the end most sites now wash out to a site called Add This.

MySQL Backups Using ZRM For MySQL 2.0

Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server.

I've finally come off the waiting list - and my entry to the Winter Rickshaw Run 09 was accepted. I will be spending Christmas and New Years in India, then off for two weeks driving a vehicle that looks like this:



Yes, two weeks. All of our possessions with us. It's just going to be me and my (other) Australian team mate. Danger, excitement, and probably bad hygiene awaits. If you have suggestions for a team name (team "autocommit=1", "follow the sun"?), or sponsors I should approach let me know!