Application Design
• Use transactions
– Prevents data loss
– Server does less random I/O
– Performance and reliability
• Keep the clients “near” the server
– Network latency is a killer
– Replication can solve geography problems
– Can also help solve geology problems (quake)
– Running app and MySQL on same hardware
Copyright 2003, Jeremy Zawodny