Normalised data is for sissies
Keep multiple copies of data around
Makes searching faster
Have to ensure consistency in the application logic
But wait!
•Partial replication saves the day•Replicate the portion of the database we want to search.
•But change the table types on the slave to MyISAM
•It can keep up because it’s only handling I/U/D’s on a couple of tables
•And we can reduce the I/U/D’s with a little bit of vertical partitioning
Source by : Cal Henderson
Download
File Size = 621 KB
Tags: Flickr, Internet, Performance, Php, Software