Technocation is proud to announce its first grant to help further the goals of IT professionals. We have helped Proven Scaling’s “Free Ride” to give three people all-expense paid trips to the MySQL conference happening at the end of April. We are proud to have been able to grant Proven Scaling $300 to help, and we hope this is the first of many monetary grants we will give.

Congratulations to the Free Ride winners:
Jan Lehnardt, a student from Münster, Germany; J.R. Bullington, from a non-profit in Sterling Heights, Michigan, USA; and Carlos Proal Aguilar, from a non-profit in Puebla, Mexico. For more details on the contest winners, see Proven Scaling’s announcement at http://jcole.us/blog/archives/2007/03/31/mysql-conference-expo-free-ride-winners/

This grant was made possible by everyone who donated to …

I’ve been preparing for my innotop session at the upcoming MySQL conference, and enlisted Giuseppe Maxia’s MySQL Sandbox to help me get a bunch of MySQL servers, from 3.23.58 to 5.2.3, running on one machine. It was super-easy and has helped me find some bugs in innotop. I should have done this a long time ago. To get started, I just read through Giuseppe’s Sandbox article on O’Reilly Databases Blog. After reading this, I downloaded the scripts and a bunch of binary distributions of MySQL (I’m using Ubuntu).

After reading about the new Firebird 2.1 alpha I was eager to test it, and here are some sample queries that show how the new features look like, all examples are based on the standard EMPLOYEE.FDB.
The first one is about the MERGE statement, which is useful in many ways (my favourite is synching tables).

1. MERGE
2. INTO country c
3. USING (
4. SELECT * FROM country
5. UNION ALL
6. SELECT 'Maroc' country, 'Dirham' currency FROM rdb$database
7. ) cd
8. ON (c.country = cd.country)
9. WHEN MATCHED THEN
10. UPDATE SET
11. country = …

A frequently asked question about MySQL replication is "how do I know whether my slave is identical to the master?" Until recently there hasn't been a good way to know, but now you can compare all the data in your master to the data in the slaves and get a reliable yes-or-no answer. And you can do this online, efficiently, across many servers simultaneously. Read on to find out how.

Guy Kawasaki has never been known as one who follows the crowd. In fact, quite the opposite. He's the type of person that business and technology experts look to for guidance and vision. So, it's only fitting that he's leading off the conference keynotes on Tuesday morning with a talk called "The Art of Innovation". Many of you may recognize the title — one of Guy's most successful books is called "The Art of the Start". In that book, he covered the points that every entrepreneur and start-up hopeful needs to know about getting venture capitalist's attention, developing a mantra (not a business plan!), and taking action instead of talking about taking action.

I don't know why MySQL is so darn popular with startups. Maybe …

I was reading through some old Jeff Nolan posts and came across this one, and it opened a sore. Jeff comments on this CNET article about Oracle's response to Microsoft's per-CPU/socket pricing. Microsoft made the decision to charge per-CPU/socket, not per-core, which throws a bit of a monkey wrench into Oracle's attempts to price per-core, and has the potential to discount Oracle's database pricing by as much as 87%, as Stephen Shankland reported.

I feel for Oracle on this, because customers derive real, tangible value from software running on improved hardware. Customers don't necessarily see it this way, but it's true. Why shouldn't a customer pay for wringing more value out of its software (through improved hardware)?

Jeff sees it very differently, and writes:

…

A frequently asked question about MySQL replication is “how do I know whether my replica is identical to the master?” Until recently there hasn’t been a good way to know, but now you can compare all the data in your master to the data in the replicas and get a reliable yes-or-no answer. And you can do this online, efficiently, across many servers simultaneously. Read on to find out how.

The Cuckoo's Egg by Clifford Stoll has been around for a while, having been published in 1989. It details how a system administrator (a trained astronomer who had to find something else to do) tracked a malicious hacker through his system and numerous others including defense contractors and unclassified DoD systems. It's one of those books a lot of folks who work security say should be read if you're in the field. When I was a cadet at …

I just found post by Kevin, in which he criticizes Master-Master approach, finding Master with many slaves more optimal. There is surely room for master-N-slaves systems but I find Master-Master replication much better approach in many cases.

Kevin Writes "It requires extra hardware thats sitting in standby and not being used (more money and higher capital expenditures)", I'm surprised why would it ? Typically you can use both nodes for most of the reads, and this is in fact use pattern MMM was designed for.

"There's only one machine to act as the standby master. If you have 10 slaves you should be able to fail five times and still be operational." This is valid consideration but honestly for most of applications it is …

Another anecdote from the ongoing Java 1.4 to Java 5 transition... Last time it was an incarnation of "Favor composition over inheritance". This time I am writing about a multi-threading issue which can be equally subtle and difficult to pinpoint.

On the test systems we have set up we observed two strange types of exceptions at seemingly random times and in various different areas of the application. They looked similar to the following two patterns:

• java.lang.ArrayIndexOutOfBoundsException: 432
          at sun.util.calendar.BaseCalendar.getCalendarDateFromFixedDate(BaseCalendar.java:436)
          at java.util.GregorianCalendar.computeFields(GregorianCalendar.java:2024)
          at java.util.GregorianCalendar.computeFields(GregorianCalendar.java:1941)
          at java.util.Calendar.setTimeInMillis(Calendar.java:1066) …