Read the original article at Why you should attend Percona Live 2012
What I loved about Percona Live 2011 Last year I was excited to go to Percona Live for the first time in NYC. I arrived just in time to hear Harrison Fisk from Facebook speak about some of the awesome tweaks they’re running with MySQL there. It’s not everyday that you get to hear from [...]
For more articles like these go to Sean Hull's Scalable Startups
No related posts.
After Gavin Towey’s recent blog post about Percona Server’s buffer pool dump locking the server for the duration of the operation, I thought I should re-examine MySQL 5.6′s implementation of a similar feature. When InnoDB engineers first announced the feature, I didn’t think it was complete enough to serve a DBA’s needs fully.
If you’re not familiar with this topic, MySQL 5.6 will allow the DBA to save the IDs of the database pages that are in the buffer pool, and reload the pages later. This technique can help a server to warm up in minutes instead of hours after a restart or failover.
I read through the documentation, and it looks good. I still think it might be good to have a built-in …
[Read more]At next week’s Strange Loop conference, I will give a talk on “Understanding Indexing”. The session is 10 am Monday, September 24th, and will be held in the Midland States Room.
Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways to increase application performance is to optimize the indexes. This talk presents three simple and effective rules on how to construct indexes around queries that result in good performance.
This is a general discussion applicable to all databases using indexes and is not specific to any particular MySQL® storage engine (e.g., InnoDB, TokuDB®, etc.). …
[Read more]
Github had a recent outage due to malfunctioning automatic
MySQL failover. Having worked on this problem for several
years I felt sympathy but not much need to comment. Then
Baron Schwartz wrote a short post entitled "Is automated failover the root of all evil?"
OK, that seems worth a comment: it's not. Great
title, though.
Selecting automated database failover involves a trade-off
between keeping your site up 24x7 and making things worse by
having software do the thinking when humans are not around.
When comparing outcomes of wetware vs. software it is worth
remembering that humans are not at their best when woken up at
3:30am. Humans go on vacations, or their cell phones run
out of power. …
After Gavin Towey’s recent blog post about Percona Server’s buffer pool dump locking the server for the duration of the operation, I thought I should re-examine MySQL 5.6′s implementation of a similar feature. When InnoDB engineers first announced the feature, I didn’t think it was complete enough to serve a DBA’s needs fully. If you’re not familiar with this topic, MySQL 5.6 will allow the DBA to save the IDs of the database pages that are in the buffer pool, and reload the pages later.
High Performance MySQL has a long discussion on “sharding,” examining many options and their benefits and drawbacks. What does sharding look like in the real world? Years ago I helped shard a MySQL-based application, partitioning its data across multiple database servers. It was already pretty large and significantly complex, so as usual for applications that aren’t designed with sharding in mind from day one, a major consideration for sharding was to make the migration strategy workable and minimize the disruption to the application code.
It's that time of the year again — the summer holidays are over and the conference season starts!
I'm very excited to be at Oracle Open World in San Francisco again, where I will pretty busy. On Saturday and Sunday I will attend MySQL Connect, primarily to man the Oracle Linux booth in the exhibition area. But I hope to catch some of the talks as well (I shared my favourite sessions with Keith Larson from the MySQL team in this interview). During Open World, I will help out manning the Oracle Linux demo pods in the exhibition grounds in Moscone South, where we will showcase Oracle Linux with Ksplice and related technologies. I also have a joint presentation with two of our …
[Read more]This past week Github experienced their most significant service disruption of the year, and much of it came at the hands of an automated failover system they had designed to try to avoid disruptions. There are a number of different factors that made the situation as bad as it was, but the basic summary of what lead to the problem looks like this:
There’s actually more that goes wrong for them after this point, I encourage you to read the full post on the …
[Read more]This past week Github experienced their most significant service disruption of the year, and much of it came at the hands of an automated failover system they had designed to try to avoid disruptions. There are a number of different factors that made the situation as bad as it was, but the basic summary of what lead to the problem looks like this:
There’s actually more that goes wrong for them after this point, I encourage you to read the full post on the …
[Read more]
I have a chance to test Micron RealSSD™ P320h. Initially I was
expecting a good performance, but you know, how big could be a
difference with other products on market? PCIe SSD market is
getting crowded, and every company is trying to show the best
performance. And at the end, there is a single PCIe slot, single
controller, we are probably about to reach limits of these
components.
However I was really surprised to see performance numbers with
Micron P320h.
In random reads the throughput is 3200 MiB/sec,
while the best results I’ve seen so far was 1450
MiB/sec on single card and 2300 MiB/sec
on duo.
And this is 16KiB blocksize, which gives us 200.000 random reads IOP/sec, again in 16K blocks (not 512 or 4096 usually used in public benchmarks).
The write random …
[Read more]