My SQL System BDD

My SQL   System BDD

My SQL   System BDD

This MySQL 5 support is for MySQL developers and administrators who want to consolidate their knowledge of the most popular Open Source DBMS on the market.

The book begins with a presentation of the basics you will need to make the most of MySQL's capabilities: single and multi-instance installation methods, overview of the server architecture and main storage engines, best practices for configuration .

After these fundamentals giving you a good understanding of the specificities of the DBMS, you will learn how to manage your server on a daily basis, keeping in mind the essential principles of security, by putting in place effective strategies for backups and restorations and maintaining your up-to-date and operational tables.

My SQL   System BDD

Download links:

The last part is devoted to advanced techniques that will give you the keys to solve the most complex problems: optimizing the server, indexes and queries, improving performance with partitioning or setting up a replication solution adapted to your application.
Additional elements can be downloaded from www.editions-eni.com.
The chapters of the book:
Foreword - Server installation - Architecture - Server configuration - Locks and transactions - Security and user management - Backup and restore - Maintenance of tables - Optimization - Partitioning - Stored routines, triggers and events - Replication - Monitoring tools.