Managing a MySQL database server can become a full time job. In many occasions, one MySQL DBA needs to manage multiple, even tens of, MySQL servers, and tools that bundle a set of related tasks into a common utility can be a big time saver, allowing you spend more time improving performance and less time executing repeating tasks. While there are several such utility libraries to choose, it is often the case that you need to customize them to your needs. The MySQL Utilities library is the answer to that need. It is open source so you can modify and expand it as you see fit.

In the latest episode of the "Meet the MySQL Experts" podcast series, Chuck Bell, Sr. MySQL Software Developer at Oracle, introduces a variety of recently released MySQL Utilities, and how DBAs can save significant time using the …

Percona is glad to announce the release of Percona XtraBackup 2.0.1 on June 25th, 2012. Downloads are available from our download site and Percona Software Repositories.

This release is the current GA (Generally Available) stable release in the 2.0 series.

This release contains over 20 fixed bugs, some of the more significant bugs fixed are:

• After creating a full compressed backup, performing a compressed/uncompressed incremental backup would fail because xtrabackup_checkpoints was compressed. This has been fixed by omitting xtrabackup_checkpoints from compression, so that a full backup could be used for incremental backups without decompression. Bug fixed  …

I will be attending the EdMedia 2012 conference this week.

This is a World Conference on Educational Media and Technology, so I look forward to seeing how we can help expand the use of MySQL for educational purposes.

The conference will be in Downtown Denver this year, I look forward to seeing everyone.

SkySQL is hiring! Would you like to join a fast-paced, high-growth company where you’re able to make a difference? Please email us your CV, today, at careers@skysql.com. We look forward to hearing from you!

Here are our current open positions:

QA Engineer

Senior Software Engineer

SkySQL Support Engineer – EMEA

Senior Sales Engineers – EMEA & North America

Senior Consultants – EMEA & North America

For those interested, our full …

We have a new toy to play with. MemSQL is a “Lock Free”, Just In TIme (GIJ) SQL compler (C++) that is MySQL client compatible. It was developed by two former Facebook developers, Eric Frenkiel and Nikita Shamgunov,  and is said to be the world’s fastest.

I gave it a 30min review.  The install was incredibly simple. I use mysqldump to dump a WordPress tables directly into MemSQL and all when well until I  tried to use the website.  MemSQL is NOT a MySQL drop in replacement. But, they don’t say it is.

MemSQL is ACID compliment and might fit well in a small application needing high read write transactions. (Think stock trading.) There is no descriptions on how to scale.  …

New quick-start guide for MySQL DBAs: SkySQL™ Enterprise Monitor makes managing your MySQL & MariaDB databases that much easier

We’ve just published a new Quick Start Guide to SkySQL™ Enterprise Monitor for all MySQL & MariaDB DBAs out there, who are looking for ways to manage their databases more easily.

read more

Volver,
con la frente marchita,
las nieves del tiempo
platearon mi sien…

Martin’s blog (Mi Buenos Aires Querido) was named after a tango, so I decided to follow his lead. The 4 lines of the refrain make reference to someone returning to Buenos Aires after 20 years, now looking a little bit older. I moved to the US about 15 years ago and have returned many times to visit. However, I have never gone back to participate in an event like this with so many renowned speakers from the MySQL community. The list include many people with whom I have worked with over the past decade. …

Get hands-on experience with techniques for tuning a MySQL Server with the Authorized MySQL Performance Tuning course. 

This course is designed for database administrators, database developers and system administrators who are responsible for managing, optimizing, and tuning a MySQL Server.

You can follow this live instructor led training:

• From your desk. Choose from among the 800+ events on the live-virtual training schedule.
• In a classroom. A selection of events/locations listed below

The MySQL Connect Content Catalog is now live and you can check out the great program the content committee put together for you.

We received a lot of very good submissions during the call for papers and we’d like to thank you all again for those, it was a very difficult job to choose.

Overall MySQL Connect will in two days include:

• Keynotes, with speakers such as Oracle Chief Corporate Architect Edward Screven and Vice President of MySQL Engineering Tomas Ulin
• 66 conference …

” There is a variety of services possible via IPTV. Starting with live/linear TV and Video on Demand (VoD) over interactive broadcast related apps, like shopping or advertisement, up to social TV apps where communities of users have shared TV experience”– Stefan Arbanowski. The research center Fraunhofer FOKUS (Fraunhofer Institute for Open Communication Systems) in [...]