Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency

© Y V Ravi Kumar, Arun Kumar Samayam, Naresh Kumar Miryala 2024

Y. V. Ravi Kumar et al.Mastering MySQL Administrationhttps://doi.org/10.1007/979-8-8688-0252-2_3

3. MySQL Server Administration

Y V Ravi Kumar¹  , Arun Kumar Samayam² and Naresh Kumar Miryala³

(1)

Irving, TX, USA

(2)

Dallas, TX, USA

(3)

Tracy, CA, USA

 

Introduction

MySQL requires administrative knowledge and function to manage the database. In this chapter, we will discuss how to manage the MySQL database server.

This chapter overviews the MySQL server and covers general server administration functions like server configuration, data dictionary, server logs, connection management, components, plug-ins, loadable functions, storage engines, and running multiple MySQL instances on one host.

The ...