Blogger‎ > ‎

High availability / High scalability pros and cons

posted Sep 11, 2010, 8:52 PM by Ricardo Fonseca   [ updated Sep 11, 2010, 9:13 PM ]
Following my last post, I summarize here a list of the pros and cons of the different solutions previously discussed.


High availability / scalability mode
Pros
Cons

Replication

- Transactional
- Merge
- Snapshot
- Peer-to-peer


[x] Data availability
[x] High scalability
[x] Can be mixed with db mirroring

[x] Good Reporting Solution
[x] Little down time

[x] No automatic fail over
[x] Possible Data Loss
[x] Latency on secondary server
[x] Adv. Setup
[x] Adv. Troubleshooting
[x] Schema driven

Log Shipping

[x] Data availability
[x] High scalability
[x] Easy Setup (FileSystem)
[x] Easy Troubleshooting
[x] can be mixed with db mirroring

[x] Good Reporting Solution
[x] Little down-time
[x] Same database can have multiple destination server

[x] No automatic fail over
[x] Latency on secondary server
[x] Possible Data Loss

[x] Need Shared Folder setup
[x] Require Folder Security
 
Database Mirroring

[x] Automatic failover with witness setup
[x] High availability
[x] Easy Setup
[x] Easy Troubleshooting
[x] No Data Loss
[x] Can be mixed with Log Shipping


[x] Data availability with latency only over snapshot database




Comments