Pro MySQL

Pro MySQL provides intermediate and advanced MySQL users with a comprehensive guide to the array of features available to these new versions. Clustering, replication, transactions, and subqueries are just a few of the topics you'll find in this book.

One of the first books to cover MySQL 5 in depth Foregos reiteration of the basics found in other books, and concentrates on MySQL's advanced applications in enterprise environments Doubles as a reference for users interested in having a thorough guide to configuration directives, commands, and features at their disposal

Autorentext
Jay Pipes is the North American community relations manager at MySQL. Coauthor of Pro MySQL (Apress, 2005), Jay has also written articles for Linux Magazine and regularly assists software developers in identifying how to make the most effective use of MySQL. He has given sessions on performance tuning at the MySQL Users Conference, RedHat Summit, NY PHP Conference, OSCON, and Ohio LinuxFest, among others. He lives in Columbus, Ohio, with his wife, Julie, and his four animals. In his abundant free time, when not being pestered by his two needy cats and two noisy dogs, he daydreams in PHP code and ponders the ramifications of __clone().

Klappentext

• One of the first books to cover MySQL 5 in depth

  • Foregos reiteration of the basics found in other books, and concentrates on MySQL's advanced applications in enterprise environments

  • Doubles as a reference for users interested in having a thorough guide to configuration directives, commands, and features at their disposal

  Inhalt
  Design and Development.- Analyzing Business Requirements.- Index Concepts.- Transaction Processing.- MySQL System Architecture.- Storage Engines and Data Types.- Benchmarking and Profiling.- Essential SQL.- SQL Scenarios.- Stored Procedures.- Functions.- Cursors.- Views.- Triggers.- Administration.- MySQL Installation and Configuration.- User Administration.- Security.- Backup and Restoration.- Replication.- Cluster.- Troubleshooting.- MySQL Data Dictionary.