Używamy cookies, aby ułatwić korzystanie z Portalu. Możesz określić warunki przechowywania, dostępu do plików cookies w Twojej przeglądarce. Dowiedz się więcej.
strona główna Strona główna | Nowości | Promocje | Zapowiedzi Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc
mapa działów
Szukaj: szukanie zaawansowane
Książki \ Bazy danych \ MySQL

MySQL High Availability Język: 2


Cena Brutto: 200.66

Cena netto: 191.10

Wersja: Drukowana
Autor Lars Thalmann
Liczba_stron 624
Wydawnictwo OReilly Media
Data_Wydania 2010-06-28
Poziom All Levels

Informacje podstawowe:

  • Wydawnictwo: O'Reilly Media
  • Data wydania: 28 czerwca 2010
  • Liczba stron: 624
  • Autor/autorzy:
    • Charles Bell
    • Mats Kindahl
    • Lars Thalmann


Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it's running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to use these replication, cluster, and monitoring features in a wide range of real-life situations.

Written by engineers who designed many of the tools covered inside, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability - knowledge that’s essential for any organization using this database system.

  • Explore the binary log, a file for replication that helps in disaster recovery and troubleshooting
  • Get techniques for improving response time and handling large data sets
  • Monitor database activity and performance, as well as major operating system parameters
  • Keep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidents
  • Automate key tasks with code from an open source library written by the authors
  • Learn techniques for using MySQL in virtualized environments, such as Amazon Web Services
  • Use MySQL Cluster to achieve high availability

"MySQL replication is widely deployed but has never been adequately explained. This book changes that."- Mark Callaghan, MySQL contributor and leader of MySQL engineering efforts at a few of the world's largest Internet companies

O autorze/autorach:

Charles Bell

Dr. Charles A Bell is a Senior Software Engineer at Oracle. He iscurrently the lead developer for backup and a member of the MySQLBackup and Replication team. He lives in a small town in ruralVirginia with his loving wife. He received his Doctor of Philosophy inEngineering from Virginia Commonwealth University in 2005.Hisresearch interests include database systems, versioning systems,semantic web, and agile software development.

View Charles Bell's full profile page.

Mats Kindahl

Dr. Mats Kindahl is a senior software developer working on the MySQLserver.He is the main architect and implementor of MySQL's row-basedreplication and is responsible for strategic development ofreplication, reengineering, and the plugin architecture. Beforestarting at MySQL, he did research in formal methods, programanalysis, and distributed systems, the area where he earned hisdoctoral degree in computer science. He has also spent many yearsdeveloping C/C++ compilers and knows more programming languages thanhe has fingers.

View Mats Kindahl's full profile page.

Lars Thalmann

Dr. Lars Thalmann is the development manager for MySQL replication andbackup. He is responsible for the strategy and development of thesefeatures and leads the corresponding engineering teams. Thalmann hasworked with MySQL development since 2001, when he was a softwaredeveloper working on MySQL Cluster. More recently, he has driven thecreation and development of the MySQL backup feature, has guided theevolution of MySQL replication since 2004, and has been a key playerin the development of MySQL Cluster replication. Thalmann holds adoctorate in Computer Science from Uppsala University, Sweden.

View Lars Thalmann's full profile page.

Zawartość (spis treści):

  1. Replication

    1. Chapter 1 Introduction
      1. What’s This Replication Stuff Anyway?
      2. So, Backups Are Not Needed Then?
      3. What’s with All the Monitoring?
      4. Is There Anything Else I Can Read?
      5. Conclusion
    2. Chapter 2 MySQL Replication Fundamentals
      1. Basic Steps in Replication
      2. A Brief Introduction to the Binary Log
      3. Performing Common Tasks with Replication
      4. Conclusion
    3. Chapter 3 The Binary Log
      1. Structure of the Binary Log
      2. Logging Statements
      3. Logging Transactions
      4. Binary Log Management
      5. The mysqlbinlog Utility
      6. Binary Log Options and Variables
      7. Conclusion
    4. Chapter 4 Replication for High Availability
      1. Redundancy
      2. Planning
      3. Procedures
      4. Conclusion
    5. Chapter 5 MySQL Replication for Scale-Out
      1. Scaling Out Reads, Not Writes
      2. The Value of Asynchronous Replication
      3. Managing the Replication Topology
      4. Hierarchal Replication
      5. Specialized Slaves
      6. Data Sharding
      7. Managing Consistency of Data
      8. Consistency in a Hierarchal Deployment
      9. Conclusion
    6. Chapter 6 Advanced Replication
      1. Replication Architecture Basics
      2. Running Replication over the Internet
      3. Finer-Grained Control over Replication
      4. Options for Handling Broken Connections
      5. How the Slave Processes Events
      6. Slave Safety and Recovery
      7. Multisource Replication
      8. Row-Based Replication
      9. Conclusion
  2. Monitoring and Disaster Recovery

    1. Chapter 7 Getting Started with Monitoring
      1. Ways of Monitoring
      2. Benefits of Monitoring
      3. System Components to Monitor
      4. Monitoring Solutions
      5. Linux and Unix Monitoring
      6. Mac OS X Monitoring
      7. Microsoft Windows Monitoring
      8. Monitoring as Preventive Maintenance
      9. Conclusion
    2. ChapterMonitoring MySQL
      1. What Is Performance?
      2. MySQL Server Monitoring
      3. Database Performance
      4. Best Practices for Improving Performance
      5. Conclusion
    3. Chapter 9 Storage Engine Monitoring
      1. MyISAM
      2. InnoDB
      3. Conclusion
    4. ChapterReplication Monitoring
      1. Getting Started
      2. Server Setup
      3. Inclusive and Exclusive Replication
      4. Replication Threads
      5. Monitoring the Master
      6. Monitoring Slaves
      7. Replication Monitoring with MySQL Administrator
      8. Other Items to Consider
      9. Conclusion
    5. Chapter 11 Replication Troubleshooting
      1. What Can Go Wrong
      2. Tools for Troubleshooting Replication
      3. Best Practices
      4. Reporting Replication Bugs
      5. Conclusion
    6. Chapter 12 Protecting Your Investment
      1. What Is Information Assurance?
      2. Information Integrity, Disaster Recovery, and the Role of Backups
      3. Backup Utilities and OS-Level Solutions
      4. Backup and MySQL Replication
      5. Automating Backups
      6. Conclusion
    7. Chapter 13 MySQL Enterprise
      1. Getting Started with MySQL Enterprise
      2. MySQL Enterprise Components
      3. Using MySQL Enterprise
      4. Conclusion
  3. High Availability Environments

    1. Chapter 14 Cloud Computing Solutions
      1. What Is Cloud Computing?
      2. Cloud Computing Use Cases
      3. Cloud Computing Benefits
      4. Cloud Computing Vendors
      5. AWS
      6. MySQL in the Cloud
      7. Open Source Cloud Computing
      8. Conclusion
    2. Chapter 15 MySQL Cluster
      1. What Is MySQL Cluster?
      2. Architecture of MySQL Cluster
      3. Example Configuration
      4. Achieving High Availability
      5. Achieving High Performance
      6. Conclusion
  1. Appendix: Replication Tips and Tricks

    1. My Slave Stopped. Now What?
    2. Examining the Binary Log with Verbose
    3. Using Replication to Repopulate a Table
    4. Using MySQL Proxy to Perform Multimaster Replication
    5. Using a Default Storage Engine
    6. MySQL Cluster Multisource Replication
    7. Multichannel Replication with Failover
    8. Using the Current Database to Filter
    9. More Columns on Slave Than Master
    10. Fewer Columns on Slave Than Master
    11. Replicate Selected Rows to Slave
    12. Replication Heartbeat
    13. Ignoring Servers in Circular Replication
    14. Feature Preview: Time-Delayed Replication
    15. Feature Preview: Scriptable Replication
    16. Feature Preview: The Oracle Algorithm
  2. Colophon

Produkty Podobne
PHP, MySQL i JavaScript. Wprowadzenie. Wydanie V
PHP i MySQL. Dynamiczne strony WWW. Szybki start. Wydanie V
PHP i MySQL. Tworzenie stron WWW. Vademecum profesjonalisty. Wydanie V
PHP i MySQL. Dla każdego. Wydanie III
PHP and MySQL Web Development, 5th Edition
The Language of SQL, 2nd Edition
Getting Started with SQL
PHP, MySQL i JavaScript. Wprowadzenie. Wydanie IV
Learning MySQL and MariaDB
Learning PHP, MySQL & JavaScript, 4th Edition
Więcej produktów