News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Justin Carmony's Blog:
MySQL, Redis, and a Billion Rows - A Love Story
May 26, 2011 @ 10:57:24

In a new post to his blog Justin Carmony shares the story of how he took a platform running with MySQL as the backend (Dating DNA) and made the choice to move to Redis for storing compatibility scores for every user in the system.

We wanted not only for people to be able to visit a profile and see a score, which is easy to generate a score on demand. We wanted our users to be able to browse other profiles sorted by their score with them. This requires us to pre-generate and store these scores, and then later query them. [...] I believe we could have bent MySQL to our will and got it to work, but it would be at a high cost of server power, and that cost wouldn't scale well with our revenue stream.

He talks about some of the other options they sorted through including NoSQL databases or building something completely in-house. In the end, though, they decided that Redis was more of what they needed. He prefaces talking about their configuration with some of the limitations of the tool and then moves into their setup and statistics on its use (complete with pretty graphs). He points to predis as their Redis client of choice for PHP.

0 comments voice your opinion now!
mysql redis datingdna casestudy


blog comments powered by Disqus

Similar Posts

PHPit.net: Book Review: Mastering phpMyAdmin for Effective MySQL Management

HowTo Forge: Installing Lighttpd With PHP5 And MySQL Support On Mandriva 2008.0

DotGeek.org: Free Hosting Goes Bingo!

PHPBuilder.com: Introducing the Yii PHP Framework

Kevin Waterson's Blog: Introduction to PHP and MySQL How they work together.


Community Events





Don't see your event here?
Let us know!


opinion artisanfiles series library language podcast tool composer laravel community conference version symfony release list voicesoftheelephpant introduction framework interview security

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework