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.
 |
 |
 |
| Buy Now | Buy Now | Buy Now |
Replication Techniques in depth
June 15, 2012
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
- The Five Minute DBA
- Diagnosing Common Replication Problems
- Improving Standard Replication Features
- Understanding Multi-Master Replication
- MySQL Replication Tools
- Extending Replication for Practical Needs
- MySQL Configuration Options
- 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
September 30, 2011
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
- The Five Minute DBA – Download Sample Chapter (PDF)
- Understanding Backup Options
- Understanding Business Requirements
- Using Replication
- Understanding Recovery Options
- MySQL Configuration Options
- Disaster Scenarios
- Optimizing Backup & Recovery
- 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
Other Titles
See other titles in our series including:
Related Presentations
You may also like these related presentations:
Optimizing SQL Statements
September 29, 2011
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
- The Five Minute DBA – Code Examples – Download Sample Chapter (PDF)
- The Essential Analysis Commands – Code Examples
- Understanding MySQL Indexes – Code Examples
- Creating Indexes – Code Examples
- Creating Better Indexes – Code Examples
- MySQL Configuration Options – Code Examples
- The SQL Lifecycle – Code Examples
- Hidden Performance Tips – Code Examples
- 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:
Expert PHP and MySQL
January 5, 2011
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
- Techniques Every Expert Programmer Needs to Know
- Advanced PHP Constructs
- MySQL Drivers and Storage Engines
- Improved Performance through Caching
- Memcached MySQL
- Advanced MySQL
- Extending MySQL with User-defined Functions
- Writing PHP Extensions
- Full Text Search using SPHINX
- Multi-tasking in PHP and MySQL
- Rewrite Rules
- User Authentication with PHP and MySQL
- Understanding the INFORMATION_SCHEMA
- Security
- Service and Command Lines
- Optimization and Debugging
MySQL High Availability
January 5, 2011
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
- Introduction
- MySQL Replication Fundamentals
- The Binary Log
- Replication for High Availability
- MySQL Replication for Scale-Out
- Advanced Replication
- Getting Started with Monitoring
- Monitoring MySQL
- Storage Engine Monitoring
- Replication Monitoring
- Replication Troubleshooting
- Protecting Your Investment
- MySQL Enterprise
- Cloud Computing Solutions
- MySQL Cluster
High Performance MySQL
January 5, 2011
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
- MySQL Architecture
- Finding Bottlenecks: Benchmarking and Profiling
- Schema Optimization and Indexing
- Query Performance Optimization
- Advanced MySQL Features
- Optimizing Server Settings
- Operating System and Hardware Optimization
- Replication
- Scaling and High Availability
- Application-Level Optimization
- Backup and Recovery
- Security
- MySQL Server Status
- Tools for High Performance
