With all the trouble keeping MySQLs built-in replication running, some folks are looking for alternatives.  DRBD provides a distributed block level device, which can provide the sort of database mirroring we need, below the filesystem.  That makes it transparent to MySQL, but nevertheless a great complimentary solution.  In this article we’ll discuss the pros and cons, and then part two will take you step by step through a basic setup.

Read the article on Database Journal – DRBD and MySQL – Excellent Low-cost HA Solution

If you’ve ever opened up drizzled/message/table.proto in the Drizzle source tree you will have seen what’s in the table message: the structure that describes a database table in Drizzle. Previously I’ve talked about the Table message more generally, giving a fair bit of history of the FRM file and how we’ve replaced it with both the Table protobuf message and an infrastructure inside Drizzle so that Storage Engines own their own metadata.

Yesterday I talked about the …

A reminder to those interested in SQL Server to MySQL migrations...there will be a free webinar next Tuesday, Dec 15th @ 10 AM Pacific delivered by LiveTime, a company who specializes in ITIL Service Management and Help Desk Products. They will show you the methodology and tools they use to migrate their customers to MySQL for free. They'll also cover the additional tuning and optimizations they make to these new implementations. Register here.

What more frustrating than full table scan wiping out the buffer pool. You have a nicely tuned busy OLTP server with a warm buffer pool containing the current working set. Then someone submit a report needing to access a table through a full table scan. The normal and current MySQL behavior is to wipe out the content of the cache. if the table is never reused this is pure loss. The server will have to go through a full new warm up phase that can last quite long with a big buffer pool. This issue is now solved with MySQL 5.1.41.

Now that O'Reilly has announced they're going to have a MySQL conference independently of Sun/MySQL, we have decided not to proceed with plans for our own Performance Conference. We are participating in the O'Reilly conference, and we will do everything possible to make that a great success for everyone. See you there!

Entry posted by Baron Schwartz | 5 comments

Add to: …

One week and a whole lot of snow later, it is time for the 173rd edition of Log Buffer, the weekly review of database blogs. MySQL goes first this week.

MySQL

On the MySQL Performance Blog, Peter Zaitsev and his readers discuss the question, how many partitions can you have? In Peter’s opinion, ” . . . be careful with number of partitions you use. Creating unused partitions for future use may cost you.”

Also, Peter’s colleague Aleksandr Kuzminsky announces the release of xtrabackup-1.0, an “open source online …

Sun updates Java platform. Red Hat open sources SPICE. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

# Sun has released Java Platform EE 6, Glassfish 3, and NetBeans 6.8.

# Red Hat released its …

The previous version, MySQL 4.1, instead, will be retired completely. It has ended its extended period. As such, it will be removed from the download page, and also from the download archives. Next year, if you want …

O’Reilly’s official website announces that they are planning a MySQL conference in 2010 (same time, same place). Unlike past years, it isn’t co-presented with Sun/MySQL; they are flying solo. The theme is Information Unleashed.

Related posts:

1. Towards more diversity of speakers at MySQL Conference and Expo We (Percon
2. I’m a MySQL Conference and Expo advocate again So far thi
3. Learn about Maatkit at the MySQL Conference I’m

…

We just made a major software release, but I still don't see journalists queuing outside our office. Looks like I have to do the hard work and interview myself. In the following, I'll give rough reporter treatment to me:

So, what are we talking about?
MySQL/Galera release 0.7 - synchronous multi-master clustering solution for InnoDB.

Downloads? Where?
.e.g. here: https://launchpad.net/codership-mysql

Support?
Sure, here: www.codership.com/services/consulting
But, can't you ask any longer questions?

Oh, sorry, assumed that you geek people prefer not to talk with natural language. But, what is this Galera thingie good for? For whom would you suggest this release?
Practically any innodb user can potentially benefit …