MySQL sharding con 5.000 millones de PV al mes

Posted by Sergi | Filed under Varios

MySQL + sharding + capa de memcache en el acceso a DB + Sphinx para las consultas agregadas. Ideas interesantes, algunas que muchos nos habíamos planteado (memcache en la capa de acceso a datos) y cosas que no sabía, como el table partitioning de MySQL 5.1  (dev.mysql.com/doc/refman/5.1/en/partitioning.html) aunque solo dentro de la misma DB.

Podéis leer el artículo en http://www.jurriaanpersyn.com/archives/2009/02/12/database-sharding-at-netlog-with-mysql-and-php/. Realmente interesante.

Tags: , , , |

Permalink | Marzo 5th, 2009

3 Responses to “MySQL sharding con 5.000 millones de PV al mes”

  1. vehicle shipping Says:
    Junio 10th, 2010 at 8:22 am

    Thats some good basics there, already knew some of that, but you can always learn . I doubt a “kid” could put together such information as dolphin278 suggested. Maybe he’s just attempting to be “controversial? lol

  2. tile roofing Wilmington de Says:
    Junio 28th, 2010 at 8:01 pm

    Good points…I would note that as someone who really doesn’t write on blogs much (in fact, this may be my first post), I don’t think the term “lurker” is very becoming to a non-posting reader. It’s not your fault in the least , but perhaps the blogosphere could come up with a better, non-creepy name for the 90% of us that enjoy reading the content .

  3. smokeless cigarettes Says:
    Julio 3rd, 2010 at 1:30 am

    Terrific Post. Greater then the simillar post I checked 2 days ago on Blogspot. Preserve up the beneficial perform.

Leave a Reply