MySQL Cluster 7.2 is the best release to date, enabling projects and applications to benefit from web-scalability with carrier-grade availability and developer agility.


Oracle is delighted to announce the immediate availability of the production-ready, GA release of MySQL Cluster 7.2, available for download under the GPL, and as part of the commercial MySQL Cluster Carrier Grade Edition, including management tools, product certifications and 24x7 global support.



70x Higher JOIN Performance, NoSQL Key-Value API & Cross Data Center Sharding with Synchronous Replication
1 Billion Queries per Minute

MySQL Cluster delivered 1 …

Here are the lists of useful tools in comparing database snapshots, files and even folders.

1. dbForge Studio - It is a complete suite for all your needs in managing all your MySQL databases. This software can analyze your data and compare the differences and quickly create the diff statement ready to be executed. dbForge also offers Free edition the dbforge Studio for MySQL Express but of course with limited functionality

Features | Download

• Administration and Maintenance
• Backup
• Data Analysis
• Data Comparison
• Data Editor
• Database Explorer
• Debugger
• Exporting and Importing Data
• MySQL Connectivity
…

Database Best Practices for 2012: A Roadmap to Lower TCOIntended for IT Directors, C-level executives and their direct reports. If your organization suffers from unavailable, inaccurate or less-than-instantaneous data and struggle to strike a balance between affordable IT solutions and those that really deliver, join this webinar series to learn more about high availability paradigm shifts and business continuity best practices.

• Best Practice #1: Spend Less for High Availability.
  Watch it at your convenience. It is available now. (32 minutes)

 Tips, Tricks and Tools to Improve DBA Quality of Life: A Schooner Tech SeriesIntended for DBAs and Sys Admins responsible for managing, monitoring and maintaining data centers.

• Radically Simpler Database Admin: A Tour of the …

Making a compressed backup

mysqldump -u root -p database_name | bzip2 > output.sql.bz2
Restoring the compressed backup

shell> bunzip2 < output.sql.bz2 | mysql -u root -p
Copy database from one server to another

mysqldump db-name | ssh user@remote.box.com mysql -h remote.com db-name
OR

mysqldump -u username -p'password' db-name | ssh user@remote.com mysql -u username -p'password -h remote.com db-name
Copy only table foo to database bar

mysqldump db-name foo | ssh user@remote.box.com mysql bar
OR

mysqldump -u user -p'password' db-name foo | ssh user@remote.com mysql -u user -p'password' db-name foo

Vancouver, 2012-02-17 – One of my first tasks when I started at MySQL AB was to write an introduction letter for myself. At the time, we had a small team that was widely distributed across much of the world and the introduction letter (and yearly all-hands meetings) were important parts of helping our small team work effectively.

As I've worked with different organizations, I've tried to continue the habit – when I start somewhere new, I write a relatively personal introduction and encourage others to do the same.

Here's the letter that I wrote for the Magnolia team.
Thank you Boris! Greetings All,I'm quite happy and excited to be joining the Magnolia team: the product is solid, the people I've interacted with have been great and the company culture seems a good match for me. Also, it doesn't hurt that a dear friend (Sandro Groganz) speaks really highly of Magnolia as a whole.If you are really pressed …

Today I'm coming out of the closet. Since I'm a professional database expert I try to be like the mainstream and use the commercial MySQL forks (including MySQL itself). But I think those close to me have already known for some time that I like community based open source projects. I cannot deny it any longer, so let me just say it: I'm a Drizzle contributor and I'm very much engaged!

I've been eyeing the Drizzle project since it started in 2008. Already then there were dozens of MySQL hackers for which this project was a refuge they instantly flocked to. Finally a real open source project based on MySQL code that they could contribute to, and they did. It was like a breath of fresh air in a culture that previously had only accepted one kind of relationships: that between an employer and an employee. Drizzle was more liberal. It accepted also forms of engagement already common in most other open source projects that are based on …

This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship.

Some basic facts

• Most of …

As MySQL Community Managers, Dave an myself are always looking for ways to gather feedback on MySQL. 
We want to make ourselves available to you. The current plan is the last Monday of every month Dave and Myself will be on #freenode and join a chat room called MySQL_user_groups. 
We will also try to be available as much as possible in a chat room called MySQL_Community.
You can join us and ask questions or just let us know your opinions. 
We want to hear about everything from your best presentation topics, to the worst. What is the biggest struggle you find with user groups ? How could Oracle help? 

We’ve released a new set of monitoring plugins for MySQL servers and related software. With these plugins, you can set up world-class graphing and monitoring for your MySQL servers, using your own on-premises Cacti and Nagios software. The Cacti plugins are derived from an existing set of templates we’ve been using for several years, but the Nagios check plugins are brand new. They are informed by the research we did into the causes and preventions of MySQL downtime.

Like all Percona software, the plugins are open-source and free, licensed under the GNU GPL. The source code and issue tracker are hosted at …

I have been at Mozilla nearly three months, and I used to blog a lot more than I currently do. A lot of the content I used to blog about I end up blogging and talking about in OurSQL: The MySQL Database Community Podcast. And I have also been getting used to the Mozilla firehose, as well as my own firehose of database projects that need to be done.
There are two very large projects that are time-sensitive that I am working on: migrating databases from an older data center to a newer one, and the impending public launch of the Mozilla Apps Store.
That being said, this week in Mozilla databases we have:
- migrated/improved/built our dev/stage databases for Socorro, our crash stats database.
- put monitoring on a newer backup server, after a random check …