Joyent, a leading vendor in Enterprise-Class Cloud Computing, announced today that it is taking the proven performance and reliability of Sun Microsystems' MySQL database to a whole new level by offering optimizations to the Joyent Cloud for MySQL. Joyent and Sun's database group have teamed up to create Virtual Appliance templates for MySQL.

Joyent's Virtual Appliance for MySQL is configured to maximize the open source database's performance on Joyent's powerful, secure and stable virtualization technology. Performance benchmarks (www.joyent.com/mysql) demonstrate that Joyent's Virtual Appliance for MySQL can deliver 3 times the number of Transactions per Second than comparable deployments of XEN-based clouds, such as Amazon's EC2.

I'm proud to announce two big news today: First, the new XAMPP with PHP 5.3.0 is finally released and allows everyone the experience of this new PHP version, and secondly, congratulations and many thanks to Carsten Wiedmann, who took over the responsibility for the Windows version. Carsten was able to simplify the Windows version by replacing the installer by a self-extracting archive without losing the ease-of-use of XAMPP.

In all versions we updated Apache (2.2.12), MySQL (5.1.37), PHP (5.3.0), phpMyAdmin (3.2.0.1), plus minor updates of some libraries and tools.

Get the downloads and more details on the specific platforms XAMPP project page.

It is always hard to write these type of posts. It has been a busy ten months for me in the MySQL Community Team and sadly, all too soon it seems, the world changes and I find myself moving to the other side of the fence. As of August 14th, I will no longer be with Sun Microsystems.

Okay, before you get any conspiracy theories, the reasons are simple and personal. I am moving on to see what I can do to found my own startup completely unrelated to developing databases though I fully intend to use MySQL in the near future and if possible, all my life. Sometimes in life you get opportunities given to you which are rare and if you don't jump then regret is all you have, and that is something I refuse to live with.

As for MySQL, I am extremely sad to leave some of the coolest, brightest and most fun people in the world (and by this I mean all of the MySQL and Drizzle folks at Sun). I never thought an extrovert like myself …

Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL", tomorrow at 10 Pacific Time!

Among other topics, Reggie will discuss how to

• Develop your application against SQL Server and then switch it to MySQL with zero code changes

• Optimize your database schema without requiring any code changes in your application

• Use LinQ syntax for type safety in your applications

(Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual Survey, which closed in March 2009, shows that some 73% of MySQL OEM customers develop …

I ran performance tests on my new environment (Linux, 8-core server) for MySQL 5.0.44 and 5.0.84 using sysbench. One result I have seen before. Another result was new.

Sysbench result overview

The new result is that using tcmalloc did not improve performance. I have written about this several times in the past including here. I am not sure what has changed, but my guess is that malloc in glibc 2.5 scales better than in earlier versions. I know that glibc malloc is much faster in glibc 2.10.

The old result is that InnoDB is much faster than MyISAM (on this test). While table scans are fast for MyISAM, there are performance problems on muti-core servers when accessing a few rows by an index key or rowid. And because there is no MyISAM cache for …

Just a small note to advise that Securich reached 0.1.4.
Some new tools include:
* Added Password complexity
* Enhanced `set_password` – Old password is now necessary to replace it by a new one
* Enhanced Revoke privileges to accept regexp
* Added Block user@hostname on a database level
* Added Creation of reserved usernames
* Added Help stored procedure displays help for each stored proc
* Enhanced `create_update_role` to include the removal of privilages from roles
* Enhanced `grant_priveleges` on `alltables` for a database without tables would terminate with an error instead of gracefully (now fixed)
* Added Restore user@hostname on a database level
* Removed ’show warnings’ from sql installation

The database design using workbench is also available in the db folder (for easier understanding of what lies …

I'm a fan of voting on planet mysql posts - but I've also realized that since I'm logged in, it allows someone to keep a pretty valuable silo of information on what interests me. If I vote up a Kickfire or Infobright post, should I expect a sales call to follow?

There's nothing in the FAQ about what happens with the data.

Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL", tomorrow at 10 Pacific Time!

Among other topics, Reggie will discuss how to

• Develop your application against SQL Server and then switch it to MySQL with zero code changes

• Optimize your database schema without requiring any code changes in your application

• Use LinQ syntax for type safety in your applications

(Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual Survey, which closed in March 2009, shows that some 73% of MySQL OEM customers develop …

Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL", tomorrow at 10 Pacific Time!

Among other topics, Reggie will discuss how to

• Develop your application against SQL Server and then switch it to MySQL with zero code changes

• Optimize your database schema without requiring any code changes in your application

• Use LinQ syntax for type safety in your applications

(Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual Survey, which closed in March 2009, shows that some 73% of MySQL OEM customers develop …

I recently did a webcast for O’Reilly and Associates on MySQL Clustering Setup and configuration.

Click here to see a clip over at O’Reilly.