نبذة عن الكتاب:

تعتبر الاختناقات والفشل في الخادم حقيقة واقعة في أي عملية نشر لقاعدة البيانات ، لكن لا يتعين عليهم إيقاف كل شيء. يحتوي MySQL على العديد من الميزات التي يمكن أن تساعدك على حماية نظامك من الانقطاعات ، سواء كان يعمل على الأجهزة أو الأجهزة الافتراضية أو في السحابة. يشرح MySQL High Availability كيفية استخدام ميزات النسخ والتجميع والمراقبة هذه في مجموعة واسعة من مواقف الحياة الواقعية.

هذا الكتاب الذي كتبه مهندسون صمموا العديد من الأدوات التي تم تناولها بالداخل ، يكشف عن جوانب غير موثقة أو يصعب العثور عليها لموثوقية MySQL والتوافر العالي - المعرفة الضرورية لأي مؤسسة تستخدم نظام قاعدة البيانات هذا.

استكشف السجل الثنائي ، وهو ملف للنسخ المتماثل يساعد في التعافي من الكوارث واستكشاف الأخطاء وإصلاحها
احصل على تقنيات لتحسين وقت الاستجابة والتعامل مع مجموعات البيانات الكبيرة
راقب نشاط قاعدة البيانات وأدائها ، بالإضافة إلى معلمات نظام التشغيل الرئيسية
تتبع ما يفعله الأسياد والعبيد ، وتعامل مع حالات الفشل وإعادة التشغيل والفساد والحوادث الأخرى
أتمتة المهام الرئيسية برمز من مكتبة مفتوحة المصدر كتبها المؤلفون
تعرف على تقنيات استخدام MySQL في البيئات الافتراضية ، مثل Amazon Web Services
استخدم MySQL Cluster لتحقيق الإتاحة العالية

"تم نشر نسخ MySQL على نطاق واسع ولكن لم يتم شرحه بشكل كافٍ. هذا الكتاب يغير ذلك." - مارك كالاهان ، مساهم MySQL وقائد جهود هندسة MySQL في عدد قليل من أكبر شركات الإنترنت في العالم

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

About the Author

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.

Dr. Mats Kindahl is principal senior software developer in the MySQL team at Oracle. He is the main architect and implementor of MySQL’s row-based replication and several other replication features and is currently architect and project lead for the MySQL High-Availability team that develop MySQL Fabric. Before starting at MySQL, he did research in formal methods, program analysis, and distributed systems, the area where he earned his doctoral degree in computer science. He has also spent several years developing C/C++ compilers.

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.