Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
High Availability MySQL Cookbook

Buy

High Availability is something that all web sites hope to achieve, especially those that are linked to big companies.

MySQL, an open source relational database management system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a MySQL setup is quite simple. Things start getting complex when you start thinking about the best way to provide redundancy. There are a large number of techniques available to add 'redundancy' and 'high availability' to MySQL, but most are both poorly understood and documented.

This book will provide you with recipes showing how to design, implement, and manage a MySQL Cluster and achieve high availability using MySQL replication, block level replication, shared storage, and the open source Global File System (GFS).

This book covers all the major techniques available for increasing availability of your MySQL databases. It demonstrates how to design, implement, troubleshoot and manage a highly available MySQL setup using any one of several techniques, which are shown in different recipes. It is based on MySQL Cluster 7.0, MySQL (for non clustered recipes) 5.0.77, and CentOS / RedHat Enterprise Linux 5.3.

The book starts by introducing MySQL Cluster as a technology and explaining how to set up a simple cluster. It will help you to master the options available for backing up and restoring a file in the MySQL Cluster. By following the practical examples in this book, you will learn how to manage the MySQL Cluster. Further, we will discuss some troubleshooting aspects of the MySQL Cluster.

We also have a look at achieving high availability for MySQL databases with the techniques of MySQL Replication, block level replication, shared storage (a SAN or NAS), and DRBD.

Finally, you will learn the principles of Performance tuning and tune MySQL database for optimal performance.

A cookbook containing recipes for all the common high availability techniques for database administrators to tackle real-world challenges to achieve high availability using MySQL

What you will learn from this book

  • Configure a MySQL Cluster for scaling out MySQL
  • Learn the technique of taking online backups and recovery
  • Achieve high availability with MySQL Replication and various tools such as the open source Multi-Master Replication Manager (MMM) and Flipper projects
  • Configure a MySQL replication design to replicate data from one MySQL database server to one or more other MySQL database servers
  • Master the safety tricks of replication to prevent replication failure
  • Configure a MySQL service to work using a shared storage device to achieve high availability, with and without a clustered filesystem
  • Learn to use the open source Global File System (GFS) to have the same file system on more than one node
  • Achieve high availability using block level replication with Distributed Replicated Block Device (DRBD)
  • Improve your system's performance with the technique of performance tuning

Approach

This book uses the approach of a cookbook. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. It is designed to present what often appear as extremely complicated techniques as a series of simple-to-follow recipes, allowing readers to achieve high uptimes on their MySQL servers.

Who this book is written for

This book is targeted at system administrators or database administrators who have basic familiarity with Linux, the shell, and MySQL. The typical user will be able to get MySQL installed and working, but needs practical guidance to make it highly available.

(HTML tags aren't allowed.)

Microsoft  Visual Basic  .NET Step by Step--Version 2003
Microsoft Visual Basic .NET Step by Step--Version 2003

Microsoft Visual Basic .NET Step by Step—Version 2003 is a comprehensive introduction to Visual Basic programming using the MicrosoftVisual Basic .NET 2003 software. I’ve designed this course with a variety of skill...

Antisense Drug Technology: Principles, Strategies, and Applications, Second Edition
Antisense Drug Technology: Principles, Strategies, and Applications, Second Edition

Extensively revised and updated, Antisense Drug Technology: Principles, Strategies, and Applications, Second Edition reflects the logarithmic progress made in the past four years of oligonucleotide-based therapies, and, in particular, antisense therapeutics and research. Interpreting lessons learned from the clinical trials of first...

Realitätstreue, Natürlichkeit, Plausibilität: Perzeptive Beurteilungen in der Elektroakustik (German Edition)
Realitätstreue, Natürlichkeit, Plausibilität: Perzeptive Beurteilungen in der Elektroakustik (German Edition)

Dieses Buch richtet sich an Ingenieure und Forscher im Bereich der Kommunikationsakustik und anderen Gebieten der Wahrnehmungsforschung. Es bewegt sich im interdisziplinären Feld von Kommunikationsakustik, Informationstheorie und Wahrnehmungspsychologie und liefert einen wesentlichen Beitrag zum Verständnis der akustischen...


Dr. Tom Shinder's ISA Server 2006 Migration Guide
Dr. Tom Shinder's ISA Server 2006 Migration Guide
Dr. Tom Shinders ISA Server 2006 Migration Guide provides a clear, concise, and thorough path to migrate from previous versions of ISA Server to ISA Server 2006. ISA Server 2006 is an incremental upgrade from ISA Server 2004, this book provides all of the tips and tricks to perform a successful migration, rather than rehash all of the features...
Personal Firewalls for Administrators and Remote Users
Personal Firewalls for Administrators and Remote Users

Personal firewalls explained—for remote corporate and home users.

In today's work environment, increasing numbers of mobile employees are using PCs, laptops, and handheld devices to connect to corporate servers. That's great for productivity, but it can also pose a security nightmare. Many of these...

The Measure of All Minds: Evaluating Natural and Artificial Intelligence
The Measure of All Minds: Evaluating Natural and Artificial Intelligence

Are psychometric tests valid for a new reality of artificial intelligence systems, technology-enhanced humans, and hybrids yet to come? Are the Turing Test, the ubiquitous CAPTCHAs, and the various animal cognition tests the best alternatives? In this fascinating and provocative book, José Hernández-Orallo formulates major...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy