Book123

    Free register and download UseNet downloader, then you can FREE Download from UseNet.

    Download without Limit " Programming High Availability MySQL Cookbook (Repost) " from UseNet for FREE!

More

High Availability MySQL Cookbook By Alex Davies

Over 60 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL database

Analyze and learn different high availability options, including clustering and replication solutions within MySQL

Improve uptime of your MySQL databases with simple recipes showing powerful high availability techniques for MySQL

Tune your MySQL database for optimal performance.

The only complete, practical, book of MySQL high availability techniques and tools on the market

Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

In Detail

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

About the Author

Alex Davies has a wealth of experience working with MySQL, becoming a founding member of the MySQL Guilds before the age of 18. Author of the first book on MySQL Clustering, published in 2006, Alex has significant experience working on MySQL servers, often working on scalability and high availability problems.

Buy Book at Lowest Price on Amazon

Rating:
2.5 out of 5 by Book123