Monthly Archives - April 2018

Keep Sensitive Data Secure in a Replication Setup

Keep sensitive data secure

This blog post describes how to keep sensitive data secure on slave servers in a MySQL async replication setup.
Almost every web application has a sensitive data: passwords, SNN, credit cards, emails, etc. Splitting the database to secure and “public” parts allows for restricting user and application parts access to sensitive data.
(more…)

Read more

This Week In Data with Colin Charles 37: Percona Live 2018 Wrap Up

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Percona Live Santa Clara 2018 is now over! All things considered, I think it went off quite well; if you have any comments/complaints/etc., please don’t hesitate to drop me a line. I believe a survey […]

Read more

MySQL 8.0 GA: Quality or Not?

MySQL 8.0 GA

What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA?
When it comes to being a software critic, a lot.
In many ways, the work of a software critic is easy. We risk very little and thrive on negative criticism, which is fun to […]

Read more

The Evolution of the DBA in an “As-A-Service” World

DBA

The requirements for managing and running a database in a modern enterprise have evolved over the past ten years. Those in charge of running enterprise databases have seen their focus shift from ensuring access and availability, to architecture, design and scalability responsibilities. Web-first companies pioneered the change by charging site reliability engineers (SRE’s) or […]

Read more

MySQL Community Awards Winners 2018

2018 Community Awards

One of the highlights of Percona Live is that the winners of the annual MySQL Community Awards are announced. A 100% community effort, the awards were created to recognize community contribution. This year saw six very deserving winners in three categories:
MySQL Community Awards: Community Contributor of the year 2018
Two individuals received these awards:

Jean-François Gagné
Jean-François […]

Read more

Percona Live 2018: Closing Ceremony with Lightning Talks

Mariella ViaSat Percona Live 2018

Percona Live 2018 is officially done! The closing ceremony ends the conference with a last few lightning talks and a prize giveaway.
We ended the Percona Live 2018 conference the same way we started: with talks! This year, we had our lightning talks as part of our closing ceremony. They included:
Amazon Aurora MySQL and RDS […]

Read more

Percona Live 2018: POLARDB, an InnoDB Based Shared-Everything Storage Solution

Inaam Alibaba Percona Live 2018

We’re heading into the home stretch at Percona Live 2018, but the sessions are continuing. I was able to attend a talk this afternoon given by Inaam Rana, a Database Developer at Alibaba Cloud, on PolarDB, an InnoDB based shared-everything storage solution.
POLARDB provides read scale out on shared everything architecture. It features 100% backward […]

Read more

Percona Live 2018: Securing Access to Facebook’s Databases

Andrew Facebook Percona Live 2018

We’re moving along at Percona Live 2018, and there are still packed and energetic talks after lunch.
My next session was with Andrew Regner, Production Engineer at Facebook. His talk was on securing access to Facebook’s databases.
Since the beginning, Facebook has used a conventional username/password to secure access to production MySQL instances. Over the last […]

Read more

Percona Live 2018: Migrating to Vitess at (Slack) Scale

Michael Slack Percona Live 2018

Percona Live 2018 is moving along, and the first person I got a chance to talk with is Michael Demmer, Senior Staff Engineer at Slack. His talk was on Migrating to Vitess at (Slack Scale).
MySQL is the backbone of Slack’s data storage infrastructure. It handles billions of queries per day across thousands of sharded […]

Read more