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...
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...
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.
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...
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...
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....
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...
Containers and AutomationPercona Open Source Software