高可用性MySQL(英文影印版)

.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
triggers, events, and stored routines
stored procedures
stored functions
events
special constructions
nontransactional changes and error handling
logging transactions
transaction cache
distributed transaction processing using xa
binary log management
the binary log and crash safety
binlog file rotation
incidents
purging the binlog file
the mysqlbinlog utility
basic usage
interpreting events
binary log options and variables
conclusion
4. replication for high availability
redundancy
planning
slave failures
master failures
relay failures
disaster recovery
procedures
hot standby
dual masters
semisynchronous replication
slave promotion
circular replication
conclusion
5. mysql replication for scale-out
scaling out reads, not writes
the value of asynchronous replication
managing the replication topology
example of an application-level load balancer
hierarchal replication
setting up a relay server
adding a relay in python
specialized slaves
filtering replication events
using filtering to partition events to slaves
data sharding
shard representation
partitioning the data
balancing the shards
a sharding example
managing consistency of data
consistency in a nonhierarchal deployment
consistency in a hierarchal deployment
conclusion
6. advanced replication
replication architecture basics
the structure of the relay log
the replication threads
starting and stopping the slave threads
running replication over the internet
setting up secure replication using built-in support
setting up secure replication using stunnel
finer-grained control over replication
information about replication status
options for handling broken connections
how the slave processes events
housekeeping in the i/o thread
sql thread processing
slave safety and recovery
syncing, transactions, and problems with database crashes
rules for protecting nontransactional statements
multisource replication
row-based replication
options for row-based replication
mixed-mode replication
events for handling row-based replication
event execution
events and triggers
filtering
conclusion
part ⅱ. monitoring and disaster recovery
7. getting started with monitoring
ways of monitoring
benefits of monitoring
system components to monitor
processor
memory
disk
network subsystem
monitoring solutions
linux and unix monitoring
process activity
memory usage
disk usage
network activity
general system statistics
automated monitoring with cron
mac os x monitoring
system profiler
console
activity monitor
microsoft windows monitoring
the windows experience
.the system health report
the event viewer
the reliability monitor
the task manager
the performance monitor
monitoring as preventive maintenance
conclusion
8. monitoring mysql
what is performance?
mysql server monitoring
how mysql communicates performance
performance monitoring
sql commands
the mysqladmin utility
mysql gui tools
mysql administrator
mysql query browser
server logs
third-party tools
the mysql benchmark suite
database performance
measuring database performance
database optimization best practices
best practices for improving performance
everything is slow
slow queries
slow applications
slow replication
conclusion
9. storage engine monitoring
myisam
optimizing disk storage
tuning your tables for performance
using the mylsam utilities
storing a table in index order
compressing tables
defragmenting tables
monitoring the key cache
preloading key caches
using multiple key caches
other parameters to consider
innodb
using the show engine command
using innodb monitors
monitoring'logfiles
monitoring the buffer pool
monitoring tablespaces
using information_schema tables
other parameters to consider
conclusion
10. replication monitoring
getting started
server setup
inclusive and exclusive replication
replication threads
monitoring the master
monitoring commands for the master
master status variables
monitoring slaves
monitoring commands for the slave
slave status variables
replication monitoring with mysql administrator
other items to consider
networking
monitor and manage slave lag
causes and cures for slave lag
conclusion
11. replication troubleshooting
what can go wrong
problems on the master
problems on the slave
advanced replication problems
tools for troubleshooting replication
best practices
know your topology
check the status of all of your servers
check your logs
check your configuration
conduct orderly shutdowns
conduct orderly restarts after a failure
manually execute failed queries
common procedures
reporting replication bugs
conclusion
12. protecting your investment
what is information assurance?
the three practices of information assurance
why is information assurance important?
information integrity, disaster recovery, and the role of backups
high availability versus disaster recovery
disaster recovery
the importance of data recovery
backup and restore
backup utilities and os-level solutions
the innodb hot backup application
physical file copy
the mysqldump utility
xtrabackup
logical volume manager snapshots
comparison of backup methods
backup and mysql replication
backup and recovery with replication
pitr
automating backups
conclusion
13. mysql enterprise
getting started with mysql enterprise
subscription levels
installation overview
mysql enterprise components
mysql enterprise server
mem
mysql production support
using mysql enterprise
installation
fixing monitoring agent problems
monitoring
query analyzer
further information
conclusion
part ⅲ. high availability environments
14. cloud computing solutions
what is cloud computing?
cloud architectures
is cloud computing an economical choice?
cloud computing use cases
cloud computing benefits
cloud computing vendors
aws
a brief overview of technologies
how does it all work?
amazon cloud tools
getting started
working with disk
where to go from here
mysql in the cloud
mysql replication and ec2
best practices for using mysql in ec2
open source cloud computing
conclusion
15. mysql cluster
what is mysql cluster?
terminology and components
how does mysql cluster differ from mysql?
typical configuration
features of mysql cluster
local and global redundancy
log handling
redundancy and distributed data
architecture of mysql cluster
how data is stored
partitioning
transaction management
online operations
example configuration
getting started
starting a mysql cluster
testing the cluster
shutting down the cluster
achieving high availability
system recovery
node recovery
replication
achieving high performance
considerations for high performance
high performance best practices
conclusion
appendix: replication tips and tricks
index

.　　Chapter 12, Protecting Your Investment, explains the use of backups and disaster recovery techniques.
　　Chapter 13, MySQL Enterprise, introduces a suite of tools that simplifies many of the tasks presented in earlier chapters.
　　Part Ⅲ, High Availability Environments
　　Chapter 14, Cloud Computing Solutions, introduces the most popular cloud computing service, the Amazon.com AWS, and offers techniques for using MySQL in such virtualized environments.
　　Chapter 15, MySQL Cluster, shows how to use this tool to achieve high availability. The Appendix, Replication Tips and Tricks, offers a grab bag of procedures that are useful in certain situations.
　　Conventions Used in This Book
　　The following typographical conventions are used in this book:
　　Plain text
　　Indicates menu titles, options, and buttons.
　　Italic
　　Indicates new terms, table and database names, URLs, email addresses, filenames, and Unix utilities.
　　Constant width
　　Indicates command-line options, variables and other code elements, the contents of files, and the output from commands.
　　Constant width bold
　　Shows commands or other text that should be typed literally by the user.
　　Constant width italic
　　Shows text that should be replaced with user-supplied values.
　　This icon signifies a tip, suggestion, or general note.
　　This icon indicates a warning or caution.
　　Using Code Examples
　　This book is here to help you get your job done. In general, you may use the code in this book in your programs and documentation. You do not need to contact us for permission unless you're reproducing a significant portion of the code. For example,writing a program that uses several chunks of code from this book does not require permission. Selling or distributing a CD-ROM of examples from O'Reilly books does require permission. Answering a question by citing this book and quoting example code does not require permission. Incorporating a significant amount of example code from this book into your product's documentation does require permission.
　　We appreciate, but do not require, attribution. An attribution usually includes the title,author, publisher, and ISBN. For example: "MySQL High Availability, by Charles Bell,Mats Kindahl, and Lars Thalmann. Copyright 2010 Charles Bell, Mats Kindahl, and Lars Thalmann, 9780596807306."
　　If you feel your use of code examples falls outside fair use or the permission given above, feel free to contact us at permissions@oreilly, com.
　　We'd Like to Hear from You
　　Every example in this book has been tested on various platforms. The information in this book has also been verified at each step of the production process. However, mistakes and oversights can occur and we will gratefully receive details of any you find, as well as any suggestions you would like to make for future editions. You can contact the author and editors at:
　　O'Reilly Media, Inc.
　　1005 Gravenstein Highway North
　　Sebastopol, CA 95472
　　800-998-9938 (in the United States or Canada)
　　707-829-0515 (international or local)
　　707-829-0104 (fax)
　　We have a web page for this book, where we list errata, examples, and any additional information. You can access this page at:http://www.oreilly.com/catalog/9780596807306
　　To comment or ask technical questions about this book, send email to the following quoting the book's ISBN number (9780596807306): bookquestions@oreilly, com
　　For more information about our books, conferences, Resource Centers, and the O'Reilly Network, see our website at: http://www.oreilly.com
　　Safari Books Online
　　Safari Books Online is an on-demand digital library that lets you easily search over 7,500 technology and creative reference books and videos to find the answers you need quickly.
　　With a subscription, you can read any page and watch any video from our library online. Read books on your cell phone and mobile devices. Access new titles before they are available for print, and get exclusive access to manuscripts in development and post feedback for the authors. Copy and paste code samples, organize your favorites, download chapters, bookmark key sections, create notes, print out pages, and benefit from tons of other time-saving features.
　　O'Reilly Media has uploaded this book to the Safari Books Online service. To have full digital access to this book and others on similar topics from O'Reilly and other publishers, sign up for free at http://my.safaribooksonline, com.
　　Acknowledgments
　　The authors would like to thank our technical reviewers, Mark Callaghan, Luis Soares, and Morgan Tocker. Your attention to detail and insightful suggestions were invaluable. We could not have delivered a quality book without your help.
　　We also want to thank our extremely talented colleagues on the MySQL replication team, including Alfranio Correia, Andrei Elkin, Zhen-Xing He, Serge Kozlov, Sven Sandberg, Luis Soares, Rafal Somla, Li-Bing Song, Ingo Struwing, and Dao-Gang Qu for their tireless dedication to making MySQL replication the robust and powerful feature set it is today. We especially would like to thank our MySQL customer support professionals, who help us bridge the gap between our customers' needs and our own desires to improve the product. We would also like to thank the many community members who so selflessly devote time and effort to improve MySQL for everyone.
　　Finally, and most importantly, we would like to thank our editor, Andy Oram, who helped us shape this work, for putting up with our sometimes cerebral and sometimes over-the-top enthusiasm for all things MySQL.
　　Charles would like to thank his loving wife, Annette, for her patience and understanding when he was spending time away from family priorities to work on this book. You are the love of his life and his inspiration. Charles would also like to thank his many colleagues on the MySQL team at Oracle who contribute their wisdom freely to everyone on a daily basis. Finally, Charles would like to thank all of his brothers and sisters in Christ who both challenge and support him daily.
　　Mats would like to thank his wife, Lill, and two sons, Jon and Hannes, for their unconditional love and understanding in difficult times. You are the love of his life and he cannot imagine a life without you. Mats would also like to thank his MySQL colleagues inside and outside Sun/Oracle for all the interesting, amusing, and inspiring times together: you are truly some of the sharpest minds in the trade.
　　Lars would like to thank all his colleagues, current and past, who have made MySQL such an interesting place to work. In fact, it is not even a place. The distributed nature of the MySQL development team and the open-mindedness of its many dedicated developers are truly extraordinary. The MySQL community has a special spirit that makes working with MySQL an honorable task. What we have created together is remarkable. It is amazing that we started with such a small group of people and managed to build a product that services so many of the Fortune 500 companies today.