At FOSDEM 2014 ProxySQL and MaxScale were both presented. Both are proxy that can help build sophisticated MariaDB/MySQL architectures. But currently what is the most used proxy with MySQL? It is HAproxy. HAproxy is a level 4 proxy that has no knowledge of the MySQL protocol. Being low level makes it very fast but it [...]

Gigaom published today the news of the latest addition to the SkySQL Management Team. I'd like to share a couple of snippets from the news:

“Roger Levy says SkySQL will move into a relational database innovation phase now, rather than just trying to provide an alternative to Oracle’s MySQL.” - that’s how Giagom’s article today summary’s the latest news from SkySQL.

read more

Amazon micro instances is the great start option for small websites. Learn how to contain oom-killer that may make wrong decision.

oom-killer as MySQL vs Apache arbiter

When it comes to competition for memory oom-killer steps in. I run Apache and MySQL on the same box. This you should probably never do, but I thought that on my tiny setup they will get along. That’s not true. It started when first users came in. The system ran quickly out of memory:

Feb  5 03:48:26 app-01 kernel: [3313052.688189] httpd invoked oom-killer: gfp_mask=0x201da, order=0, oom_adj=0, oom_score_adj=0
Feb  5 03:48:26 app-01 kernel: [3313052.688203] httpd cpuset=/ mems_allowed=0
Feb  5 03:48:26 app-01 kernel: [3313052.688208] Pid: 21297, comm: httpd Not tainted 3.4.73-64.112.amzn1.x86_64 #1
Feb  5 03:48:26 app-01 kernel: [3313052.688214] Call Trace:
Feb  5 03:48:26 app-01 kernel: [3313052.688226]  [] dump_header.constprop.6+0x7e/0x1b0
Feb  5 03:48:26 app-01 …

Next week (Wednesday, February 12 at 10 a.m. Pacific) I will host a webinar titled “Analyze MySQL Query Performance with Percona Cloud Tools.” Percona Cloud Tools, currently in beta, reveals new insights about MySQL performance enabling you to improve your database queries and applications. (You can request access to the free beta here).

For webinar attendees, Percona will raffle five (5) 60-minute MySQL query consulting sessions with me to analyze your Percona Cloud Tools query data and provide feedback and performance suggestions. Read below for how to win.

In the webinar I will cover:

• Setting up Percona Cloud Tools Query Analytics
• Deciphering advanced …

We just published results with improvements in Thread Pool in Percona Server:
Percona Server: Thread Pool Improvements for Transactional Workloads
Percona Server: Improve Scalability with Thread Pool

What I am happy to see is that Percona Server is able to handle a tremendous amount of user connections. From our charts you can see it can go to 16000 active connections without a decline in throughput.

In fact, in our experiments we used 25000 connections and even more, so I think now we face OS limitations in handling connections as …

As you've heard, MaxScale was recently released, and we'd love for you to try it out and let us know your thoughts.

Anders Karlsson and Ivan Zoratti have written some excellent posts on downloading and setting it up, so if you're intersted in that, please see their respective posts for quick, detailed instructions.

read more

See Part 1 and Part 2.

We rejoin our story with a lawsuit. While MySQL suing Progress NuSphere is not perhaps the first GPL lawsuit that comes to mind, it was the first time that the GPL was tested in court. Basically, the GEMINI storage engine was a proprietary storage engine bundled with a copy of MySQL. Guess what? The GPL was found to be valid and GEMINI was eventually GPLed, and it didn’t really go anywhere after that. Why? Probably some business reasons and also, InnoDB was actually rather good and there wasn’t a lawsuit to enforce the GPL there, making business relationships remarkably easier.

In 2003 there was a second round of VC funding. The development team increased …

I’ve been invited to give a Tech Talk at Google next Thursday, February 13th, from 11:00 to 12:30 Pacific time. Unfortunately the talk won’t be streamed live, nor is it open to the general public, but it will be recorded and hosted on YouTube afterwards. I’ve also been told that a small number of individuals might be allowed to attend from outside Google. If you would like me to try to get a guest pass for you, please tweet that to @xaprb.

The topic is, roughly, databases. Officially,

MySQL, SQL, NoSQL, and Open Source in 2014 and Beyond

Predictions are hard to get right, especially when they involve the future. Rather than predict the future, I’ll explain how I view the relational and NoSQL database worlds today, especially the MySQL product and community, but including open-source and …

I’ve been invited to give a Tech Talk at Google next Thursday, February 13th, from 11:00 to 12:30 Pacific time. Unfortunately the talk won’t be streamed live, nor is it open to the general public, but it will be recorded and hosted on YouTube afterwards. I’ve also been told that a small number of individuals might be allowed to attend from outside Google. If you would like me to try to get a guest pass for you, please tweet that to @xaprb.

I've completed a new release of the Connector/Arduino. The new version supports a few refinements and a new feature.

• New! disconnect() method - enables disconnect from server. Note: you must call mysql_connect() to reconnect.
• Better error handling for dropped packets. No more random reboots when bad packet appears.
• Library can recover from short-term loss of connectivity. Along with bad packets is a check to make sure what is received is valid making the connector ignore garbage packets associated with a dropped connection.
• Detection of Out of Memory condition. Should there not be enough memory to allocate the buffer for the Connector, you will see an OOM error (enable the serial monitor to see the errors). This reduces random reboots when memory gets too low.

I made this release because a number of people were running into problems with noisy, tenuous, or just plain …