3 ms·
I'll second that. I always like pouring over schemas that have been tested by heavy use - and wikimedia sure has. The only thing that would make the png more
by CalmQuiet 18y ago
I'll second that. I always like pouring over schemas that have been tested by heavy use - and wikimedia sure has.
The only thing that would make the png more valuable would be some accompanying discussion: I'd like to know
who was/were mostly responsible for the design. Seems like I had searched through WP itself one time but found surprisingly little.
what refactoring lessons they encountered during the history of the project.
Much good karma to someone who can get proper credit to the database team!
- ig1 18y agoI'm not sure, but at a guess it would probably be either Lee Daniel Crocker or Brion Vibber.
- vulpes 18y agoI think this guy had a lot to do with it: http://dammit.lt/domas-mituzas/ http://dammit.lt/domas-mituzas/ A lot of interesting info can be found here: http://dammit.lt/uc/workbook2007.pdf http://dammit.lt/uc/workbook2007.pdf
- CalmQuiet 18y agoVulpes, thanks: that .pdf of a 2007 presentation by Domas Mituzas at MySQL Users Conference just about has it all: Cache strategies; performance specifics; application components; DB balancing; storage strategies; use of compression; load balancing; administration; the People involved. Certainly gives any LAMP-based development team a list of resources that have come together to be useful for such a project.