I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant customer case to illustrate it. First you need to understand how partitions work internally. Partitions are on the low level are separate table. This means when you’re doing lookup by partitioned key you will look [...]
Percona is looking for a Support Engineer
November 16, 2010 By 1 Comment
As part of our growth process and with the introduction of our Support and Maintenance services, we’re looking for a new Support Engineer.
You would be a part of a unit that operates 24×7 and be the first line of contact for our customers.
Responsibilities include handling or dispatching emergencies and support requests, triaging incoming issues, and ensuring customers always get the attention they need.
The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
One of the big “Selling Points” of MySQL is support for Multiple Storage engines, and from the glance view it is indeed great to provide users with same top level SQL interface allowing them to store their data many different way. As nice as it sounds the in theory this benefit comes at very significant [...]
When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
One question which comes up very often is when one should use SAN with MySQL, which is especially popular among people got used to Oracle or other Enterprise database systems which are quite commonly deployed on SAN. My question in such case is always what exactly are you trying to get by using SAN ?
Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
One of my favorite MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the best general-purpose way to get fast failover and a bunch of other benefits (non-blocking ALTER [...]
7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
I had a call with Monty the other day and I told him why I think MySQL Server Quality will never be the same again. I’ve been thinking a bit more about it and here is the extended list. In particular I think MySQL Server will never be able to reach its original quality guidelines [...]
Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
The trouble with slave lag is that you often can’t see it coming. Especially if the slave’s load is pretty uniform, a slave that’s at 90% of its capacity to keep up with the master can be indistinguishable from one that’s at 5% of its capacity. So how can you tell when your slave is [...]
Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
Sometimes MySQL Replication may run out of sync – because of its own buts or operational limitations or because of application mistake, such as writing to the slave when you should be only writing to the master. In any case you need slave to be synced with Master. To discover the difference between Master and [...]
T2000 CPU Performance – Watch out
May 1, 2008 By 12 Comments
Sun is aggressively pushing T2000 as Scalable MySQL Platforms, and indeed it is Scalable in terms of high concurrency workloads – it is able to execute a lot of concurrent threads and so speed gain from 1 thread to say 32 thread will be significant. But thing a lot of people miss is – Being [...]
MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
Well these days we see a lot of post for and against (more, more) using of MySQL and DRBD as a high availability practice. I personally think DRBD has its place but there are far more cases when other techniques would work much better for variety of reasons. First let me start with Florian’s comments [...]
