Nov 3, 2020

Best Practice in Design and Implementing MySQL Geographic Distributed, High Availability Solutions - PLO October 2020

Nowadays implementing different grades of business continuity for the data layer storage is a common requirement.

When designing architectures that include MySQL as a data layer, we have different options to cover the required target. Nevertheless we still see a lot of confusion when in the need to properly cover concepts such as HighAvailability and Disaster Recovery. Confusion that often leads to improper architecture design...

MySQLHigh Availability


Nov 3, 2020

Vitess online schema migration automation - PLO October 2020

Vitess online schema migration automation - PLO October 2020

Migration


Nov 3, 2020

Security and Traceability on Distributed Database Systems - Julien Riou - Percona Live ONLINE 2020

Managing a single PostgreSQL instance can be challenging when failures happen. Replicas can be added and promoted when needed. However, application traffic has to be redirected to the new primary. At OVHcloud, a major cloud computing provider in Europe, we use load balancers in front of our databases clusters on production. In that case, PostgreSQL sees then all client connections coming from those IP addresses. That means we couldn't...

PostgreSQLSecurity


Nov 3, 2020

DBdeployer, the Community Edition - Giuseppe Maxia - Percona Live ONLINE 2020

DBdeployer, an OpenSource tool that allows easy deployment of many MySQL/Percona servers in the same host, has passed two years of development. Its latest additions have aimed at improving ease of use for both beginners and experts.

This talk will show how to start with dbdeployer with an empty box, and quickly populate it with recent and less recent server versions, all at the command line.

MySQLOperations


Nov 3, 2020

SELinux Fun With MySQL and Friends - Matthias Crauwels - Percona Live ONLINE 2020

SELinux (Security Enhanced Linux) provides an enhanced security mechanism for more advanced access control and auditing. It allows your application software and your system users to only access the resources it's been preconfigured to allow. Of course, when you want to move your data- or log files to a non-standard location these policies will stop your database from starting.

The easy way out is obviously to set SELinux to...

Security


Nov 3, 2020

Serverless Databases: The Good, the Bad, and the Ugly - Renato Losio - Percona Live ONLINE 2020

Starting with AWS, the major cloud providers offer different options to run a MySQL or a MySQL-compatible database on the cloud.

A new approach is to rely on so-called serverless (relational) databases like Aurora Serverless that offer both traditional TCP connections and HTTP API access. Can serverless really be the future? Can data API really replace a MySQL connector? What are the major limitations of a serverless database...

CloudMySQL


Nov 3, 2020

MySQL 8.0 Document Store - Discovery of a new world - PLO October 2020

MySQL Document Store enables us to work with SQL relational tables and schema-less JSON collections. So instead of having a mixed bag of databases, you can just rely on MySQL, where the JSON documents can be stored in collections and managed with CRUD operations. All you need to do is install the X plugin.

In this session, you will learn what a document store is, how to install and use it, and all the reasons for considering it....

MySQL


Nov 3, 2020

Using MongoDB with Kafka - Use Cases and Best Practices - Antonio Giannopoulos - Percona Live ONLINE

Kafka is a distributed event streaming platform that has become very popular in the past couple of years.

In a MongoDB-Kafka architecture, MongoDB may be configured as both a Sink and a Source. With sink we mean to ingest events from your Kafka topics directly into MongoDB collections, exposing the data to your services for efficient querying, enrichment, and analytics. With source we mean publish data changes from MongoDB into...

MongoDB


Nov 3, 2020

DIY DBaaS with Percona Kubernetes Operators - PLO October 2020

DIY DBaaS with Percona Kubernetes Operators - PLO October 2020

Containers and AutomationPercona Open Source Software


Nov 3, 2020

In and out of the weeds with MongoDB 4.4 Hedged Reads - PLO October 2020

In and out of the weeds with MongoDB 4.4 Hedged Reads - PLO October 2020

MongoDB


Pages