 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
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
|
|