Somehow I must have missed this  try and buy offer before.  Evaluate the Sun Fire X4600 with PostgreSQL, MySQL or Microsoft SQL Server 2005. The Sun Fire X4600 M2 Server included in the program is available in two configurations. First configuration is  4 x Quad-Core with 16GB RAM and second configuration is with 8x Quad-Core (yes 32 cores in all) with 64GB RAM. Of course it only comes with two disks in it which means also need to "Try and Buy" the Sun StorageTek 2540 Array or the Sun Storage 7110 Unified Storage System with it.

Would love to see some real life deployment saturate 32-core Opteron system using only PostgreSQL or MySQL as the database system in …

• Using the Sandbox as a test for the future production environment is useful. But it would be even more useful if there were a simple way of transferring the contents of a well tested Sandbox to the main server, or transferring the setup of a successfully tuned replication scheme to several production servers. Currently, …

I'm passing the torch to Dave Stokes to manage the MySQL Certified Professionals LinkedIn Group. I'm just not that involved in doing DBA work these days. My career is moving further away from MySQL, plus San Diego isn't a big MySQL town like some other parts of the country. I didn't want the group to grow stagnant and Dave has been very gracious to take it over.

Thanks Dave!MySQL DBA & Programming Blog by Mark Schoonover

I'm passing the torch to Dave Stokes to manage the MySQL Certified Professionals LinkedIn Group. I'm just not that involved in doing DBA work these days. My career is moving further away from MySQL, plus San Diego isn't a big MySQL town like some other parts of the country. I didn't want the group to grow stagnant and Dave has been very gracious to take it over.

Thanks Dave!MySQL DBA & Programming Blog by Mark Schoonover

What would you like to see in a free enterprise-grade monitoring system for your daily MySQL needs?I’m rewriting Monolith - MySQL DBA Console from the ground up. This will be version 2 and I would like to get some input from the global MySQL community.So far I am going with the following; comment with any improvements/additions.

• Variable interval polling of server statistics
• Over 50 different alerts (see list below)
• Graphing of various server statistics (see list below)
• Tuning recommendations with cnf file changes to apply to server
• Change control documents for recommended performance/security tuning
• Threshold based alerting with multiple alert groups: info,warn,critical
• Sorting/ordering of servers via groups. ie: client -> dev,stage,prod
• RSS feeds for each alert group
• XML export with user defined fields for external applications …

I have calmed down after my frustration of a few days ago. My conscience says I was being unfair to Sun’s employees, who are just trying to make a business succeed in difficult times, and who support OpenSQL Camp, Maatkit, MySQL, and many other things that are dear to me. To those I treated harshly, I’m sorry. Just like email, blog posts are easy to publish and impossible to take back.

Image via CrunchBase

I was looking for some non-windows machines for my development team. My development team all use Ubuntu. As hard as I tried, I couldn't really find anything pre-built that didn't have windows on it. I really don't like the idea that I will buy machines with windows on them just to have them formatted and have linux installed over them. And what really gets me is that windows will add to the price of the machine (at time when I'm trying to cut down on all my department's spendings).
I was considering to order computer parts and build the machines myself. But after getting flashbacks of my youth, trying to find the right CPU to fit the right motherboard, I decided that my time could be better spent on other things.
In the end, I found that the best option would be to buy servers for …

Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7

A new era

In the past few years, I published many articles using Oracle as a database server. As a former Sybase system administrator and former Informix employee, it was obviously not a matter of personal choice. It was just because the large majority of Sun's customers running databases were also Oracle customers.

This summer, in our 26 Sun Solution Centers worldwide, I observed a shift. Yes, we were still seeing older solutions based on DB2, Oracle, Sybase or Informix being evaluated on new Sun hardware. But every customer project manager, every partner, every software engineer working on a new information system design asked us : Can we architect this solution with MySQL ?

In many cases, if you dared to reply YES to this question, the next interrogation would be about the scalability of the MySQL engine.

This is why I …

Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7

A new era

In the past few years, I published many articles using Oracle as a database server. As a former Sybase system administrator and former Informix employee, it was obviously not a matter of personal choice. It was just because the large majority of Sun's customers running databases were also Oracle customers.

This summer, in our 26 Sun Solution Centers worldwide, I observed a shift. Yes, we were still seeing older solutions based on DB2, Oracle, Sybase or Informix being evaluated on new Sun hardware. But every customer project manager, every partner, every software engineer working on a new information system design asked us : Can we architect this solution with MySQL ?

In many cases, if you dared to reply YES to this question, the next interrogation would be about the scalability of the MySQL engine.

This is why I …

You Mean, Memory Is Not Infinite? We're working hard getting MySQL Enterprise Monitor 2.0, featuring Query Analyzer, ready for release. As part of that, we started really ramping up the number of MySQL servers reporting in query data to see how we could scale. Not surprising (to me, anyway), the first efforts did not go so well. My old friend OutOfMemoryError reared its ugly head once again.
Query Cache -- It's More Than Just Results! We're big (ab)users of hibernate query caching, and more importantly to us the natural id optimized query cache. Firing up the profiler, I was not shocked to see that the second level (let's call it L2) and query caches were hogging the majority of memory. But, something didn't smell right...

What I was seeing was tons of …