Today at OSCON, SkySQL introduced the SkySQL™ Recovery Manager. Powered by Zmanda, the SkySQL™ Recovery Manager is the most advanced backup and recovery solution for the MySQL® database. SkySQL’s solution makes life easier for any database administrator in need of a robust, yet flexible and easy to use backup and recovery manager.

With SkysQL Recovery Manager, you will be able to:

• Perform flexible backups
• Provide continuous data protection for you MySQL databases
• Backup live MySQL databases without affecting users or applications
• Perform one-click point-in-time recovery
• Centralize global backup management
• Perform fast backups of MySQL databases running in Amazon EC2®
• Maximize data security
• Monitor backup and recovery functions with automated alerts and reports
• Rapidly deploy your backup and recovery solution
…

A few months have passed since we announced our MySQL 5.6.2 DM based feature preview - Multi-threaded Slaves (MTS) - back in April. Since then, we have had some very good feedback from all around. You deserve a big thank you.

We have now a new snapshot available on labs.mysql.com. This snapshot includes:

• Bug fixes. A lot of them, both in the server core and in the replication layer, especially at the MTS layer.
• Sound recovery procedure. The recovery procedure, which runs on slave threads (re)start, has been improved significantly.
• STOP SLAVE consistently. We have made STOP SLAVE to stop at a consistent point with respect to the master execution history. There were quite a few requests to implement this behavior. That said, one can still stop the SQL thread immediately if one KILLs the …

Dear Kettle users,

Most of you usually use a data integration engine to process data in a batch-oriented way.  Pentaho Data Integration (Kettle) is typically deployed to run monthly, nightly, hourly workloads.  Sometimes folks run micro-batches of work every minute or so.  However, it’s lesser known that our beloved transformation engine can also be used to stream data indefinitely (never ending) from a source to a target.  This sort of data integration is sometimes referred to as being “streaming“, “real-time“, “near real-time“, “continuous” and so on.  Typical examples of situations where you have a never-ending supply of data that needs to be processed the instance it becomes available are JMS (Java Message Service), RDBMS log sniffing, on-line fraud analyses, web or application …

Today at OSCON, SkySQL will introduce the SkySQL™ Recovery Manager.  Powered by Zmanda, the SkySQL™ Recovery Manager is the most advanced backup and recovery solution for the MySQL® database.  SkySQL’s solution makes life easier for any database administrator in need of a robust, yet flexible and easy to use backup and recovery manager.

With SkysQL Recovery Manager, you will be able to:

• Perform flexible backups
• Provide continuous data protection for you MySQL databases
• Backup live MySQL databases without affecting users or applications
• Perform one-click point-in-time recovery
• Centralize global backup management
• Perform fast backups of MySQL databases running in Amazon EC2®
• Maximize data security
• Monitor backup and recovery functions with automated alerts and reports
• Rapidly deploy your backup and recovery …

 Mark Callaghan at facebook tested the test release of MySQL 5.6.3 and he has found some performance improvement with InoDB feature. Read below...

Mark tried two of the previews for MySQL 5.6.3 at http://labs.mysql.com/. His first attempt with the multi-threaded slave preview was not successful. Parallel apply on the slave is serial when the master does not also run 5.6.3. He said (I hope this changes as a typical upgrade is first done on the slave.)

He was more successful with the InnoDB features preview. A few more mutex contention bottlenecks were removed in it and he wanted to compare the peak row update rate between it and MySQL 5.1.52. he configured InnoDB to use a buffer pool large enough to …

So often, you have a task where you need to perform an alteration of a huge table while not wanting to affect the operation of your website. With an alter table, MySQL will internally lock the table in question, create a temporary table with the new table definition, copy the date, then drop the current table, then rename the temporary table to the current table, then unlock tables– not acceptable for a running website!

One way of being able to alter a table without affecting the database (read website application) is using a replicated architecture, particularly having a dual master setup, making the change on the inactive master, then switching, lather, rinse repeat. What if you don’t have a replicated architecture but need some way of making this alteration?

Facebook, a company who I’ve heard has a fair amount of data, would be a likely place to have problems and challenges that we all face as developers and database …

Note: this article was originally published on http://blogs.innodb.com on July 27, 2011 by Calvin Sun.

In April of 2011, InnoDB team published the early access of NoSQL to InnoDB with memcached, plus several new features as part of MySQL 5.6.2 milestone release. This week, we announced additional early access to new InnoDB features for the community to test, and provide feedback.

There are two release packages from InnoDB team on MySQL Labs: InnoDB full-text search, and InnoDB new features.

InnoDB Full-Text Search

MySQL 5.5 makes InnoDB the default …

Monty blogged about MariaDB 5.3 being released as a beta with 5.3.0. We also have a press release. Download it now and test the beta!

The MariaDB Project today announced the availability of MariaDB 5.3.0 Beta. It includes a large number of features and additions while still remaining backwards compatible to MySQL®.

“There are many optimizer changes which makes this a very interesting release, because people will notice that their queries run faster,” said Rasmus Johansson, COO of Monty Program Ab, a commercial backer of MariaDB. “The optimizer developers say it’s the biggest change to the optimizer in ten years”, he added.

A few highlights of the …

If you’re on openSUSE, you definitely want to upgrade to the latest MariaDB release made on 19/07/2011. Previous security fix disabled XtraDB! This is MariaDB 5.1.55.

If you’re using Gentoo, please test MariaDB 5.2 ebuilds in the MySQL overlay. Its current with MariaDB 5.2.7 as well as MariaDB 5.1.55.

In April of 2011, InnoDB team published the early access of NoSQL to InnoDB with memcached, plus several new features as part of MySQL 5.6.2 milestone release. This week, we announced additional early access to new InnoDB features for the community to test, and provide feedback.

There are two release packages from InnoDB team on MySQL Labs: InnoDB full-text search, and InnoDB new features.

InnoDB Full-Text Search

MySQL 5.5 makes InnoDB the default storage engine, so everyone can benefit from ACID-compliant transactions, referential integrity, crash recovery.  However, some users need InnoDB to have built-in full-text search, similar …