For any system, it is must to manage data in an organized manner. In a large-
scale system, it is necessary to handle various configurations for security
purposes. MySQL
is one of the popular solutions used to handle enterprise-level applications. In
this book, we will explain how to configure users, their roles, multiple instances,
and much more.
Many organizations use MySQL for their websites or commercial products, and
it's very challenging for them to manage data storage and analyze data in
accordance with the business requirements. This book will show you how to
implement indexing and query optimization for better performance. Along with
this, we'll cover how scalability and high availability of the MySQL server can
help to manage failure scenarios. In addition to that, replication and partitioning
concepts are explained in detail with examples.
The book describes various features of MySQL 8 by targeting different levels of
users, from beginners to database administrators. This book starts from the
installation with a basic understanding of MySQL 8's concepts. The we proceed
to administrative-level features with configuration. At the end of the book, you
will have learned about very interesting functionalities, such as optimization,
extension, and troubleshooting.