MySQL Deployment Presentations
I just ran across the MySQL Web 2.0 page which lists a number of their users including the following:
The most interesting thing from that page, however, is links to various presentations given by those sites on how they architected their sites to scale with MySQL, some of them scaling up to hundreds of MySQL servers.
I've included a list of the presentations below because you have to do some page hopping to find which customer pages actually have presentations. The presentations are in PDF and PPT which I've indicated. None of the presentations are in XUL nor do any use the Takahashi method, both of which are becoming more popular.
- eVite 2005-04-19 pdf
- Flickr 2005-10-18 ppt
- Flickr 2006-03-14 pdf: ~25,000 db transactions/second peak
- LiveJournal 2004-04-01 pdf
- LiveJournal 2005-08-04 pdf
- Mixi 2006-04-26 pdf: More than 100 MySQL servers; Add more than 10 servers/month
- Technorati 2006-04-26 ppt
- TicketMaster 2005-09-05 pdf
- Wikipedia 2006-04-26 pdf: >25000 SQL requests per second
I wonder if there's anything similar for PostgreSQL deployments at high traffic sites. Let me know if there are other deployment presentations for MySQL, PosgreSQL or other databases at well known, high traffic sites.
Update: Lukas Kahwe Smith gave me a link to OmniTI's PostgreSQL deployment presentation which discusses their migration from Oracle.
Update 2: Some additional information on MySQL and UUID is available on articles by FeedLounge and Brad Fitzpatrick (chief architect for SixApart). Interesting discussion on how InnoDB clusters by PK.
Update 3: Robert Ficcaglia gave me this link to the Wikimedia Servers page at meta.wikimedia.org. Looks like good reading!