Saturday, July 26, 2014

Our Effective MySQL Books

At Effective MySQL we provide resources for the DBA, Developer and Architect to best use MySQL. This includes currently three books in our series, available in print, PDF and Kindle formats.

Effective MySQL: Optimizing SQL Statements by Ronald Bradford Effective MySQL: Backup and Recovery by Ronald Bradford Effective MySQL: Replication Techniques in Depth by Ronald Bradford and Chris Schneider
Buy Now Buy Now Buy Now

Replication Techniques in depth

The third book of the Effective MySQL series provides the reader with the tools, knowledge and tips for managing a scalable MySQL Replication environment. Effective MySQL: Replication Techniques in Depth by Ronald Bradford and Chris Schneider

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 is available in print, PDF and Kindle formats from these retailers.



Other Titles

See other titles in our series including:

Related Presentations

You may also like these related presentations:

Backup and Recovery

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. Effective MySQL: Optimizing SQL Statements by Ronald Bradford

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

You can find scripts and SQL used in the book at GitHub.
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

Other Titles

See other titles in our series including:

Related Presentations

You may also like these related presentations:

Optimizing SQL Statements

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

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 ExamplesDownload 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:

Related Presentations

You may also like these related presentations:

Expert PHP and MySQL

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

Book Authors

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

MySQL High Availability cover

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

High Performance MySQL

High Performance MySQL cover

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