Duration
3 days
Course Description
In this class, you will learn the essentials of the DBA profession, extend your skillset to all aspects of administering MariaDB and strategies for achieving HA (Master Slave Replication), as well as a primer to MaxScale. We will cover MariaDB concepts and essential tools and to optimise use of the resources available for your databases. We will also thoroughly review core administrative tasks such as backups and restoration, monitoring and maintaining databases, and user security.
You’ll learn about administering MariaDB
- Install and configure MariaDB
- Select best resources, storage engines, and data types
- Create views and server-side customizing Partitioning tables
- User and server security
- Monitoring and maintaining databases Backups and restoration
- Configuring replication
You’ll learn about High Availability for MariaDB databases:
- Set up standard replication and use it for controlled and emergency switchover
- Install, configure and administer Master & Slave
- User and server security
- Install and configure disaster recovery and backup database for MariaDB
Course Outline
- Architecture
- Distributions & Versions
- Client Utilities
- Configuration
- Resource Usage
- Storage Engines
- Table Schema
- Views
- Partitioning
- User & Server Security
- Monitoring & Troubleshooting
- Logs Files
- Back-Ups & Restoration
- Customizing
- MariaDB Replication
- Optimization
- MariaDB Replication
- MariaDB Replication Complex Scenarios
- MariaDB Semi-Synch Plugin
- MariaDB Enterprise High Availability
- MariaDB MaxScale Overview & Installation)
- MaxScale Configuration
- MariaDB Master-Slave Setup
- Master-Slave Automated Failover & Restore
- MariaDB Clustering Overview
Programme scope, delivery arrangements and suitability are confirmed during enquiry.