Slides for Choosing a MySQL High Availability solution

hingo's picture

Here are the slides to my first talk at Percona Live UK 2011: Choosing a MySQL High Availability solution.1

The main point of feedback I got from this talk was that people appreciated that I had said they shouldn't deploy clustering frameworks that they don't understand. Precious advice indeed!

One member of the audience also came to discuss that they can't use Galera if it reduces the maximum performance by 50% (referring to the disk bound workload). I asked what HA they currently used, and it was MySQL replication. I then commented that they don't get any better performance with that solution either, since MySQL replication is a huge bottleneck, and that for all I know Galera has better throughput than that in all cases. This is good to remember when reading these benchmarks: I'm trying to find out the overhead of different replication solutions by comparing them to the performance of a single server without replication. But this doesn't mean that whatever you run in production would actually have that maximum performance anyway.

Even so, that comment and the recent benchmarks by Tungsten boasting good performance also on a disk bound workload have tickled my curiosity enough. I think I'll have to return to this disk bound Galera test once more to see if I can tune InnoDB to give me better performance. AFAICS there is no reason in Galera itself why it wouldn't be achievable.

The slides are also attached here in both PDF and ODP format.

  1. 1. See this for a review of the conference as a whole: http://openlife.cc/blogs/2011/october/thanks-percona-and-attendees-great-percona-live-uk-2011
AttachmentSize
PerconaLondon2011 - Choosing MySQL HA Solution - Nokia.odp727.29 KB
PerconaLondon2011 - Choosing MySQL HA Solution - Nokia.pdf642.97 KB

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Slides for Choosing a MySQL High Availability... | MySQL | S's picture

Pingback

[...] Here are the slides to my first talk at Percona Live UK 2011: Choosing a MySQL High Availability solution.1 1. See this for a review of the conference as a whole: http://openlife.cc/blogs/2011/october/thanks-percona-and-attendees-great... read more    MySQL Read the original post on Planet MySQL... [...]

dub chrome rims's picture

Reply to comment | OpenLife.cc

Heya fantastic blog! Does running a blog like this require a lot of work?

I've no expertise in coding however I had
been hoping to start my own blog soon. Anyways, if you have any ideas or techniques
for new blog owners please share. I understand this is off subject but
I just wanted to ask. Many thanks!

 [repost ]Slides for Choosing a MySQL High Availability solu's picture

Pingback

[...] [repost ]Slides for Choosing a MySQL High Availability solution  Mysql  Add comments Nov 202011   reddit_url = "http://blog.newitfarmer.com/db/mysql/4153/repost-slides-for-choosing-a-m...";reddit_title = "[repost ]Slides for Choosing a MySQL High Availability solution";reddit_newwindow="1"; original:http://openlife.cc/blogs/2011/november/slides-choosing-mysql-high-availa... [...]

alita1798's picture

www.google.it

Ich habe seeking zu einigen successful Tips Including these Art Of toward Percentage mit meinem website Visitors.
www.google.it

mai2879's picture

Discover More

love, que result in que learned just lo estuve searching. Oneself include terminada mi 4 día very long cacería! Dios te bendiga yourself guy. Consisten en of un Good día. Adios
Discover More

shonda1719's picture

match dating site

Danke on eigene für einige andere instructive Weblog. Genau where else could Possibly ich bin Becoming, style material Created inside Of these Arten von suitable Indicates? Ich include eine Mission, die ich bin quickly at Present Working bei, und ich habe bei der search these material.
match dating site

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Use [fn]...[/fn] (or <fn>...</fn>) to insert automatically numbered footnotes.
  • Allowed HTML tags: <h1> <h2> <h3> <h4> <p> <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <br> <sup> <div> <blockquote> <pre> <img>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically. (Better URL filter.)

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.