Description

This internship will allow you to master all the administration tasks of a MySQL database server. You will see how to install the server, configure it, perform backups/restores and manage production.

Who is this training for ?

For whom ?

System administrators and database administrators.

Prerequisites

Training objectives

Break down the architecture of the MySQL database

Install the MySQL DBMS

Determine the main functionalities of administering a MySQL database

Create and manage a database

Manage user access

Manage the security of the database database.

Training program

• Introduction et installation
  • Versions and license types.
  • Tools mysql, mysqlshow, myphpadmin.
  • Server settings (my.
  • cnf, sql_mode, strict mode.
  • ).
  • Startup/stop.
  • Installations (binary, from sources.
  • ).
  • Mysqladmin.
  • Installation of MySQL Workbench.
  • Version changes, migration.
  • Practical work Installation under Linux/ Windows.
  • Installing MySQL Workbench.
• Objects of a MySQL database
  • Table types (MyISAM, MEMORY, MERGE.
  • ).
  • Modifying the definition of a table.
  • Index.
  • View management.
  • Base information_schema.
  • Practical work Creation and use of views.
  • Modification of the definition of a table.
• Connections, access rights, security
  • User authentication.
  • Structure of the "mysql" database tables.
  • Management of users and their privileges.
  • Rights on stored views and processing.
  • Use of SSL.
  • Practical work Complete security of post-installation.
  • Creation of MySQL accounts.
  • Privilege management and passwords.
• Storage engines and plug-ins
  • MyISAM, InnoDB storage engines.
  • InnoDB architecture and configuration.
  • Transactional operation of the InnoDB engine.
  • Table locking.
  • Plug-ins: configuration and startup.
  • Practical work Changing InnoDB settings.
  • Implementing transactions.
• Maintaining a MySQL server
  • Session status (variables, "show status" command), forced termination of a session.
  • Loading: LOAD DATA, myimport, SELECT INTO OUTFILE, mysqldump.
  • Logs (general, errors, slow queries.
  • ).
  • Backup strategies.
  • InnoDB Hot Backup, mysqlbinlog.
  • Backup and incremental recovery.
  • Planning.
  • Practical work Activation of logs.
  • Using the loading/unloading tools.
  • Backup and restore with "mysqldump".
  • Using the binary log.
  • Incremental backup and recovery.