This is my second article about hacking MySQL. If you are interested in this topic, you may want to read my previous Hacking MySQL: SIGNAL support (I)

The problem

If I tell you there is a function called TRUNCATE, what do you think it does? which are its arguments?

For me, the obvious behaviour would be something like:

mysql> SELECT TRUNCATE(123.45);
+--------------------+
| TRUNCATE(123.45)   |
+--------------------+
|                123 |
+--------------------+
1 row in set (0.08 sec)

But the actual behaviour is this:

mysql> SELECT TRUNCATE(123.45);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

This is because …

How good are your SQL and/or general coding skills? I have a specific challenge I'd like your help solving. I am not sure it's possible, but I'd love to be proven wrong.

So I was surfing around Apple's website this afternoon and found this new Windows download called Safari.  Wondering what it is I downloaded and installed it.  Turns out it's a great memory stress tool.  Check out this screenie of it using nearly 300 megs on my Vista x64 system.

This is great!  I was able to see how all my other apps work in low memory situations.  As useful as that is, right before I was going to write this blog entry I discovered this wonderful app also renders web pages.  Holy cow!!  This is too much.  What are those Apple guys going to think of next?

I sort of agree with Jeremy Cole. This new marketing push using Planet MySQL seems like a cheap advertising stunt.

First, what’s with the highlighted post? Why is it highlighted? Seems like and advertisment.

Which brings up a number of significant questions:

1. Where’s my cut? I write content that’s pushed to Planet MySQL which wouldn’t be attractive for running ads if it wasn’t a collection Plof intelligent authors writing about MySQL.

2. Can competitors run ads on Planet MySQL? Can Oracle run an ad on INNODB? Can Solid run an ad?

Planet MySQL is a community oriented site. Seems like we should keep it that way.

…

Last week I spent some time with Don Marti talking about open source on his podcast for LinuxWorld. Topics include economy of open source, Bitkeeper, and some on the more interesting storage engines that have been released for MySQL.

Catching up over the weekend I noticed Tim's
comment on parallel processing, and followed that over to Nat's
comments about threads.

What does this mean to MySQL? Over a year ago we launched a multi-
concurrency tool, mysqlslap, so that we could start to take apart
the server under high loads. At the time we had five different tools
internally, all written in different languages, all not supplied with
the main binary, and all were hard to use. From this we have been
able to find bugs like the Innodb autoincrement lock (which Heikki is
actively working on), and the lock around temp tables (which Monty is
working on). Its also been …

One of the things MySQL is best known for his helping organizations scale out their architecture.  At this point, probably everyone knows that the largest Web companies use MySQL including the likes of Google, Yahoo, Travelocity and literally hundreds of others.  Let's face it, if you're going to scale to huge traffic and transaction levels an open source architecture can be a heckuva lot more scalable,  It's also more cost effective than paying a "success penalty" (e.g. License fees)  every time you need to add more capacity.  Instead, just keep adding x86 servers running a LAMP stack to scale out rather than having to do a big forklift upgrade.  There are MySQL users that have literally …

MySQL today launched their newest marketing effort, “The 12 Days of Scale-Out“, which is quite timely to our most recent discussions. Zack Urlocker has been busy plugging it onto Planet MySQL. Day one is about Booking.com, “Europe’s largest online hotel travel reservations agency”. Sounds exciting! This could be really interesting!

Only one problem: There is no actual content in …

I'm running into a situation, where I need real multi-master replication, yet as we all know this doesn't exist (yet) in mysql.

So, as a result I'm investigating how I could implement multi-master replication. Fortunately mySQL has documented some of the source code and hosts this documentation online.

http://dev.mysql.com/sources/doxygen/mysql-5.1/slave_8cc-source.html

There are already references and hooks for multi-master replication in slave.cc

 /*
      TODO: replace the line below with
      list_walk(&master_list, (list_walk_action)end_slave_on_walk,0);
      once multi-master code is ready.
 */

Of all the ideas that I have batted around, I've come to a common conclusion, modify mysql source to enable …

MySQL runs a success story about booking.com, Europe’s leading online reservations agency based in the Netherlands. They run on MySQL Enterprise with DRBD.
Kudos to Kris Köhntopp from MySQL for rolling out that solution!