MariaDB Server 10.2: The Complete Guide
summary
MariaDB 10.2 ships as a release candidate (2017) and continues the fork-from-MySQL‑5.5 path while adding concrete features: SQL window functions and recursive CTEs implemented and usable, integrated Galera Cluster packaging, an open‑source threadpool, and table‑space plus binary log encryption at rest that works with INNODB; MyRocks storage engine is integrated for lower write amplification; JSON support exposes ~24 functions without a native JSON type; optimistic parallel replication, DML flashback rollback, enhanced kill/timeout controls, progress reporting, and INNODB defragmentation are all available.
AI-written summary · about
chapters (61)
- 0:00Start
- 0:40What is MariaDB Server?
- 1:09What is MariaDB Server, really?
- 4:27MariaDB Thru the years
- 5:13MariaDB governance
- 6:09MariaDB Server 5.1
- 7:29MariaDB Server 5.2
- 8:56MariaDB Server 5.3
- 10:33MariaDB Server 5.5
- 12:08MariaDB Server 10.0
- 14:47The Spider Talk to go to
- 15:14Why MariaDB?
- 16:08Where is MariaDB found?
- 16:48The 10.1 "community release"
- 17:33The 10.2 release so far
- 18:1810.2 Themes
- 18:51Analytical queries
- 20:02The analytical queries talk to go to
- 20:21Client & Protocol
- 21:18Removing Historical Limitations, refactoring
- 22:28Replication
- 24:15The flashback talk to go to
- 24:40JSON & #GeoJSON
- 25:44InnoDB from #MySQL 5.7
- 26:49MyRocks
- 27:15The MyRocks talk to go to
- 27:32Manageability
- 27:52Google Summer of code
- 28:1410.1 Themes
- 28:38Security - Encryption
- 29:15Encryption II
- 29:29Encryption IV
- 30:52Password validation
- 31:39SQL error logging plugin
- 31:54Audit Plugin
- 32:47Authentication plugins
- 34:10MariaDB 10 replication: provisioning a new slave
- 34:24Multi-source replication
- 34:40Galera cluster integrated
- 35:28Optimistic parallel replication
- 35:51the parallel replication talk to go to!
- 36:23Replication: start Transaction with consistent snapshot
- 37:06An #opensource threadpool
- 38:17InnoDB improvements
- 38:55InnoDB #WebScaleSQL
- 39:42Per query variables
- 40:01Statement timeouts
- 40:28Enhanced Kill syntax
- 40:50Progress reporting
- 41:36Optimiser enhancements
- 41:59Connect
- 42:16Other bits
- 42:34Gis
- 42:59Compatibility
- 43:50The 10.1 "community release"
- 44:20MariaDB still unique! (vs 5.7)
- 45:53Participate on MariaDb Community
- 46:24MariaDB books and manuals
- 46:35MariaDB Server 10.3
- 47:36In conclusions
- 48:35Watch out for a compatibility guide...
