FOSDEM 2009, one of the biggest European Open Source conferences, will take place on February 7-8 in Brussels, Belgium. Today I received a confirmation from the organizers: MySQL will have a developer room on Sunday, the 8th! This is very cool.

My idea was to organize some kind of MySQL mini-conference, with a focus on developers and DBAs. I am going to send out a more formal CfP soon, but if you have any ideas or suggestions for a talks/sessions already, please get in touch with me!

In addition to the devroom, I have also been invited to give a talk about MySQL High Availability solutions in the conference main track. In this talk I plan to cover some commonly used HA setups for MySQL, including the OSS components/tools (for Linux and …

Notes of one week with MySQL community in US and France

Background

I wanted to attend the first edition of the Open SQL Camp in Charlottesville, from November 14 to 16. For some mysterious reason, a four days plane ticket to any place in the US costs EUR 2,500, but if I stay 8 days, it costs EUR 800. Considering that I was in Frankfurt until November 8, the most sensible thing to do was flying to the US as early as possible and meet as many communities as I could. Among the ones I asked, Boston and New York answered enthusiastically, and then, serendipitously, I found an unexpected group in Baltimore, just before the last leg to Charlottesville.
I sent all groups a list of ten topics to choose from:
* MySQL 5.1 features
* Using MySQL partitions in practice
* testing with MySQL Sandbox
* MySQL Community How To
* Recent community additions to MySQL code
* Creative cross-language …

It has not hit the MySQL DevZone Frontpage yet, but I just finished an interview with Adam Donnison, one of our web gurus behind the mysql.com web site.

Adam talks about what his work environment looks like, his experiences with MySQL 5.1 on the MySQL web sites and why he enjoys working for a virtual organization like ours. Enjoy!

It has not hit the MySQL DevZone Frontpage yet, but I just finished an interview with Adam Donnison, one of our web gurus behind the mysql.com web site.

Adam talks about what his work environment looks like, his experiences with MySQL 5.1 on the MySQL web sites and why he enjoys working for a virtual organization like ours. Enjoy!

Admins in the U.S got a chance to talk shop at EDUCAUSE and the LISA ‘08 summit, but what about those in Europe? Don’t despair, because we’re co-hosting a mini-conference with MySQL, SchoolForge, RedHat, Sun, Op5, and Fusis at our UK headquarters in London on November 27th.

While the presentations are specifically aimed at education as well as the non-profit sector, anyone is welcome to attend. Engage us in discussions about your thoughts on the latest technology, how it blends with your …

Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of "amount". The other is the limit of "age".

-- limit of "amount" --

As you know, buffer pool of InnoDB works as write-back cache of its datafiles. If the buffer pool is filled by dirty blocks, InnoDB cannot allocate new blocks without flushing the dirty blocks and the performance would get worse. This is the limit of dirty block "amount". We can avoid this limit by setting 'innodb_max_dirty_pages_pct' smaller or setting the larger buffer pool size. We might be never at a loss about the limit.

The another limit we should understand is limit of dirty block "age".

-- limit of "age" --

As you know again, because InnoDB write the modifies of datafile to transaction log file synchronously, InnoDB is allowed to treat its buffer pool as write-back …

We have finally found the time to update out presentation pages - we've added the presentation on MySQL Scaling by Sharding and Replication as well as Russian Language presentations I've given at HighLoad++ conference back in October.
Innodb Scalability and New Features (Russian),
Scaling MySQL-powered Web Sites by Sharding and Replication (Russian),
…

I am happy to announce that there now is a MySQL User Group in Los Angeles, California! Their first meetup will take place on Nov. 19th at 7:30pm, Carl Gelbart will give a presentation about "Infobright, an Open Source Data Warehouse". The location has not been finalized yet, it seems: Sun offered them to choose between one of their locations in Universal City, El Segundo or Irvine. Thanks a lot to Joe Devon for stepping up and volunteering to organize this group, it's appreciated!

And if you are not able to join the LA MySQL User Group because you live somewhere else - take a look at http://mysql.meetup.com/ for a local MySQL User Group in your area! If there isn't one yet, have you …

I am happy to announce that there now is a MySQL User Group in Los Angeles, California! Their first meetup will take place on Nov. 19th at 7:30pm, Carl Gelbart will give a presentation about "Infobright, an Open Source Data Warehouse". The location has not been finalized yet, it seems: Sun offered them to choose between one of their locations in Universal City, El Segundo or Irvine. Thanks a lot to Joe Devon for stepping up and volunteering to organize this group, it's appreciated!

And if you are not able to join the LA MySQL User Group because you live somewhere else - take a look at http://mysql.meetup.com/ for a local MySQL User Group in your area! If there isn't one yet, have you …