High Performance MySQL: Optimization, Backups, and Replication

High Performance MySQL: Optimization, Backups, and Replication

Baron Schwartz

How are you able to deliver out MySQL’s complete strength? With High functionality MySQL, you’ll study complex innovations for every thing from designing schemas, indexes, and queries to tuning your MySQL server, working method, and to their fullest strength. This advisor additionally teaches you secure and functional how one can scale functions via replication, load balancing, excessive availability, and failover.

Updated to mirror fresh advances in MySQL and InnoDB functionality, positive factors, and instruments, this 3rd variation not just bargains particular examples of the way MySQL works, it additionally teaches you why the program works because it does, with illustrative tales and case experiences that exhibit MySQL’s ideas in motion. With this e-book, you’ll research how to think in MySQL.

  • Learn the consequences of recent positive factors in MySQL 5.5, together with kept tactics, partitioned databases, triggers, and views
  • Implement advancements in replication, excessive availability, and clustering
  • Achieve excessive functionality while working MySQL within the cloud
  • Optimize complex querying beneficial properties, resembling full-text searches
  • Take good thing about glossy multi-core CPUs and solid-state disks
  • Explore backup and restoration strategies—including new instruments for warm on-line backups

Show sample text content

Download sample