Youporn.com is now a 100% Redis Site

#1

Post by potomak » Thu, Feb 16, 2012, 8:46 AM UTC

Youporn.com is now a 100% Redis Site
groups.google.com

Re: Youporn.com is now a 100% Redis Site

#2

Post by antirez » Thu, Feb 16, 2012, 9:13 AM UTC

That's porn for database geeks: 100 million pageviews per day, 300k requests per second against Redis.

The way they use MySQL is also interesting IMHO: they populate a relational database in order to be able to build new indexes in the Redis side, using the relational DB for the stuff it is best at, generating new "views" of the data easily.

(Relational DBs are also good to do a zillion more things of course.)

Re: Youporn.com is now a 100% Redis Site

#3

Post by badboy » Thu, Feb 16, 2012, 9:15 AM UTC

antirez wrote: post #2

That's porn for database geeks: 100 million pageviews per day, 300k requests per second against Redis. The way they use MySQL is also interesting IMHO: they populate a relational database in order to be able to build new indexes in the Redis side, using the relational DB for the stuff it is best at, generating new "views" of the data easily. (Relational DBs are also good to do a zillion more things of course.)

You know your software is successful when it's used by porn sites :D

Re: Youporn.com is now a 100% Redis Site

#4

Post by pud » Thu, Feb 16, 2012, 9:19 AM UTC

badboy wrote: post #3

antirez wrote: post #2

That's porn for database geeks: 100 million pageviews per day, 300k requests per second against Redis. The way they use MySQL is also interesting IMHO: they populate a relational database in order to be able to build new indexes in the Redis side, using the relational DB for the stuff it is best at, generating new "views" of the data easily. (Relational DBs are also good to do a zillion more things of course.)

You know your software is successful when it's used by porn sites :D

I remember in the 90's having a conversation with my friend. We were discussing Linux vs Windows for web hosting. My friend said "tell me if you can find a single porn site that's hosted on Windows." He was right, I couldn't find any.

Re: Youporn.com is now a 100% Redis Site

#5

Post by thezilch » Thu, Feb 16, 2012, 9:22 AM UTC

antirez wrote: post #2

That's porn for database geeks: 100 million pageviews per day, 300k requests per second against Redis. The way they use MySQL is also interesting IMHO: they populate a relational database in order to be able to build new indexes in the Redis side, using the relational DB for the stuff it is best at, generating new "views" of the data easily. (Relational DBs are also good to do a zillion more things of course.)

We do the same thing, where we populate a mysql store as a secondary storage for business intelligence -- our Founder, PM, AdOps, etc know enough SQL to be dangerous if we build out more traditional, relational models.

It amused me that you were testing a porn site -- the homepage / potentially-misused zrange-issue.

Re: Youporn.com is now a 100% Redis Site

#6

Post by thezilch » Thu, Feb 16, 2012, 9:24 AM UTC

badboy wrote: post #3

antirez wrote: post #2

That's porn for database geeks: 100 million pageviews per day, 300k requests per second against Redis. The way they use MySQL is also interesting IMHO: they populate a relational database in order to be able to build new indexes in the Redis side, using the relational DB for the stuff it is best at, generating new "views" of the data easily. (Relational DBs are also good to do a zillion more things of course.)

You know your software is successful when it's used by porn sites :D

VHS, Linux, and now Redis; the webscale race is over!!

Re: Youporn.com is now a 100% Redis Site

#7

Post by antirez » Thu, Feb 16, 2012, 9:26 AM UTC

thezilch wrote: post #5

antirez wrote: post #2

That's porn for database geeks: 100 million pageviews per day, 300k requests per second against Redis. The way they use MySQL is also interesting IMHO: they populate a relational database in order to be able to build new indexes in the Redis side, using the relational DB for the stuff it is best at, generating new "views" of the data easily. (Relational DBs are also good to do a zillion more things of course.)

We do the same thing, where we populate a mysql store as a secondary storage for business intelligence -- our Founder, PM, AdOps, etc know enough SQL to be dangerous if we build out more traditional, relational models. It amused me that you were testing a porn site -- the homepage / potentially-misused zrange-issue.

I had to test if it was truly fast...

Re: Youporn.com is now a 100% Redis Site

#8

Post by [deleted] » Thu, Feb 16, 2012, 9:26 AM UTC

antirez wrote: post #2

That's porn for database geeks: 100 million pageviews per day, 300k requests per second against Redis. The way they use MySQL is also interesting IMHO: they populate a relational database in order to be able to build new indexes in the Redis side, using the relational DB for the stuff it is best at, generating new "views" of the data easily. (Relational DBs are also good to do a zillion more things of course.)

[deleted]

Re: Youporn.com is now a 100% Redis Site

#9

Post by mvzink » Thu, Feb 16, 2012, 9:27 AM UTC

You know what this means? Salvatore Sanfilippo could be executed if he visits Iran.

Re: Youporn.com is now a 100% Redis Site

#10

Post by pellias » Thu, Feb 16, 2012, 9:30 AM UTC

badboy wrote: post #3

antirez wrote: post #2

That's porn for database geeks: 100 million pageviews per day, 300k requests per second against Redis. The way they use MySQL is also interesting IMHO: they populate a relational database in order to be able to build new indexes in the Redis side, using the relational DB for the stuff it is best at, generating new "views" of the data easily. (Relational DBs are also good to do a zillion more things of course.)

You know your software is successful when it's used by porn sites :D

I was afraid to see what youporn is (at work now), so i guess it is really a porn site.