The MySQL database has become the world?s most popular open source database because of its fast performance, high reliability and ease of use. The DBAs expect the same virtues from a backup solution for MySQL. Often times we are asked what performance to expect from Zmanda Recovery Manager (ZRM) for MySQL. That is why recently we measured backup and recovery performance for MyISAM and InnoDB storage engines using various backup methods available with ZRM.

In our testing we used MySQL 5.0 running Netflix databases available as part of Netflix Prize project. Our 2-way Red Hat Enterprise 4 server with 4 GB of memory was able to copy large files with an average transfer rate of 37 Mb/s.

All details and results are described in a white paper available with a free registration to the Zmanda Network. Here are the important takeaways:

• Logical backups and …

MySQL AB today announced an expanded partnership with Carahsoft Technology Corp., a leading government information technology provider, to accelerate the adoption of the MySQL database among U.S. federal government agencies. Carahsoft is now MySQL AB's Master GSA partner and distributor to the federal public sector channel. MySQL government customers and resellers now have convenient, one-stop access to official MySQL information and training through Carahsoft.

Well, that’s right. Student applications close this Saturday, the 24th, so I’d be right in saying its mid-week, so get your applications coming in for the Google Summer of Code.

To be a bit of a tease, MySQL has actually upped the amount of projects that we think students can accomplish, by adding a brand new section on Replication and Backup Development. Everyone talks about backing up, and this is an excellent way for a student to get inspired by doing something seriously important!

Sheeri Kritzer, long time MySQL DBA and prolific Planet MySQL author, has also decided that she’s going to mentor …

Our friendly Human Resources department started a new initiative this week: We have a Global Sports Day for all our >360 employees in >29 countries. That means that us MySQLers are to get off the keyboard, move our bodies, and document our activities for the rest of the company to see. We are reimbursed for expenses, and the most creative activity / picture / story will get an additional reward.

Lenz and I happened to have planned a Community meeting for today already quite a while ago, so we decided to combine this with the Sports Day. Our local version in Hamburg took us 5,43 km through Niendorfer Gehege in 0:31:35. For myself, this means that I have run a total of 161 km so far this year, for about 15 hours, at an average …

For the first time today I heard someone make this comment:

"When we called Redhat about a question their support hemmed and hawed over an answer."

"Now when we called Oracle they turned around the answer very quickly, and gave us a great response."

Customer support can be very hit or miss, but it did confirm to me that someone is both using and is happy with Oracle's approach to its distribution.

What else did I find interesting about this? The user in question wasn't an Oracle database user, they had for some reason just picked Oracle over Redhat.

Redhat is way a head of the game installations. Even with white box vendors and Oracle making its version available for download, the install base of RHEL is larger. Oracle's Linux is market validation for Redhat's approach to creating a Linux distribution (which is pretty important when you consider the encroachment that Ubuntu …

<p>MyEnv is an environment to run comfortably multiple MySQL instance on one server. You can run even multiple instances with the same binaries.</p> <p>The concept behind this is to separate binaries from databases itself.</p> <p>MyEnv bases on OFA which was adapted and improved by my former employer Trivadis. Their product is called Basenv. MyEnv is not so comfortable but it is free and open.</p>

MyEnv is an environment to run comfortably multiple MySQL instance on one server. You can run even multiple instances with the same binaries.

The concept behind this is to separate binaries from databases itself.

MyEnv bases on OFA which was adapted and improved by my former employer Trivadis. Their product is called TVD-BasEnv. MyEnv is not so comfortable yet but it is free and open.

Requirements

• Perl must be installed.
• A user where mysql runs on must exist.

How to install myenv

 root > su - mysql
 mysql> mkdir -p myenv data etc log product source tmp
 mysql> wget http://www.shinguz.ch/MySQL/myenv.tgz …

In one of my previous posts: MySQL backups, I talked about using a script for automating backups. I show that we can use gzip to compress backup file to compress and save. Since then, our backup file has been growing meg or two a day which is causing our backup files to get [...]

CyberTech, developer and supplier of voice recording solutions, has integrated the MySQL relational database in its MynaVoice software for the storage and analysis of telephone calls. Because the MySQL Server is based on open source and open standards, CyberTech found that it integrated simply, quickly and at very low cost with their own technology.

Waiter: "We have our vegetarian Pad Thai on the menu."

Me: "Can you ask the chef if he puts fish sauce in it?"

Waiter goes off and comes back.

Waiter: "Yes there is fish sauce in the Pad Thai."

Me: "Do you have anything which is vegetarian?"

Waiter: "Well I know people who say they are vegetarian who eat fish..."

Me: "Dude, your friends are not vegetarians."

The argument can go down hill from here. Its simple, if you eat meat, even only sometimes, you aren't a vegetarian.

Its popular in some circles to call yourself a vegetarian. Some people just want to cut down on their meat and find that its an easy way to not eat meat for a night. Some people believe it creates an aura around them.

They aren't vegetarians though.

Open Source software is similar. Weeks ago I saw …