Properties:

Brian Aker has found general agreement with his post: "The Death of Read Replication".

Arjen Lentz says "I think Brian is right...", and Frank Mash confirmed: "what Brian says about replication, caching and memcached is very true".

Just like Video killed the Radio Star it looks like maybe Memcached killed the Replication Hierarchy!

But of course, Brian and others are talking about replication for scaling reads.

In my session on PBXT next week at the conference I will be talking about how we plan …

I’ll be following closely the progression of Storage Engines available in the MySQL Database server, well soon to be available when 5.1 gets to GA (hopefully by end of Q2 which is what we have been told). Tick, Tick, time is running out.

PrimeBase XT (PBXT) and Blob Streaming is obviously my clear focus, actually now working for PrimeBase Technologies, the company which I want to note for people is an Open Source company, committed at providing an open source alternative to the other commercial players. You also have at the MySQL Conference talks on the the existing InnoDB from Innobase (a subsidiary of market RDBMS leader Oracle). There is a …

Google has just announced their alternative to Amazon’s s3 called ‘App Engine’. 

I think that if this is successful it will provide a shift in some of the basic web development economics and practices, even more than Amazon’s s3 has.

why?
- Small hosting providers (ones that offer a shell account for $12/month) will be marginalized. why pay for something when you get it for free?

- M&A. It will create a 3rd platform to develop on. you currently have LAMP and Windows. The google app engine provides a 3rd. The major difference is you can’t buy it. If we acquire a company who runs on this platform we have 2 choices. continue paying google for the infrastructure, or redevelop it onto LAMP. of course this suits google as their integration costs are lessened. Google might provide a ‘open source’ version of their infrastructure.. but I doubt it.

- …

Yesterday I had the opportunity to attend yet another WebMontag session in Nürnberg this time. Somehow I'm getting a taste for it. The venue this time was not a concert hall, but a meeting room at NIK (de), an organization helping businesses and start ups (it's more than that really). Free drinks, beamer, and a good crowd!
The show started at 18:00 and people were already discussing stuff. I thought I was to late, but at 18:45 we started with a welcoming speech and going around the big table so everyone can introduce himself.

The first presentation by Tobias Lampe was about a new idea: …

Working with MySQL Proxy, besides returning a dataset and an error you could also return a status of successfully executed query, without a dataset being involved. For example, every data modification query (INSERT, UPDATE, DELETE, CREATE ..., DROP ...) returns such a result.
The procedure is similar to returning an error. You must return a different response type and fill in the appropriate fields.

function affected_rows (rows, id)
   proxy.response.type = proxy.MYSQLD_PACKET_OK
   proxy.response.affected_rows = rows
   proxy.response.insert_id = id
   return proxy.PROXY_SEND_RESULT
end

If you call the above function with

 return …

Licensing tends to be a common question, when it comes to giving a talk on MySQL. More recently, some have asked me if MySQL will be relicensed under the CDDL? Some ask why we’re GPLv2 and not GPLv3 yet? And some, genuinely want to know the merits of writing for BSD-based software (PostgreSQL) or GPL-based software (MySQL).

While I am not a soothsayer, I am pretty sure we will not be relicensing MySQL under the CDDL (might make for a good April 1 joke though?). What seems like a logical progression is to probably go GPLv3, from our current GPLv2 stance.

And Sun supports the GPLv3 just as it does many other licenses. Take for example, the recently released Open Service Tag. Its released under a GPLv3 license. Contributing to it, …

Yes, if you are running backing on a large database that is also handling production traffic (not a very smart idea to begin with). This is especially important for backups created using snapshots based on copy-on-write algorithm.

Brian makes an important point in a comment to my post regarding backup. He points out "Backups are always onerous on IO" and that a better way to backup is to use slaves or a standby master (if using multi master replication).

If you *must* run backups on a production server, then ibbackup becomes very important as it doesn't affect performance as much as the evil snapshots created by snapshot tools like fssnap and LVM. I have found that in our case purchasing ibbackup licenses …

Google's announcement tonight is much bigger than I thought. Google is releasing Google AppEngine (site goes live at midnight EST) tonight, a fully-hosted, "automatically scalable" web application platform that consists of Python App servers, BigTable and GFS.

By making App Engine available only for Python, Google is giving the language a big boost.

Amazon's EC2 (Elastic Compute Cloud) allows developers to choose their own stack. Furthermore, Amazon's …