As you may have seen from his blog, Baron Schwartz is joining our consulting company - Percona in less than a week. This is exciting news for us as Baron is renowned MySQL community member, blogger, co-author of High Performance MySQL second edition book, author of Maatkit and Innotop and just a great guy.

Welcome Baron - We're proud to have you onboard.

So if you always wanted to hire Baron to take a look at your system and help you with high availability scaling optimization or other needs you can do it now by filling out our consulting request form

Entry posted by …

While recently migrating Tschitschereengreen.com from Symfony to Django plus changing the database backend from MySQL to PostgreSQL, there were mainly two tasks more time-consuming than I’ve had thought beforehand:

SQL dump

The old database used a latin1 encoding for the database fields and utf-8 as the server and client connection encoding. With these settings, even trying to get a correctly encoded database dump from phpMyAdmin is a bad idea.

Using mysqldump with an explicitly specified character-set is much better:

mysqldump ? ?default-character-set=latin1 …

Indeed I have a goal of launching a consolidated site of my online presence at ronaldbradford.com at some time soon, and even now I have found I’ve made some SEO 101 mistakes, just in my testing site, and my temporary placeholder.

As a database expert I see plenty of database 101 mistakes with most clients, so part of why my site is going nowhere is I don’t want to make SEO 101 mistakes, especially as I’m not launching a new site, but a migration of existing content to one site.

I see nobody at O’Reilly has made improvements to the redirection mess of the MySQL Conference website as described by Farhan Mashraqi in Someone please change mysqlconf.com redirection, and so rather then linking to …

Effective April 1, I will join Percona full-time as a consultant. I’ll be helping people build high-performance applications with MySQL, but I’ll also be continuing to develop and improve tools such as Maatkit.

This career change has been a long time in progress. I’m really looking forward to it, but at the same time it’s hard to leave my current employer, The Rimm-Kaufman Group (RKG). Working with them has been the best job I’ve ever had. But ultimately, my dream job is to help as many people as I can, and consulting will be a better way to do that.

At a time like this, I like to reflect on the trail that has led here. It’s a good opportunity to realize how fortunate I really am and fill up my gratitude tank. So I’d like to thank everyone who has …

IBM has got back to me with a terse response to some questions I posed following its investment in EnterpriseDB earlier this week (sample Q&A: Q. Is the investment a response to Sun?s acquisition of MySQL? A. No). What IBM does not say is in fact as revealing as what it does say, however.

Here’s the official line:

“IBM has become a minority shareholder of EnterpriseDB. This affords us an opportunity to continue to participate in, and gain further insight into, the open source community. This complements other experiences such as with the Linux, Apache and Eclipse communities and previous investments we’ve made in Red Hat and Novell. IBM has been a long-time supporter of Open Source communities, and we continue to see interest among our clients for Linux and other Open Sources solutions. This investment …

Ronald writes:

Tonight we were told at the NY PHP Meeting MySQL 5.1 is not due to late Q2, so that?s at least June 2008. The MySQL 5.1 Release Notes reveals a history that I don?t find very flattering…

Aside from Ronald’s totally correct observations re. the MySQL release schedule in general, “late Q2″ leads lots of current 5.0 users to a rather “interesting” situation, dictated by a questionable decision on the part of the MySQL marketing team several years back: If “late Q2″ sticks , then you’ve got just over 6 months to do the switchover to 5.1 before 5.0 goes EOL. …

This article contains my notes and detailed instructions on setting up a MySQL cluster. After reading it, you should have a good understanding of what a MySQL cluster is capable of, how and why it works, and how to set one of these bad boys up. Note that I'm primarily a developer, with an interest in systems administration but I think that every developer should be able to understand and set up a MySQL cluster, at least to make the dev environment more robust.

Notes

• High availability. If one or some of the machines go down, the cluster will stay up, as long as there is at least one copy of all data still present. The more redundant copies of data there are, the more machines you can afford to lose.
• Scalability. Distributed architecture allows for load balancing. If your MySQL …

Today sees the release of our latest CAOS report, Turning the Tables? ? The impact of open source on the enterprise database market, which examines - as the subtitle suggests, how much of an impact the open source database projects and vendors have made on the traditional relational database market.

One of the key findings is that open source software has had a superficial impact on the enterprise database market in that adoption has been widespread but shallow. While open source databases have been widely deployed for Web-tier applications, there has been minimal adoption in the enterprise application tier, and adoption for enterprise applications is at this time limited to certain specific application workloads.

Some people may be inclined to disagree with that assessment, but you only have to look at the comparative revenues of the open …

On several occasions this year I’ve been prompted to mention in conversation Ingres as an alternative Open Source Database. Jonathan Levin in A list of Open-Source Alternatives to Business Applications was the latest example where Ingres was not mentioned and perhaps it should have been.

Want features like online backup, online alter, multi-master replication, parallel queries and partitioning. These are all long existing features in a more mature product then MySQL presently. Is this a sleeping giant that nobody remembers about? Ingres has been around a long time, in fact my experience extends back to 1988 (that’s 20 years).

From a product perspective they have created a number of pre-packaged product stacks, for example …

While doing a standard audit for a new client, I recommended a few changes to get better performance. Because I had several changes, I used the documentation at

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

and found that innodb_flush_log_at_trx_commit is a dynamic variable. I was surprised, because most operations dealing with file sizes and operations are not dynamic. But the client proceeded with:

set global innodb_flush_log_at_trx_commit = 2;

and got:

ERROR 1193 (HY000): Unknown system variable 'innodb_flush_log_at_trx_commit'

So I searched for others who may have had the same error, and ended up getting an unintentional googlewhack. Well, it’s not a real Googlewhack, because it has more than 2 …