Saturday, May 19, 2012

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. 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

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:

Related Presentations

You may also like these related presentations:

Filed Under: Book

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

Related Presentations

You may also like these related presentations:

Filed Under: Book

Expert PHP and MySQL

January 5, 2011
Expert PHP and MySQL cover
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

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
Filed Under: Book

MySQL High Availability

January 5, 2011
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
Filed Under: Book

High Performance MySQL

January 5, 2011
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
Filed Under: Book