Securing your data is only as good as your weakest link. A clear-text password in a file or history file, shared privileges between test and production or open sudo access when you can connect as an unprivileged user all are security flaws. This talk discusses how to navigate the poor defaults MySQL has in place, how to strengthen processes and how to audit your environment. It also covers the complexity of deploying changes in an always available production environment.

Presented at the Data.Ops Conference in Barcelona, Spain.
Download slides

The MySQL Community Awards initiative is an effort to acknowledge and thank individuals and corporations for their contributions to the MySQL ecosystem. It is a from-the-community, by-the-community, and for-the-community effort. The committee is composed of an independent group of community members of different orientation and opinion, themselves past winners or known contributors to the community.

The 2018 community awards were presented on April 23, 2018, during the Welcome Reception at the Percona Live conference. The winners are:

MySQL Community Awards: Community Contributor of the year 2018

• Jean-François Gagné
  Jean-François was nominated for his many blog posts, bug reports, and experiment results that make MySQL much better. Here is his blog: …

Calling all developers, DBAs, engineers, SREs, and database aficionados: we’re hitting the road and hope to see you along the way. It's always a highlight of our year when we get to meet up with our users and friends face-to-face, and we'll be attending events across the country (and abroad!) for the rest of 2018. If you see our booth, come say hello. 

Image Credit

Below is a list of the places you'll be able to find us over the next nine months, plus descriptions of how we'll be involved at each event (and, in some cases, special ticket discount codes).

Use the opportunity to talk to Galera Cluster developers and experts. Visit Galera Cluster booth at Conrad Hotel, New York City February 26-27. We will be happy to answer your questions and verify your Galera deployment plans.

There are many Galera Cluster presentations at the conference.

Under the Hood: Galera Cluster

Seppo Jaakola, CEO Codership

Tuesday 27th, 8:40 am – 9:30 am

This session will provide attendees with common use cases for clustering, a comprehensive explanation of how clustering works with Galera and introduce new features and improvements available in Galera Cluster 4.

Global Data Replication with Galera for Ansell Guardian

Greg Henderson and Louis Zircher

Monday 26th, 4:00 pm – 4:50 pm

In early 2017, we seamlessly replaced the global geo-distributed data synchronization …

Since its creation, Galera Cluster has established itself as the most popular high availability solution for MySQL and MariaDB users worldwide.

ClusterControl is the go-to automation and management system for Galera Cluster users.

And together, we’re going to walk you through all the different aspects that make Galera Cluster such a popular high availability solution for MySQL and MariaDB and how to best manage it with ClusterControl.

We’ll hear about the latest features of Galera Cluster directly from Codership, the creators of Galera Cluster. And we’ll look at how to automate everything from deployment, monitoring (how about ASCII-art graphs?), backups, failover, recovery, rolling upgrades and scaling using the ClusterControl CLI (for a change, we also have a GUI of course).

AGENDA

Introduction
About Codership, the makers of Galera Cluster
About Severalnines, the makers of …

We will demonstrate the ease of monitoring Galera Cluster using Monyog. By the end of the webinar, you will have a better understanding of how to use Monyog for monitoring Galera Cluster for MySQL to achieve a required balance of high availability and scalability.

Galera Cluster for MySQL is a multi-master active-active cluster. It is an easy-to-use, high-availability solution, which provides high system uptime, no data loss, and scalability for future growth. In this webinar, we will give an overview how does Galera Cluster work and what are the benefits of using Galera Cluster. 

Join USA timezone webinar Wed, May 17, 10:00 AM – 11:00 AM …

Find Galera Cluster developers and experts in our booth.  We would be happy to hear your Galera Cluster story.

Galera presentations in MI17:

Deep Dive: Adding Replication and Scaling with Galera

Wednesday, April 12 1:10 pm – 2:00 pm.

Seppo  Jaakola, Codership CEO

Data inconsistency is the worst problem that can happen for a synchronous database cluster. At some point it will appear during replication processing, simply because the application of replication events is not possible in some cluster nodes due to missing rows, excessive rows or wrong values in the row columns. As a result, this usually stops the replication process ...READ MORE

Step-by-step: Clustering with Galera and Docker Swarm

Wednesday, April 12 2:10 pm – 3:00 pm

…

Description

In this part of the webinar series on best practices for Galera Cluster, we will discuss schema changes and DDL.

We will show how Galera Cluster executes DDLs in a safe, consistent manner across all the nodes in the cluster, and the differences with stand-alone MySQL. We will discuss how to prepare for and successfully carry out a schema upgrade and the considerations that need to be taken into account during the process.

Time: 9-10 AM PST (Pacific time zone), 21st of  February

Speakers: Philip Stoev, Quality and Release Manager, Codership                Sakari Keskitalo, COO, Codership

REGISTER TO THE USA TIMEZONE WEBINAR

Description

In this part of the webinar series on best practices for Galera Cluster, we will discuss schema changes and DDL.

We will show how Galera Cluster executes DDLs in a safe, consistent manner across all the nodes in the cluster, and the differences with stand-alone MySQL. We will discuss how to prepare for and successfully carry out a schema upgrade and the considerations that need to be taken into account during the process.

The webinar will conclude with a Q&A session where you can ask any questions you may have about Galera Cluster.

Time: 9-10 AM PST (Pacific time zone), 21st of  February

Speakers: Philip Stoev, Quality and Release Manager, Codership                Sakari Keskitalo, COO, Codership

…

Calling all Bostonian MySQL professionals, experts, amateurs, and enthusiasts! On October 10, Baron Schwartz, VividCortex's founder and CEO, will join the Boston MySQL Meetup Group for a presentation titled "Meeting the Challenges of Monitoring in the Cloud."

As DBaaS and "serverless" systems increasingly underlie the current paradigm for app development, understanding the best ways to gain visibility into cloud-based systems is becoming ever more important. Between Baron's experience building VividCortex, a cloud-based database peformance management platform, and writing about best practices for database performance and scaling, he has a unique perspective for leading an insightful and interactive conversation about the current challenges of monitoring in the cloud -- and what those challenges might look like in the …