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
…

Kursziele:

Der Workshop macht Sie fit für die Entwicklung von Webapplikationen auf Basis von PHP 5 und IBM DB2. Die Themen Objektorientierung, PDO und ibm_db2 stehen dabei im Vordergrund. Dabei zeigt der Kurs die neuen Möglichkeiten, die durch die ibm_db2 Extension realisierbar sind.
Zum Abschluss wird im Team eine kleine Anwendung auf Basis von PHP 5 und IBM DB2 entwickelt.

Inhalt:

• Sprachreferenz PHP
• Objektorientiertes Programmieren mit PHP 5
• Sichtbarkeit, Exceptions und Iteratoren
• PHP und Datenbanken
• Vorstellung von SQLIte, MySQLi und PDO
• IBM DB2 und PHP
• Funktionsumfang der ibm_db2 Extension
• Entwicklung einer eigenen Anwendung

Start: 30.05.2006 10.00 Uhr
Ende: 31.05.2006 17.00 Uhr
Dauer: 2 Tage
Ort: IBM Düsseldorf - PSC - Raum Lippe
…

Digging around the MySQL 5.0 SQL mode docs tonight and see this option:

NO_ENGINE_SUBSTITUTION - Prevents automatic substitution of the default storage engine when a statement such as CREATE TABLE specifies a storage engine that is disabled or not compiled in. (Implemented in MySQL 5.0.8)

Where was that when I needed it?

Back when I switched data storage from the MyISAM to InnoDB storage engine we got burned by not having this option. I had enabled InnoDB on the development box to allow the programmers to start using foreign keys in their database schemas. There was a disconnect on pushing the new functionality up to the testing environment and it went up before InnoDB was enabled on the test database. Unfortunately none of the developers who were pushing the DDL statements up to testing noticed that InnoDB wasn't enabled because …

The Melbourne MySQL User Group April Meetup

Should be fun! I’m going to talk about Cluster.