Jump to ratings and reviews
Rate this book

MySQL Database Usage & Administration

Rate this book
Take your MySQL skills to the top tierMaximize every powerful feature available in MySQL 5.1 with hands-on instruction from a MySQL expert. This definitive guide shows you how to use MySQL's advanced suite of data management tools, optimize performance and reliability, and secure and administer a robust RDBMS. MySQL Database Usage & Administration includes detailed code examples in each chapter to highlight real-world applications of the material covered. If you want to get the most out of MySQL, you need this practical handbook.

Understand MySQL's features, technical architecture, subsystems, and commandsMake database design decisions that optimizre performance, storage, and reliabilityWrite complex queries using joins, subqueries, and viewsGroup SQL statements into transactions and execute them atomicallyBuild and use sophisticated stored procedures and functionsAutomate database operations with triggers and scheduled eventsImport and export data in different formats, includiong SQL, CSV, and XMLOptimize server and query performanceAdminister a secure, high availability MySQL RDBMSManage users and control accessPerform database maintenance, replication, backup, and recoveryVikram Vaswani is the founder and CEO of Melonfire (www.melonfire.com), a consultancy firm with special expertise in open-source tools and technologies. His previous books include The Complete Reference, A Beginner's Guide, and PHP Programming Solutions.

370 pages, Kindle Edition

First published November 1, 2009

7 people want to read

About the author

Ratings & Reviews

What do you think?
Rate this book

Friends & Following

Create a free account to discover what your friends think of this book!

Community Reviews

5 stars
5 (45%)
4 stars
1 (9%)
3 stars
5 (45%)
2 stars
0 (0%)
1 star
0 (0%)
No one has reviewed this book yet.

Can't find what you're looking for?

Get help and learn more about the design.