Course Outline
Installing the MariaDB server
- Installing on Ubuntu/Debian
- Installing on other Linux distributions
- Installation on Windows
MariaDB server files and scripts
- MariaDB programs
- MariaDB server
- MariaDB client
- GUI tools
MariaDB server configuration
- Server options
- The server SQL mode
- Server system variables
- Dynamic system variables
- Server status variables
- Shutdown process
MariaDB security issues
- Securing MariaDB against attacks
- Security-related options
- Security issues with LOAD DATA LOCAL
MariaDB access privilege system
- MariaDB privilege system overview
- Privileges provided by MariaDB
- Connecting to the MariaDB server – stages
- Access control, Stage 1: Connection verification
- Access control, Stage 2: Request verification
- Access denied errors
MariaDB user account management
- Users and passwords
- Creating new users
- Deleting user accounts
- Limiting user resources
- Changing passwords
MariaDB database maintenance
- Backup and recovery
- Point-in-time recovery
- Maintenance and crash recovery
- myisamchk syntax and options
- Getting table information
- MariaDB local setting
- National characters and sorting
- MariaDB server time zone
MariaDB log files
- Error log
- General query log
- Update log
- Binary log
- Slow query log
- Log file maintenance and rotation
Running multiple MariaDB servers on the same machine
- Running multiple servers in Windows
- Running multiple servers in Windows as services
- Running multiple servers in Unix and Linux
- Using client tools in a multi-server environment
MariaDB query cache
- The concept of query cache
- Testing query cache with SELECT
- Configuring query cache
- Checking query cache status and maintenance
The CONNECT storage engine
- Installing the CONNECT storage engine
- Creating and dropping CONNECT tables
- Reading and writing CSV data using CONNECT
- Reading and writing XML data using CONNECT
- Accessing MariaDB tables using CONNECT
- Using the XCOL table type
- Using the PIVOT table type
- Using the OCCUR table type
Exploring dynamic and virtual columns in MariaDB
- Creating tables with dynamic columns
- Inserting, updating, and deleting dynamic column data
- Reading data from a dynamic column
- Using virtual columns
Performance and usage statistics
- Installing the audit plugin
- Using the audit plugin
- Using engine-independent table statistics
- Using extended statistics
- Enabling the performance schema
- Using the performance schema
Optimizing and tuning MariaDB
- Using SHOW STATUS
- Controlling MariaDB optimizer strategies
- Using extended keys with InnoDB and XtraDB
- Configuring the MyISAM segmented key cache
- Configuring threadpool
- Configuring the Aria pagecache
- Optimizing queries with the subquery cache
- Optimizing semijoin subqueries
- Using microseconds in DATETIME columns
- Updating the DATETIME and TIMESTAMP columns automatically
Requirements
Fundamental knowledge of any database system and the SQL language.
Testimonials (7)
The trainer explained everything with a lot o detail, and it was always engaging us.
Florian Lipianu - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Database Administration
It was structured very well and documented information. I really liked the trainer enthusiasm.
Oana Bunea - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Database Administration
A lot of practical examples.
Stefan Turcu - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Database Administration
knowledge of the trainer
mohamed labib - e-finance
Course - MariaDB Database Administration
The training environment was accessed very fast without any specific configurations.
Krasimir Troskov
Course - MariaDB Database Administration
Method of teaching. Johan was very comprehensive .
Stanimir petrov
Course - MariaDB Database Administration
The trainer. He is very knowledgeable in his field.
