Studying MySQL

The book introduces MySQL — the most popular open-source database management system. It covers the basics of MySQL: installation, modeling and constructing databases, SQL commands, and creating a new database. Practical issues related to working with MySQL are considered: advanced queries, transactions and locking mechanisms, query efficiency checking, user and privilege management, using option files, backup and recovery, server configuration and setup. Special attention is paid to monitoring MySQL servers, asynchronous and synchronous replication, clustering solutions, cloud operations, load balancing, and other advanced methods and tools.