I was happy to see the announcement yesterday from Tokutek regarding their addition of MariaDB to their list of supported platforms for the TokuDB storage engine.

One particular item in the press release caught my eye: “Our customers are choosing MariaDB more and more frequently for their most demanding database applications.” We’ve added many new features over the past year in our various 5.1 and 5.2 releases, but beyond the new goodies we’ve focused a lot of energy on removing bugs and improving performance. We’ve known for a while that MariaDB is the …

I’ll be going to foss.in this year, and am totally excited (the last time I spoke there was in 2007 – Paying it Forward: Harnessing the MySQL Contributory Resources – where I talked about moving from BitKeeper to Bazaar, using Launchpad, the MySQL Forge, and more). This time around, I will be giving a talk titled: MariaDB: The new M in LAMP. I feel a little nostalgia, because the MySQL ecosystem has evolved a lot since December 2007.

The database crew is going to be strong there, as we also have Gary Pendergast, my friend from MySQL (now Oracle) giving a talk titled: Tuning MySQL for Performance, Stability and Fail Safety.

We figured we’d have some kind of meetup, either over chai or if we can …

Tokutek is pleased to announce support for MariaDB for the first time with TokuDB v4.1.1 for MariaDB v5.1.47.

Our customers are choosing MariaDB more and more frequently for their most demanding database applications. We are delighted to help raise MariaDB performance to the next level by making TokuDB available on this new platform. One of our customers, who wishes to remain unnamed for the present time, chose MariaDB + TokuDB for a 3 TB database after having evaluated other MySQL alternatives and finding them unacceptably slow.

TokuDB continues to be the ideal choice for complex / high-volume applications that must have fast response times and that must simultaneously store and query large volumes of rapidly arriving data:

• Social Networking
• Real-time clickstream analysis
• Logfile Analysis
• eCommerce …

MariaDB 5.1 was released in February 2010. MariaDB 5.2 was released in November 2010. In terms of download numbers of MariaDB binaries from mariadb.org, we’ve seen 4x growth, and this is always good news (yes, we had our best download month in November 2010).

I run MariaDB on about six production servers of mine. All the Monty Program infrastructure that uses a database runs MariaDB (varying from 5.1 and 5.2). Monty Program have customers that are using MariaDB in production, and for that, watch out for some case studies.

Now I’d like to know: are you running MariaDB in a production environment?

Does it power your blog? Does it power a huge number of your servers? Have you migrated from another database? I’d like to know. Please shoot colin[AT]montyprogram[dot]com an email so I get a better feeling of how much MariaDB is being used in production environments. Who knows, it might even make a good …

If you are running any GNU/Linux server operating system like RHEL 5 or CentOS 5, you may probably install MySQL server that comes with the operating system packages either during the initial setup or later using yum(8). The advantage being addition/removal of packages either using the GUI package manager or rpm(8), yum(8). Fair enough. But unfortunately the MySQL package (mysql-server) that comes bundled with RHEL 5.5 or CentOS 5.5 is fairly old (5.0.77). What if you want to install the latest stable version of MySQL yet have the advantage of removing/re-installing the software using rpm(8)?

In this blog post, I will guide you with compiling MySQL from source code yet installing the software through rpm(8) so that we tune and configure the software for the target machine and yet uninstall the software using RedHat package manager.

Compiling and Installing MySQL using rpmbuild(8)

First make sure you have sudo(8) access and …

The Danish "julehjerte" is apparently a Danish/Northern Europe Christmas tradition (at least according to Wikipedia). But hopefully people outside this region will also be able to enjoy this variant:

I have been doing "julehjerter" ever since I was a small kid, and every Christmas try to do something different with it. As seen above, this year I decided to combine the tradition with the MariaDB logo, and I am frankly quite pleased with the result :-)

Giuseppe "The Data Charmer" Maxia recently posted his take on the MySQL forks. I had been pondering whether to do the same, and seeing that what I planned to write will nicely complement Giuseppe's article, I was inspired to follow him into the same topic. Note that last Spring I created a Map of MySQL forks in preparation for Monty's keynote at the MySQL user conference. So let's see how things have evolved. I'll look into MySQL ecosystem as a whole and the forks separately.

The post is long, but the key takeaway is that despite the challenges, the combined development seen in the MySQL ecosystem is probably stronger than ever, the current …

New CEOs for Funambol and Openbravo. Funding for 10gen. And more.

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

# Funambol appointed Amit Chawla as its new CEO.

# Openbravo appointed Paolo Juvara as its new CEO and raised a new funding round.

# 10gen raised $6.5m in third-round funding led by Sequoia Capital.

# Microsoft has reportedly invested an undisclosed sum in TurboHercules.

# …

By this definition, when someone who doesn't work at the MySQL project distributes a package that is based on MySQL code but differs …

The following quirky dynamic SQL will scan each index of each table so that they’re loaded into the key_buffer (MyISAM) or innodb_buffer_pool (InnoDB). If you also use the PBXT engine which does have a row cache but no clustered primary key, you could also incorporate some full table scans.

To make mysqld execute this on startup, create /var/lib/mysql/initfile.sql and make it be owned by mysql:mysql

SET SESSION group_concat_max_len=100*1024*1024;
SELECT GROUP_CONCAT(CONCAT('SELECT COUNT(`',column_name,'`) FROM `',table_schema,'`.`',table_name,'` FORCE INDEX (`',index_name,'`)') SEPARATOR ' UNION ALL ') INTO @sql FROM information_schema.statistics WHERE table_schema NOT IN ('information_schema','mysql') AND seq_in_index = 1;
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET SESSION group_concat_max_len=@@group_concat_max_len;

and in my.cnf add a line in the [mysqld] block

init-file = …