High Performance MySQL

Fülszöveg

Databases O'REILLY® High Performance MySQL: Optimization, Backups, Replication & Load Balancing As users come to depend on MySQL, they find they have to deal with issues of reliability, scalability, and performance-issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these littleunderstood topics. Author Jeremy D. Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo! He has alsó maintained years of contacts with the MySQL AB team and presents regularly at conferences. Jeremy and his coauthor Derek J. Balling have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing their own tools in order to produce the information in this book. In High Performance MySQL, you will leam about MySQL indexing and optimization in depth so that you can better use these key features. You will alsó leam practical replication, backup, and... Tovább

Fülszöveg

Databases O'REILLY® High Performance MySQL: Optimization, Backups, Replication & Load Balancing As users come to depend on MySQL, they find they have to deal with issues of reliability, scalability, and performance-issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these littleunderstood topics. Author Jeremy D. Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo! He has alsó maintained years of contacts with the MySQL AB team and presents regularly at conferences. Jeremy and his coauthor Derek J. Balling have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing their own tools in order to produce the information in this book. In High Performance MySQL, you will leam about MySQL indexing and optimization in depth so that you can better use these key features. You will alsó leam practical replication, backup, and load-balancing strategies, where this book illustrates the available tools in detail as well as discussing issues of their use in real-life environments. Finally, you'll leam the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs. Topics covered in this book inciude: • A review of configuration and setup options • Storage engines and table types • Benchmarking • Indexes • Query optimization • Application design • Server performance • Replication • Load balancing • Backup and recovery • Security Vissza