- 积分
- 6147
- UID
- 2
- 阅读权限
- 200
- 注册时间
- 2007-3-19
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 1
|
这是一个很好的关于MySQL高可用的文档,总结的很全面,条理很清楚,其他的讨论可能很多,其实无非就是这么几种解决方案。
如果你是关注MySQL高可用,那么这个文档值得好好研究。不便之处就英文文档,但你可以按照标题,分类去搜索下各自的中文讨论,逐类了解,回头总结,即可全面掌握。
Table of Contents(目录)
1. Executive Summary .............................................................................................. 3
2. Understanding the Causes and Effects of Downtime............................................ 3
2.1. Calculating the Cost & Impact of Downtime 4
3. Determining High Availability Requirements ........................................................ 5
3.1. Establishing Service Level Agreements (SLAs) 5
3.2. Mapping Application Needs to HA Architectures 6
4. Database Replication ............................................................................................ 7
4.1. Replication Modes and Data Consistency 7
4.2. Implementing Replication in MySQL. 8
4.3. MySQL 5.6 Replication Enhancements 9
4.4. Monitoring MySQL Replication ....... 10
5. Clustering & Virtualization................................................................................... 11
5.1. The Oracle VM Template for MySQL Enterprise Edition 13
5.2. Oracle Clusterware XAG Agent for MySQL 14
5.3. Oracle Linux and DRBD.................. 15
5.4. MySQL with Windows Server Failover Clustering 16
5.5. Solaris Cluster................................. 17
6. Shared-Nothing, Failover Clusters ...................................................................... 18
6.1. MySQL Cluster................................ 18
6.2. MySQL Fabric ................................. 20
7. Comparing MySQL HA Solutions .......................................................................... 22
8. Third-Party HA Technologies .............................................................................. 23
9. Operational Best Practices.................................................................................. 23
10. Conclusion ......................................................................................................... 25
11. Additional Resources......................................................................................... 25
|
|