高可用性MySQL

出版时间：2011-1  出版社：东南大学出版社  作者：（美）贝尔，（瑞典）欣达尔，（瑞典）达勒马纳　著  页数：598  
Tag标签：无  

内容概要

　　服务器瓶颈和故障是任何数据库都无法回避的现实问题，但它们不至于导致整体宕机。mysql具有多种特性，可以帮助你保护系统免于失效，无论它运行在硬件、虚拟机上，还是云中。《高可用性mysql》将详细解释如何在各种各样的现实场景中运用这些复制、集群和监控功能特性。
　　《高可用性mysql(英文影印版)》由设计相关工具的工程师编写，披露了很多关于mysql可靠性和高可用性方面未写入文档或者很难找到的内容——对于任何使用该数据库系统的组织都是很重要的知识。
　　 ·探索二进制日志，这是用于实现复制功能的文件，有助于灾难恢复和故障诊断
　　 ·获取改善响应时间和处理大规模数据集的技巧
　　 ·学习如何通过复制来扩展服务器
　　 ·监控数据库活动和性能，以及主要的操作系统参数
　　 ·追踪主从数据库动态，并且处理故障、重启、数据损坏和其他事件
　　 ·使用本书作者编写的开源库代码自动化关键任务
　　 ·学习在虚拟化环境中使用mysql的技巧，比如amazon web services
　　 ?利用mysql cluster实现高可用性

作者简介

　　Charles
Bell博士是一位专注于复制和备份方面的资深开发者。他的兴趣范围包括数据库理论、软件工程和敏捷开发实践。
　　Mats Kindahl博士是MySQL复制与备份团队的复制功能主要开发者。
　　Lars Thalmann博土是MySQL复制与备份团队的开发经理和技术领导者，他设计了很多复制备份方面的功能特性。

书籍目录

foreword
preface
part 1. replication
　1. introduction
　　what's this replication stuff anyway?
　　so, backups are not needed then?
　　what's with all the monitoring?
　　is there anything else i can read?
　　conclusion
　2. mysql replication fundamentals
　　basic steps in replication
　　　configuring the master
　　　configuring the slave
　　　connecting the master and slave
　　a brief introduction to the binary log
　　　what's recorded in the binary log
　　　watching replication in action
　　　the binary log's structure and content
　　　python support for managing replication
　　　basic classes and functions
　　　operating system
　　　server class
　　　server roles
　　　creating new slaves
　　　cloning the master
　　　cloning the slave
　　　scripting the clone operation
　　performing common tasks with replication
　　　reporting
　　conclusion
　3. the binary log
　　structure of the binary log
　　　binlog event structure
　　logging statements
　　　logging data manipulation language statements
　　　logging data definition language statements
　　　logging queries
　　　load data infile statements
　　　binary log filters
　　……
part 2. monitoring and disaster recovery
part 3. high availability environments
appendix: replication tips and tricks
index

章节摘录

版权页：插图：Joel jumped as a sharp rap on his door announced his boss's unapologetic interruption.Before Joel could say "Come in," the boss stepped into his doorway and said, "Joel,we're getting complaints that our response time is getting slow. See what you can doto speed things up. The administrator told me there are too many read operations fromthe applications. See what you can do to offload some of that."Before Joel could respond, Mr. Summerson was out the door and on his way elsewhere."I suppose he means we need a bigger server," Joel thought.As if he had read Joel's mind, Mr. Summerson stuck his head back in the doorway andsaid, "Oh, and by the way, the startup we bought all the equipment from had a bunchof servers we haven't found any use for yet; can you take a look at those and see whatyou can do with them？ OK, Joel？" Then he was gone again."I wonder if I'll ever get used to this," Joel thought as he pulled his favorite MySQLbook off the shelf and glanced at the table of contents. He found the chapter on repli-cation and decided that might fit the bill.

媒体关注与评论

“MySQL复制虽然已广泛部署，但是从未被充分阐释过。本书改变了这一切。”　　——Mark Callaghan MySQL贡献者，担任过多家世界上最大型互联网公司的MySQL工程团队领导

用户评论 (总计6条)

•   公司的Mysql三天两头出这样那样的问题
  搞的大家很郁闷
  我真正第一本学习Mysql关于高可用性的一本书
  希望能给我带来质般的飞跃
  high performance没货了,真可惜
  希望从这本书能踏上我的DBA这路
  哈哈
•   书不错，经典收藏系列。
•   经典书籍还是要看影音版的
•   主要是介绍Mysql基础架设，很不错，可以结合另外一部《高性能MySQL(影印版)(第3版)(英文版)》一起看
•   木有翻译就翻译了个封面，让我等英语极差的情何以堪。。。
•   a really good work about the robust MYSQL, with a very cheap price.