High Performance MySQL: Optimization, Backups, Replication, and More, 2nd Edition


keywords:databases and sql,databases sql,sql databases,security of databases,security databases,

High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include:
Emphasis throughout on both performance and reliability
Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine
Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views
A detailed discussion on how to build very large, highly scalable systems with MySQL
New options for backups and replication
Optimization of advanced querying features, such as full-text searches
Four new appendices

keywords:databases and sql,databases sql,sql databases,security of databases,security databases,

eBook Details:
Category: Databases
Author: Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Language: English
ISBN10: 0596101716
Pages: 712
PubDate: 2008-00-00 00:00:00
UploadDate: 5/8/2017 2:18:48 am

The Latest Upload

The Most Related