After our MySQL Workbench 5.0 GA release and a hotfix release a week later it is time to start our efforts on the next releases. As many of you might already know, my team is highly distributed and when doing planning tasks it is always good to sit together in a single room. So we will be meeting in Kiev, Ukraine next week.We are going to discuss the progress we have already made on the Linux / OS X / Solaris ports but the main focus will be in the new features for the next main release.A big thank you to everybody who posted their ideas on the forum. If you have not posted yet you are welcome to do so. Everything that is submitted before next week will be considered.

The Sun faithful who attended the CommunityOne Conference this morning may not have noticed, but Sun and its MySQL executives were very clear about Sun's open-source strategy going forward, despite news reports that seem to have missed the nuances:

The core will always be 100 percent open source. The periphery...will not. Or might not. It depends.

In response to my first question of the CommunityOne panel Marten Mickos, Senior Vice President of Sun's Database Group, declared, "I just want to say that the core of MySQL will always be 100 percent free and open source." The crowd loved it. Ian Murdock said roughly the same thing: The core will be open....

The periphery? Marten indicated that this would be subject to a corporate calculus designed to determine how much peripheral, closed extensions the company can make to encourage …

UPDATE: There are some examples being added at the MySQL Forge now.

When I first started installing MySQL for myself, it was quite handy to have the example my.cnf files in the source package. I was a noob to the MySQL configuration. Even after I became more experienced, I would use them as a starting point. However, I now find that they are so behind the times they are not as useful. Here are some of the comments from the files.

my-small.cnf

# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it’s important that the mysqld daemon
# doesn’t use much resources.

my-medium.cnf

# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M …

Thanks to all the attendees to the session on creative programming with MySQL at CommunityOne.
As announced, the slides are online. 3.5M (PDF)
Enjoy!

I’m looking forward to getting a couple of enhancements in for MySQL stored procedures - SIGNAL and RESIGNAL - which will help greatly in the area of error handling and management.  Our dev team is working on them now and is in need of some use cases that will help ensure that they hit the mark with the implementation.  Right now the plan is to have them land in the first post-6.0 release of the MySQL Server.

Please check out the worklogs for both SIGNAL and RESIGNAL and then shoot me your thoughts on how you’d use each and any advice/instructions you’d like to give our dev team as they make progress on the tasks.  Send your comments to: rschumacher@mysql.com.  Thanks for your help!

Check out the new OpenSolaris page and download the new OpenSolaris binary distribution.

You can easily download the integrated MySQL packages by using the Package Manager GUI or simply

pkg install SUNWmysql5

As part of the MySQL packages the MySQL Cluster (NDB) storage engine and management binaries are included. You can use the general documentation available at MySQL.comfor setting up a Cluster . Then you should be ready for high availability MySQL.

In a previous post I wrote about how I have started implementing asynchronous I/O into the MySQL client library. I plan on contacting and working with other client API maintainers (PHP, Python, Ruby, …) to make sure this functionality gets pushed out to those places too. Any comments or suggestions on how the interfaces should behave are of course welcome, and I’ll get patches posted somewhere for testing once I have the basics working. This is also my first project going through the MySQL Community Contributions Program so it can be included as part of a later release. I sent out the first contact e-mail to MySQL a week ago, but have not received any response yet. Anyone at MySQL listening? :)

For those of you new to the idea of asynchronous clients, check out …

In the tradition of creative names for MySQL related projects ...

<weigon_> arj... no arjen :(
<dormando> haven't seen him in a few days, huh
<weigon_> http://code.google.com/soc/2008/mysql/appinfo.html?csaid=B0E0C3111A6494AB looked like a proxy job
<weigon_> tokenize the query, replace the constants and rewrite the resultset to something harmless
<dormando> sounds easy
<weigon_> in the tradition of http://jan.kneschke.de/2008/4/23/mysql-proxy-commit-obfuscator
<dormando> :)
<weigon_> I really would like to see applications falling apart when this script is put in between
<dormando> mine fall apart on their own. I need proxy to put them back together :(
<weigon_> Bandaid for MySQL ? :)
<dormando> Pretty much :(
<weigon_> is "bandaid" is trademarked ?
<dormando> It's a brand, so yes I think
<weigon_> otherwise it is ... damn
<dormando> the real term is adhesive-strip or …

OpenSolaris OS 2008.05 is now available for download.  Its quite a departure from traditional Solaris. Why? because the CD that one will be downloading is probably just a chapter in the full book. To understand the full picture one will have to really look at the bigger picture on how the whole deployment model is now changing. The full scope is not my topic of discussion but I probably want to focus on probably couple of pieces today in order to demonstrate on how to create a PostgreSQL OpenSolaris LiveCD.

In order to create a custom LiveCD, its probably best to start with OpenSolaris OS 2008.05 installation though it is not necessary as it can be done on Solaris Express installations also but needs pkg(5) to be installed. But the two things really required to create a custom LiveCD, you need one kit to download and a repository to access. The kit to download …

Check out the new OpenSolaris page and download the new OpenSolaris binary distribution.

You can easily download the integrated MySQL packages by using the Package Manager GUI or simply

pkg install SUNWmysql5

As part of the MySQL packages the MySQL Cluster (NDB) storage engine and management binaries are included. You can use the general documentation available at MySQL.comfor setting up a Cluster . Then you should be ready for high availability MySQL.