NoSQL performance numbers - MySQL and Redis

hingo's picture

Links to performance numbers posted wrt various NoSQL solutions:

A top 20 global website announced they have migrated from MySQL to Redis. There will be a keynote and everything. It doesn't say how big the Redis Cluster is, but they serve 100M pages / day, and clock 300k Redis queries / second.
https://groups.google.com/forum/?fromgroups#!topic/redis-db/d4QcWV0p-YM

Btw, they mention that MySQL remains as the master data store from which the Redis indexes are generated.
(The reason I don't mention the name of this Redis user is simply I feat my mom is sometimes reading my blog...)

This is an oldie, but already 2 years ago DeNA posted a benchmark doing 750k MySQL queries / second on only a single server. This was with HandlerSocket, the first widely used NoSQL API for InnoDB based MySQL databases.
http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-stor...

Last week MySQL Cluster team announced a new version. (congratulations, fellows!) The hardware in this benchmark is quite beefy: 8 modern servers with Infiniband as the interconnect. Even so the results, again using the NDB NoSQL API, are impressive: 1 billion queries per minute, or 17 million per second.
http://mikaelronstrom.blogspot.com/2012/02/105bn-qpm-using-mysql-cluster...

It should be mentioned the above is not an apples to oranges comparison. The Redis numbers are from a production installation and not a benchmark. Obviously you wouldn't want to max out your performance in production. Quite the contrary: for HA purposes you want to make sure to run at most at 50% your capacity. So if we take this 50% limit into account, then MySQL Cluster can only do a measly 8 million queries per second :-)

PS: I've seen the Austin Powers movies, twice, yet I can't understand the joke in Jonas blog. This can only mean one thing: I have to watch them again now!

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Vladislav Vaintroub's picture

What is "widely used"?

"HandlerSocket, the first widely used NoSQL API for InnoDB based MySQL databases."
Any numbers of how widely it is used? More than 2 installations in production? more than 10?

hingo's picture

In this context, "widely

In this context, "widely used" is more like "used at all outside the original creator". For instance a predecessor to HandlerSocket was MyCache, which was a memcached api but basically ended up just a proof of concept. HandlerSocket is included in Percona Server (and now MariaDB) and has been spoken about in conferences and webinars for two years. I consider it a part of those forks just like any other feature they ship.

NoSQL performance numbers - MySQL and Redis | MySQL | Syngu's picture

Pingback

[...] Links to performance numbers posted wrt various NoSQL solutions: A top 20 global website announced they have migrated from MySQL to Redis. There will be a keynote and everything. It doesn't say how big the Redis Cluster is, but they serve 100M pages / day, and clock 300k Redis queries / second. https://groups.google.com/forum/?fromgroups#!topic/redis-db/d4QcWV0p-YM Btw, they mention that MySQL remains as the master data store from which the Redis indexes are generated. (The reason I don't mention the name of this Redis user is simply I feat my mom is sometimes reading my blog...) read more    MySQL Read the original post on Planet MySQL... [...]

svar's picture

In a last year post, i also

In a last year post, i also explain how to get better then 300K qps with a regular MySQL and this was possible since 10 years!

http://varokism.blogspot.com/2011/01/20-to-50-improvement-in-mariadb-53.....

I would also point an implementation of NoSQL that really bring something new on the table http://tarantool.org/ just like memcache, sphinx such tools are excellent because they do something else where RDBM can not go by design, but make sure to understand the benefite of feature less storage engines with an API on TOP when planing for architecture changes. The issues introduce by such architectures are not that easy to solve, and yes the NDB Cluster team are expert in this for decade now.

When InnoDB read 3-4M records per secondes from a single query how much of REDIS nodes and API do produce the same result? And with how many latency lost on the network ? Now for simple get set agree that it can save you a lot of dev and REDIS is not the worth choice in the galaxy ....

hingo's picture

Ah yes, your post a year ago

Ah yes, your post a year ago is quite enlightening too.

I also think that people that use Redis and the likes probably are attracted to it for its simplicity. Those numbers are not bad, they are just not as good as you get with MySQL. Otoh if you want to stay away from SQL completely, it's probably a good choice. (In the youporn case though their master database is still MySQL, so I actually don't quite get the point...)

Alison's picture

True i think that most people

True i think that most people are attracted to it for its simplicity, me i'm the perfect axample. MtSQL is great but the learning curve is a little bit to steep for me ...
Alison

Youporn oldie | Jaivacorp's picture

Pingback

[...] NoSQL performance numbers – MySQL and Redis | OpenLife.ccFeb 18, 2012 … This is an oldie, but already 2 years ago DeNA posted a benchmark doing …. (In the youporn case though their master database is still MySQL, … [...]

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.