MySQL QA

Now that we have Disk Data for MySQL Cluster you can have the best of both worlds. You can use memory tables for those needing quick access and updates and Disk Data Files for those that will be too large to keep in memory all the time.

One issue with this first release is not having the ability to spread the data and undo files accross the disk sub system using the config.ini file. This can be a important issue for performance. You really don't want to have everything on one disk. Here I list a work around for moving undo and/or data files off to different drives to help in disk performance that I used during performance testing.

1) Bring up the cluster to include all data nodes
2) Each data node will create its own File System ((e.g. ndb_#_fs) where # == the DN ID)).
3) Under the data node FS create the symbolic links …

Jay Pipes gave an amazing tutorial on optimizing performance in MySQL by choosing your indexes and joins well. There were plenty of questions from the audience which he handled well, and in style. Over 50 people attended! And I really feel as though everyone learned a lot. The tutorial ran for 3 hours, but we were engaged until the last, and there were 15-20 people even at the bitter end.

Thanx, Jay! I can’t wait to see how the tutorial goes over at the MySQL Users Conference.

Pictures, video, slides and presentations will be up when we get to it.

MySQL implements the BIT data type differently in different versions, and the behavior is not what one might expect. In this article I’ll explain how MySQL’s behavior has changed over time, what strange things can happen as a result, and how to understand and work around display issues. I’ll tell you about a serious bug I’ve found, and discuss differences in the BIT data type between MySQL and Microsoft SQL Server.

MySQL QA

Testing 5.1 MySQL CLuster is moving along. We now have more automated test cases, have been using TPC-B and DBT2 in testing, conducted load and HA testing.

The great news is that many issues are now found early before the customer base has to deal with them.

This relase will be packed full of great stuff for Cluster including the first release of Disk Data and Replication for MySQL Cluster.

The MySQL User Conf is just a few weeks away where much of this will be shown. Hope to see you there.

In the next few days, we'll be finalizing the schedule for the MySQL Birds of a Feather sessions at the upcoming MySQL Users Conference. I've been working hard with Edwin DeSouza (MySQL's Senior Director of Product Marketing) to get a full and robust set of BoF sessions to meet the varied interests of our enormous community.

Although the mysqluc.com website doesn't yet have all the details (because we're still finalizing the schedule), you can expect to enjoy the following awesome array of Birds of a Feather sessions:

• Programming Languages
  • Perl BoF
  • PHP BoF
  • Ruby BoF
  • .NET/Mono BoF
  • C/C++ BoF
  • Java BoF
• MySQL Functionality and Topics
  • Cluster
  • Replication
  • Backups
  • Partitioning
  • GUI …

Join me tonight at the Boston MySQL Meetup if your in the area! I'll be giving a presentation entitled "Index and Coding Techniques for Optimal Performance", which is a slightly different version of the performance session I'll be giving at the MySQlLUsers Conference in a couple weeks.

I'm really excited about meeting all the Boston MySQLers this evening, for a number of reasons. For one, it looks like there will be more than 50 people attending the meetup tonight, which makes the Boston meetup group one of the largest and most successful in the country. Many thanks should go to Sheeri Kritzer, the local organizer, and Mark Rubin, from MySQL, for their awesome efforts to grow the MySQL community locally in Boston. I'm interested to talk …

oreilly.com got the first scoop, but we'll be officially unveiling opentaps version 0.9 at the MySQL Users Conference 2006. This will be a landmark release for us, the first one combining the Open For Business applications and framework with our Financials and CRM modules to create a complete open source ERP+CRM suite. The combined suite would give e-tailers, retailers, and manufacturers the ability to manage their entire business, from customers to orders to inventory and manufacturing to accounting, …

Using MySQL with SSL has always meant making custom compiles of the client and server — until now.

I was working on the MySQL 5.0.20 changelog when I noticed that the build team will be compiling SSL support into MySQL as of 5.0.20.

So give it a shot when 5.0.20 comes out! Head to http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html and read up on using it, try it out (ignoring the requirement to compile MySQL, gotta get that updated) and help test it.

Some of you may remember a GUI tool named MySQLFront written by Ansgar Becker, a shareware tool for Windows to administrate a MySQL server. The development stopped with version 2.5 in September 2002, because Ansgar no longer had the time to further drive the development. About a year later, the name (not the code) was taken over by Nils Hoyer, who started to develop and sell a product similar in functionality under that name. See this page (in german) for a more detailed history.

Back then, many people had asked Ansgar to turn his work into an Open Source project, which he declined to do (as it would probably have required even more time to maintain properly than just doing the development all by himself).
…

LinuxWorld Expo in Boston last week featured a number of better than average keynotes and panel sessions.  The best one I saw was one called "Is Linux Killing the Enterprise Software Model?"  The panel was moderated by Larry Augustin and featured open source CEOs Marten Mickos (MySQL), Marc Fleury (JBoss), John Roberts (SugarCRM) and Peter Levine(XenSource).

Overall the panel was good.  Marc Fleury was his usual lively self, slamming IBM and old school enterprise software companies.  Marten Mickos was the elder statesman of the panel, providing a good perspective on balancing the needs of enterprise customers and the open source community.   Other good points made:

• Open source software must be easy to consume
…