The third book of the Effective MySQL series provides the reader with the tools, knowledge and tips for managing a scalable MySQL Replication environment.

Chapters

1. The Five Minute DBA
2. Diagnosing Common Replication Problems
3. Improving Standard Replication Features
4. Understanding Multi-Master Replication
5. MySQL Replication Tools
6. Extending Replication for Practical Needs
7. MySQL Configuration Options
8. Monitoring Replication

Order Now

This title will be available print, and ebook formats from these retailers. You can pre-order now.

Other Titles

See other titles in our series including:

• Effective MySQL:Optimizing SQL Statements
• Effective MySQL: Backup and Recovery

Related Presentations

You may also like these related presentations:

The second book of the Effective MySQL series provides the reader with the tools, knowledge and tips necessary for a successful MySQL Backup and Recovery Schedule. Included in this book are examples of mysqldump, LVM snapshots, mylvmbackup, MySQL Enterprise Backup (MEB), Xtrabackup and mydumper. Advanced options including compression, incremental backups, partial backups and remote capabilities are discussed and examples provided with an example 5GB database.

Chapters

1. The Five Minute DBA – Download Sample Chapter (PDF)
2. Understanding Backup Options
3. Understanding Business Requirements
4. Using Replication
5. Understanding Recovery Options
6. MySQL Configuration Options
7. Disaster Scenarios
8. Optimizing Backup & Recovery
9. MySQL in the Cloud

All links in the book can be referenced in links.txt

Order Now

This title is available print, and ebook formats.
Kindle Version from Amazon & PDF version from McGraw-Hill.

Related Articles

• What compression do you use?
• Encrypting your MySQL Backups and more

Other Titles

See other titles in our series including:

• Effective MySQL:Optimizing SQL Statements
• Effective MySQL: Replication Techniques In Depth

Related Presentations

You may also like these related presentations:

• MySQL Backup & Recovery Essentials
• MySQL Disasters, and how to avoid yours.

The first book of the Effective MySQL series provides the reader with the tools, knowledge and tips necessary for optimizing SQL Statements in MySQL.

Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements.

• Identify the essential analysis commands for gathering and diagnosing issues
• Learn how different index theories are applied and represented in MySQL
• Plan and execute informed SQL optimizations
• Create MySQL indexes to improve query performance
• much more…

Chapters

1. The Five Minute DBA – Code Examples – Download Sample Chapter (PDF)
2. The Essential Analysis Commands – Code Examples
3. Understanding MySQL Indexes – Code Examples
4. Creating Indexes – Code Examples
5. Creating Better Indexes – Code Examples
6. MySQL Configuration Options – Code Examples
7. The SQL Lifecycle – Code Examples
8. Hidden Performance Tips – Code Examples
9. Explaining the MySQL Explain – Code Examples

Buy Now

This title is available in print, and ebook formats from these retailers.

Get the Code

In addition to the individual chapter links provided above you can download all SQL examples via github with the following command.

$ git clone git://github.com/effectiveMySQL/OptimizingSQLStatements.git

Other Titles

See other titles in our series including:

• Effective MySQL: Backup and Recovery
• Effective MySQL: Advanced Replication Techniques

Related Presentations

You may also like these related presentations:

• Improving Performance and Better Indexes
• Explaining the MySQL Explain

Official Site

This Wrox publication released in March 2010 covers detailed topics related with PHP and MySQL and supporting developer technologies, tools and techniques.

Book Authors

• Andrew Curioso – Software Engineer – andrewcurioso.com
• Ronald Bradford – MySQL Expert – ronaldbradford.com
• Patrick Galbraith – Senior Software Developer – patg.net

Table of Contents

1. Techniques Every Expert Programmer Needs to Know
2. Advanced PHP Constructs
3. MySQL Drivers and Storage Engines
4. Improved Performance through Caching
5. Memcached MySQL
6. Advanced MySQL
7. Extending MySQL with User-defined Functions
8. Writing PHP Extensions
9. Full Text Search using SPHINX
10. Multi-tasking in PHP and MySQL
11. Rewrite Rules
12. User Authentication with PHP and MySQL
13. Understanding the INFORMATION_SCHEMA
14. Security
15. Service and Command Lines
16. Optimization and Debugging

MySQL High Availability – Tools for Building Robust Data Centers is an O’Reilly book released in 2010.

Book Authors

• Charles Bell
• Mats Kindahl
• Lars Thalmann

Table of Contents

1. Introduction
2. MySQL Replication Fundamentals
3. The Binary Log
4. Replication for High Availability
5. MySQL Replication for Scale-Out
6. Advanced Replication
7. Getting Started with Monitoring
8. Monitoring MySQL
9. Storage Engine Monitoring
10. Replication Monitoring
11. Replication Troubleshooting
12. Protecting Your Investment
13. MySQL Enterprise
14. Cloud Computing Solutions
15. MySQL Cluster

This O’Reilly publication is one of the more popular titles for MySQL resources.

The original version was written by Jeremy Zawodny and Derek Balling in 2004. The current second edition is a greatly enhanced version written by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko from Percona.

Table of Contents

1. MySQL Architecture
2. Finding Bottlenecks: Benchmarking and Profiling
3. Schema Optimization and Indexing
4. Query Performance Optimization
5. Advanced MySQL Features
6. Optimizing Server Settings
7. Operating System and Hardware Optimization
8. Replication
9. Scaling and High Availability
10. Application-Level Optimization
11. Backup and Recovery
12. Security
13. MySQL Server Status
14. Tools for High Performance