#MariaDB Server 10.2: The Complete Guide – #Database Tutorial

Colin Charles, Chief Evangelist from #Percona delivers their talk, “MariaDB Server 10.2: The Complete Guide”, on 2 of the Percona Live #OpenSource Database Conference 2017, 4/26, at Santa Clara, CA.

The new #MariaDB Server 10.2 release is out. It has some interesting new features, but beyond just a feature overview we need to look at how to use some of them. Learn about window functions, common table expressions, finer grained CREATE USER statements, and a lot more — including getting #mysqlbinlog up to parity with #MySQL. But there are still unique features that don’t exist in #MySQL yet, so it’s worth talking about encryption at rest, integrated Galera Cluster, threadpool, #InnoDB defragmentation, roles, extended REGEXP, etc.

This talk will go over everything new that #MariaDB 10.2 has to offer. It will describe all new features, both #MySQL compatible and #MariaDB-only ones, and show usage examples and practical use cases. Also to be discussed, a bit of a feature roadmap for #MariaDBServer 10.3.

You can find more about #OpenSource #Databases, #MariaDB and Percona Live Online 2020 in these link 👇🏻👇🏻👇🏻

https://www.percona.com/services/support/mariadb-support
https://www.percona.com/services
https://www.percona.com/live/percona-live-online-full-agenda

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel

Connect With us on our Social Networks 👇🏻👇🏻👇🏻
Follow Percona on Twitter: https://twitter.com/Percona
Follow Percona on Facebook: https://www.facebook.com/Percona
Follow Percona on Instagram: https://www.instagram.com/percona_llc/
Follow Percona on LinkedIn: https://www.linkedin.com/company/percona/

Playlist📝

00:40 What is MariaDB Server?
01:09 What is MariaDB Server, really?
04:27 MariaDB Thru the years
05:13 MariaDB governance
06:09 MariaDB Server 5.1
07:29 MariaDB Server 5.2
08:56 MariaDB Server 5.3
10:33 MariaDB Server 5.5
12:08 MariaDB Server 10.0
14:47 The Spider Talk to go to
15:14 Why MariaDB?
16:08 Where is MariaDB found?
16:48 The 10.1 “community release”
17:33 The 10.2 release so far
18:18 10.2 Themes
18:51 Analytical queries
20:02 The analytical queries talk to go to
20:21 Client & Protocol
21:18 Removing Historical Limitations, refactoring
22:28 Replication
24:15 The flashback talk to go to
24:40 #JSON & #GeoJSON
25:44 #InnoDB from #MySQL 5.7
26:49 MyRocks
27:15 The MyRocks talk to go to
27:32 Manageability
27:52 Google Summer of code
28:14 10.1 Themes
28:38 Security – Encryption
29:15 Encryption II
29:23 Encryption III
29:29 Encryption IV
29:38 Encryption V
30:52 Password validation
31:39 #SQL error logging plugin
31:54 Audit Plugin
32:47 Authentication plugins
34:10 MariaDB 10 replication: provisioning a new slave
34:24 Multi-source replication
34:40 #Galera cluster integrated
35:28 Optimistic parallel replication
35:51 the parallel replication talk to go to!
36:23 Replication: start Transaction with consistent snapshot
37:06 An #opensource threadpool
38:17 InnoDB improvements
38:55 InnoDB #WebScaleSQL
39:42 Per query variables
40:01 Statement timeouts
40:28 Enhanced Kill syntax
40:50 Progress reporting
41:36 Optimiser enhancements
41:59 Connect
42:16 Other bits
42:34 Gis
42:59 Compatibility
43:50 The 10.1 “community release”
43.59 Welcome 5.7 features MariaDB had
44:20 MariaDB still unique! (vs 5.7)
45:53 Participate on MariaDb Community
46:24 MariaDB books and manuals
46:35 MariaDB Server 10.3
47:36 In conclusions
48:35 Watch out for a compatibility guide…