Course Code: mariadbcbspk
Duration: 14 hours
Prerequisites:

  • Working knowledge of SQL

  • DB Administration experience

Course Outline:

1. MariaDB History & Release background

2. Server installation

3. Architecture

4. Storage Engines

5. Permission set

6. User permissions

7. System, Session and Local variables

8. Security guidelines

9. Log Files

10. Backup & Recovery

  • Setting up PITR
  • Backup techniques

11. Multiple MariaDB Server instances

12. Optimization

  • Query Cache
  • Parameters affecting performance

13. Replication

  • (sync vs async)
  • Maxscale

14. Partitioning

15. Query Plans & Profiling