MySQL Administration
MySQL Administration is the practice of running a MySQL database server day to day: installing and configuring it, managing accounts and privileges, securing connections, logging and monitoring activity, backing up and recovering data, and keeping replicas in sync. It's the operational counterpart to writing SQL — the work of keeping the database available, correct, and recoverable.
itDatabases and data storage | OpenSkills.info
Intro
MySQL Administration
MySQL is a relational database management system: software that stores data in tables and lets you add, access, and process it through SQL, the Structured Query Language. Administering MySQL is different work from writing queries against it. Administration is keeping the server itself installed correctly, configured sensibly, secured, monitored, backed up, and current — so the queries have something reliable to run against.
MySQL ships as open source software distributed and supported by Oracle. That matters operationally: you get a free Community Edition with an active upstream, a paid Enterprise Edition with extra security and management features, and a documented release process you can plan upgrades around.
The layers you administer
Every MySQL administration task touches one of a small number of layers. Knowing which layer owns a piece of state tells you where to look and where to make a change.
The server and its configuration
Continue the course
This section is part of the paid course.
See pricing to subscribe, or log in if you already have access.
Where this skill leads
Relevant careers
See how this topic contributes to broader role-level skill maps.