Description

This internship will allow you to master all the administration tasks of a MariaDB 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

Learn about the MariaDB SGDB

Be able to install and configure MariaDB

Understand how to manage security

Be able to maintain the MariaDB server

Learn how to manage backups and restores

Training program

• Introduction et installation de MariaDB
  • Versions and license types.
  • MariaDB tools (client and administration).
  • Server configuration: configuration files and parameters.
  • Startup/stop.
  • Installations (binary, from sources).
  • Practical work Installation of MariaDB under Linux/Windows and use of client and software tools 'administration.
• Objects of a MariaDB database
  • Table types (MyISAM/Aria, XtraDB/InnoDB, FederatedX, Cassandra, SphinxSE, HandlerSocket.
  • ).
  • Changing the definition of a table.
  • Index and view management.
  • Base information_schema and performance_schema.
  • Practical work Creation and use of views.
  • Creation, modification of the definition of a table.
  • Creation of indexes.
  • Use of catalog databases.
• Connections, access rights, security
  • User authentication.
  • MariaDB system databases and their contents.
  • Management of users and their privileges.
  • Rights on stored views and processing.
  • Using SSL.
  • Practical work Complete post-installation security.
  • Creating MariaDB accounts .
  • Security management under MariaDB.
• Storage engines and plug-ins
  • Engines: MyISAM/Aria, XtraDB/InnoDB, Memory, Archive CSV, FederatedX, Blackhole, CassandraSE, SphinxSE, HandlerSocket.
  • Transactional operation of the XtraDB/InnoDB engine.
  • Table locking.
  • MyISAM/Aria query cache and index cache.
  • Practical work Changing the XtraDB/InnoDB settings.
  • Implementing transactions.
• Maintaining a MariaDB 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.
  • Backup methods and available tools.
  • Backup and incremental recovery.
  • Statistics update and defragmentation.
  • Practical work Activation of logs.
  • Tools loading/unloading.
  • Backups and restores with "mysqldump".
  • Using the binary log.
  • Incremental backup.
  • Incremental recovery.