Colin Charles is a Consultant at Codership, the makers of Galera Cluster. Previously, Colin was on the founding team of MariaDB Server, and has been around the MySQL ecosystem including being an early employee at MySQL, and worked actively on the Fedora and OpenOffice.org projects. Colin has been a MySQL user since 2000.
Presentation: Running MySQL & MariaDB Server securely in 2019
The Internet is filled with outdated information on how you in practice run MySQL and MariaDB Server securely in 2019. Naturally, this is not the fault of the Internet but the fact that the security models with modern MySQL 8 and MariaDB Server 10.3/10.4 have changed, giving you newer options. More interestingly is also the fact that you tend to run in Wide Area Network (WAN) environments, and replication can happen across cloud-based environments. This is where we will also within this talk setup quickly a fully running 3-node Galera Cluster with MariaDB Server 10.4, in a secure fashion, showing you why you do not have to “run with SELinux turned off” or other poor practices (e.g. turning off the firewall). Topics covered but not limited to: TLS/SSL for connections, replication, external authentication, encryption, and regular running and configuration of your MySQL and MariaDB Servers (both of which take on many different options).
Presentation: “What’s new in Galera Cluster 4”
“Galera 4 is the new kid on the block, and it comes with MariaDB Server 10.4 by default. This presentation outlines the new features in Galera 4, as well as some that you may have missed in Galera 3.6+.
What is Galera Cluster? It is the true multi-master, active-active cluster solution for MySQL and MariaDB Server, making use of synchronous replication (regular MySQL replication is asynchronous or semi-synchronous). It ensures that all nodes are equal, so there is no need for primary-secondary (master-slave) failover, comes with automatic node provisioning, requires no read/write splitting, and is extremely easy to use and deploy. Galera Cluster is cloud architecture ready too.
Galera provides synchronous replication to MySQL and MariaDB Server, as it is a replication plugin. With Galera 4, you will see enhancements in synchronous Galera replication. Some of the new features covered include streaming replication, where transactions can execute in parallel across all cluster nodes, huge transaction support, intelligent donor selection, and new ways to recover your primary component. Covered will also be backup locks and how to use Mariabackup for SST.
Towards the end, there will be a focus on what else to expect soon — non-blocking DDL, XA transaction support, and a whole lot more.”