Before I begin, a disclaimer. VoltDB is not a customer, and did not pay Percona or me to investigate VoltDB’s scalability or publish this blog post. More disclaimers at the end. Short version: VoltDB is very scalable; it should scale to 120 partitions, 39 servers, and 1.6 million complex transactions per second at over 300 [...]
Percona Live is on Wednesday – thank you to all our sponsors
Percona Live is in only two days away – and we’ve managed to completely sell out (something I predicted earlier). Before I go into details, I want to thank three sponsors who have been absolutely awesome: Clustrix is providing an open bar all evening, New Relic is providing all attendees with lunch and Fusion-io is [...]
High availability for MySQL on Amazon EC2 – Part 2 – Setting up the initial instances
This post is the second of a series that started here. The first step to build the HA solution is to create two working instances, configure them to be EBS based and create a security group for them. A third instance, the client, will be discussed in part 7. Since this will be a proof [...]
XtraDB Amazon Image
For those who use Amazon EC2 service and were anxious about having XtraDB ready to launch there is a good news. We created a public AMI (Amazon Machine Image) with XtraDB release 8 installed on CentOS 5.3. How to use it. First make sure it is avaiable.
1 2 3 | $ ec2-describe-images ami-4701e22e IMAGE  ami-4701e22e   xtradb/centos-5.3-x86_64.fs.manifest.xml       834362721059   available      public         x86_64 machine $ |
Run it. It is built for x86_64 [...]
Watch out for your CRON jobs
Resolving extreme database overload for the customer recently I have found about 80 copies of same cron job running hammering the database. This number is rather extreme typically the affect is noticed and fixed well before that but the problem with run away cron jobs is way to frequent. If slow down happens on the [...]
OpenSQL Camp 2009
This is just a public service announcement (reminder?) that LenZ and Giuseppe are planning OpenSQL Camp 2009, this time in Europe, which is great. It’ll be part of FrOSCon. I wish I could say that I’ll attend, but due to various unpredictabilities in my family, I can’t plan that far ahead. I don’t yet know [...]
Goal driven performance optimization
When your goal is to optimize application performance it is very important to understand what goal do you really have. If you do not have a good understanding of the goal your performance optimization effort may well still bring its results but you may waste a lot of time before you reach same results as [...]
Percona team at Turkey
Being completely distributed team, meetings are very important for us and this time we went to the Turkey in the end of October (yes, yes I could be faster with sharing photos) This went we went to Turkey, Antalya region, which is a destination which is very easy to reach from Europe as well as [...]
MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
We’ve recently done benchmarks comparing different MySQL versions in terms of their CPU efficiently in TPC-C like Workload. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent, though we do not think results will differ a lot with today versions.
Web Site Optimization: FrontEnd and BackEnd
I spent Monday and Tuesday this week on Velocity Conference It was quite interesting event worth attending and it was very good to see the problems in this are going beyond Apache, PHP, Memcache and MySQL. A lot of talks on this conference was focusing on what is called “FrontEnd”. The meaning of Frontend is [...]

