Thursday, 20. April 2006

MySQL linkdump

as a follow-up to my previous post, here are some more links:

-> http://meta.wikimedia.org/wiki/Wikimedia_servers#Server_list
1 active master, 6 active slaves; most of the machines having fast disks, RAID-0 and 16GB RAM

-> Status of all Wikipedia MySQL Servers
-> Status of a single Wikipedia MySQL Slave
no swapping! very low "cached" memory number, indicating that InnoDB behaves completely different than MyIsam (resp our setup) regarding disk caching. average system-load is below 1!

memory usage with our setup:
mem-month

-> Brad Fitzpatrick's Notes on LiveJournal at the MySQLcon 2005
(note, you might have already read his notes from 2004, but these slides are updated and provide some more valuable infos)
* "User-Clusters", i.e. livejournal-users are split into several clusters.
* master-master replication-setup
* Use InnoDB. Really. Little bit more config work, but worth it...fast as hell.

Search

 

About michi

michi Michi a.k.a. 'Michael Platzer' is one of the Knallgraus, a Vienna-based New Media Agency, that deals more and more with 'stuff' that is commonly termed as Social Software.

Meet my fellow bloggers at Planet Knallgrau.

my delicious

Recent Updates

My Gadgets

Credits

Knallgrau New Media Solutions - Web Agentur f�r neue Medien

powered by Antville powered by Helma


Creative Commons License

xml version of this page
xml version of this page (summary)

twoday.net AGB

Counter



berufliches
blogosphaerisches
privates
spassiges
sportliches
technisches
trauriges
Profil
Logout
Subscribe Weblog