You may have seen in the last couple of weekly news posts that Baron mentioned we are working on a new adaptive flushing algorithm in InnoDB. In fact, we already have three such algorithms in Percona Server (reflex, estimate, keep_average). Why do we need one more? Okay, first let me start by showing the current problems, and then we will go to solutions.

The basic problem is that, unfortunately, none of the existing flushing implementations (including both MySQL native adaptive flushing and that in Percona Server) can handle it properly. Our last invention, “keep_average”, is doing a very good job on systems based on SSD/Flash storage, but it is not so good for regular slow hard drives.

Let me state the following: If you have a lot of memory (and this is not rare nowadays, for example Cisco UCS C250), your database fits into …

We will be presenting a 3h cluster tutorial on Monday April 11 at 9am together with our good friend and Cluster expert from Severalnines (Johan Andersson). If you're interested in learning about how to setup and run a cluster or finding out about best practices and performance tuning tips and tricks, come and listen to us. More info about the tutorial can be found here

See you in Santa Clara!

Max & Joffrey

My last but not least GSoC idea. This is about actual tool that already exists but is currently a little bit broken and needs rewrite with a bigger picture in mind.

What is fillup?

As this project is named fillup-ng, it is obviously supposed to be replacement for existing utility called fillup. Let’s talk a little bit about what fillup currently does. It is used to parse sysconfig files. These files has syntax similar to shell scripts with only variables definitions. The difference is that comments in these scripts has their meaning. And fillup is used to merge them automatically somehow. Basic operation are following. You’ve got some configuration file on your system and new version cames in from package. What now? Classical solution is not to touch anything and let user resolve it manually. But fillup can do some clever things. …

For Open Source projects whose software architecture allows it, inviting developers to extend the core product through add-on modules and plug-ins is a great way to raise interest and awareness and thus kickstart or foster an adoption/contribution cycle. In such a setting, Open Source vendors and their business partners should consider building and maintaining an online marketplace or exchange for add-ons, which will serve as a highly effective distribution and sales channel.

Distribution and Sales Channel

Such a modules marketplace allows business partners and community developers to showcase their work, maximize its visibility and earn money by selling custom modules to end-users.

Typically, you’d find all or some of the following offerings in …

MySQL root user is meant for database administrators for administration task. Many times, I found it's being used as replication user and normal user for making connections to mysql database.

One of my clients did the same thing and later it was fixed.

110329 12:01:13 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.003726' at position 850699172, relay log './poxxxx-relay-bin.000821' position: 11845356
110329 12:01:13 [Note] Slave I/O thread: connected to master 'root@xxx.xx.xx.xxx:3306',  replication started in log 'mysql-bin.003726' at position 850699172

It can be problematic in many scenario and mysql server restart can be required. It leads to below errors and don't allow connections to mysql database.

Too many connections

2011-06-26 update:

I am not sure if there are any changes in the latest make and gcc packages. Anyway, I noticed when run make, I encountered the message below:

make: g: Command not found
make: [qgen] Error 127 (ignored)

To fix this, find where gcc is at, then created a symbolic link g that points to gcc. All is well afterwards:
[root@ip-10-245-209-196 dbgen]# which gcc
/usr/bin/gcc
[root@ip-10-245-209-196 dbgen]# cd /usr/bin/
[root@ip-10-245-209-196 bin]# ln -s gcc g

End update
Recently I found myself doing some data loading benchmark testing with table partition. Data loading and storing for BI/DW/DSS stuff almost always involves data partitioning. SQL Server partition has a nice feature called partition switch, where you can swap data in and out of a partitioned table. …

Are you often trying to find some functionalities into ORACLE 10gR2, ORACLE 11gR2 or MySQL documentation ? Of course each time you are looking for this documentation you find unofficial documentation which is never corresponding to the version you are looking for.. we have the solution, three firefox add-ons that will allow you to easily find the right official Oracle or MySQL documentation you are looking for.

Time is flying by so fast, it sure doesn’t seem like it was last year I was blogging about how Android is for real. Well, let me reiterate … Android is for real. The reason I say that and stress that is despite its success, we see a variety of legal threats, accusations and actual lawsuits to come flying at Android as fast as it is growing in the market.

Still, we seem to be able to fairly easily find agreement among vendors, developers and users that Android development is not slowing down, that legal maneuvering will not pave a path to success or that any ruling or action will take Android-based phones out of consumers’ hands. This is not to say that Android faces significant challenges: real fragmentation and version overload; a software development pace that may be too fast for handset makers or consumers; innovation from rivals …

If you’ve been busy and haven’t registered yet, remember that early-bird pricing ends on 31/03/2011. From April 1-10, you’ll have to pay USD$100 more. A discount code for use (I think you save 20-25%): mys11fsd.

We’re full up in terms of the schedule. People are still asking for an opportunity to speak, and there are still opportunities in the Products & Services track. Please contact Yvonne Romaine at yromaine@oreilly.com for more information on this.

Might I also suggest that if you want to speak and there’s no longer an opportunity, you submit a five-minute talk for the Ignite MySQL event. Even though submissions are now closed, contact Brian Aker — he’ll try and help make some …

I have been working with MySQL replication for quite a while. I have dealt with simple replication setups and I have experimented with complex ones. Five years ago I wrote an article about advanced MySQL replication, which was mostly a dream on what you could do with imagination and skill, but the matter from that article is still not even remotely ready for production. Yet, since that article, I have been approached by dozens of people who wanted to know how to make the multiple master dream become reality. To all of them, I had to say, "sorry, this is just a proof of concept.Come back in a few years, it may become possible". It still isn't.
Despite its latest great technological advance, MySQL native replication is is very poor of topologies. What you can do with MySQL native replication is master-to-slave (which also includes relayed …