home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral Introduction to HW & SW Soft skills TracksOperating systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad and iPhone iOSDatabases and middleware Relational databases & SQL DB2 for z/OS DB2 for LUW Oracle SQL Server MySQL & MariaDB IMS CICS IBM MQ WebSphere Big data and analyticsApplication development Methods and techniques TOGAF PRINCE2 Agile development and Scrum Programming languages Internet development Object Oriented systems Java Development tools SAS XML SOA & web servicesSystems management ITIL SecuritybalkjePractical informationRegistration 
MySQL & MariaDB database administration

Objectives

The database administrator (DBA) plays an important role in the data management process. The DBA is the planner and the producer during the design, the implementation and the maintenance of physical database structures. The DBA is the prime responsible for a well performing system.

At the end of this course, the participant will:

  • have a good idea of the different tasks of a DBA in the context of a MySQL or MariaDB database server;
  • have a thorough technical insight into the physical and logical characteristics of a MySQL or MariaDB server;
  • be able to use the "client" administration tools: command line interfaces, standard graphical interfaces;
  • be ready to execute scenarios for the management, monitoring and support of server tasks like security management, backup & recovery, replication, and performance analysis.

Main topics

  • PART 1: Database Implementation
  • Overview of the versatile tasks of a DBA.
  • Physical design and implementation of MySQL/MariaDB objects:
  • Object definition: decision rules
  • Possibilities for the implementation of a logical design: datatypes, primary/foreign keys, indexes, triggers, auto-incremented columns, LOBs, views, storage engines, partitioning, ...
  • storage considerations: files, directories, disks
  • implementing a test environment & preparing for production: standard DDL (create/alter/drop), but also extensions and deviations to the SQL standard which are particular to MySQL or MariaDB
  • prepare the database for performance analysis
  • Access control to MySQL & MariaDB objects:
  • defining users; managing passwords;
  • scenarios for efficient security management and auditing requirements
  • the MySQL/MariaDB data dictionary
  • the "mysql" database
  • the object catalog: the INFORMATION_SCHEMA database
  • displaying system information and metadata
  • PART 2: Database maintenance, integrity control, performance optimization
  • Maintenance considerations:
  • shutting down and restarting the server
  • configuring data caching and query caching
  • benchmarking, profiling, capacity planning
  • Utilities: export/import of external data; defragmentation; check and repair
  • (re)partitioning of tables; moving data to other disks; changing the engine
  • use of data compression
  • hardware-tuning of the MySQL/MariaDB server
  • scaling and high availability architectures
  • query analysis and index tuning
  • Data integrity, locking and transactions
  • PART 3: Database recovery
  • Logging and replication
  • Backup and recovery techniques:
  • copying databases to an other machine
  • point-in-time recovery and disaster recovery: best practices
 

Intended for

New database administrators, application DBA's, and other users of MySQL or MariaDB responsible for (part of) the tasks of a DBA.

Background

Some practical experience with MySQL or MariaDB as a relational database system and with SQL (see MySQL & MariaDB fundamentals course and SQL workshop).

Although MySQL and MariaDB are often used in the context of a web service, for this course knowledge of PHP or an other programming language is not necessary.

Training method

Theory (classroom instruction) with labs and ample room for practice.

Course leader

Peter Vanroose.

Duration

4 days.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.