May 25, 2020

Migrate from MongoDB Replica-Set to a Sharded Cluster - Antonios Giannopoulos & Jason Terpko - P

When deploying a MongoDB instance, there is a couple of important decision that has to be made. An important one is a decision whether the instance is going to be a Replica-set or a Sharded Cluster. It’s not uncommon to start with a Replica-set, as its easier to deploy and simpler to operate. For some workload, the Replica-set instance may not be the best option, mainly performance-wise, and the migration to a sharded cluster is the only...

Percona Live SessionsMongoDBMigration


May 25, 2020

A Step by Step guide to using Databases on Containers - Kathy Gibbs - Percona Live Online 2020

In this session, I will detail in a step by step fashion how to install a database on a Docker container. I will step through how to get Docker loaded for testing, how to configure the containers, how to set up a script to install and start a PostgreSQL database (though the steps will be very similar for MySQL as well). I will then connect and restore the database that we just created. After this session, you will be able to go and set up...

Percona Live SessionsContainers and Automation


May 25, 2020

Profiling MySQL and MariaDB Hash Join Implementations- Jim Tommaney - Percona Live Online 2020

Hash Joins are a foundational join technology, now available in MySQL!

  • No index maintenance overhead.Can be orders of magnitude faster.Available for ad-hoc workloads and ETL.
  • Great complement to index join operations.

However, the underlying implementation is fundamentally different and introduces additional tweaks to optimize performance.
This presentation will give you the tools to learn when to...

Percona Live SessionsMariaDBMySQLOperations


May 25, 2020

How Safe is Asynchronous Master-Master Setup in MySQL?

It is common knowledge that built-in asynchronous master-master (active-active) replication is not safe. I remember times when the official MySQL User Reference Manual stated that such an installation is not recommended for production use. Some experts repeat this claim even now.

While this statement is generally true, I worked with thousands of shops that successfully avoided asynchronous replication limitations in active-active...

MySQLOperationsHigh Availability


May 22, 2020

MariaDB 10.4 and the Competition - Kaj Arno - Percona Live Online 2020

There are many good databases out there. Picking the right database for your project is never easy. There are technical criteria, business criteria, perhaps even ethical criteria. In this keynote, MariaDB Foundation CEO Kaj Arnö will present his – obviously completely impartial – view of the process.

Should you pick a database in the cloud or on-premise? Should you pick a relational database or a NoSQL database? Should you pick...

Percona Live SessionsMariaDB


May 22, 2020

Will Postgres Live Forever? - Bruce Momjian - Percona Live Online 2020

This presentation explains how OpenSource software can live for a very long time, and covers the differences between proprietary and open source software life cycles. It also covers the increased adoption of open source, and many of the ways that Postgres is innovating to continue to be relevant.

Percona Live SessionsPostgreSQL


May 22, 2020

Moving Beyond Zero Sum Approaches to Open Source - Matt Asay - Percona Live Online 2020

Opensource licensing had been on a steady shift toward more permissive licenses, but lately seems to have taken a sharp turn to the (copy)right. In this talk we'll dig into what's happening in open source licensing and strategies (effective and not-so-effective) enterprises use to avoid getting locked into proprietary bait-and-switches.

Percona Live Sessions


May 22, 2020

State of the Dolphin - Le fred - Percona Live Online 2020

Learn from MySQL Expert and Oracle Community Manager Frédéric Descamps. He will talk about the latest improvements in MySQL 8.0.20 and the MySQL Engineering Team’s steady progress with MySQL 8.0. These include solutions like Document Store, InnoDB Cluster, and InnoDB ReplicaSet where MySQL Router and MySQL Shell are playing an important role. All of these Oracle solutions are completely open source.

Percona Live SessionsMySQL


May 22, 2020

Trends that are disrupting and breaking your DB infrastructure - Matt Yonkovit - Percona Live 2020

CXO Matt Yonkovit covers how the current trend of distributed technology decisions is leading to a new trend of issues including more outages, security issues, and higher costs. DBA's and infrastructure teams are now inheriting technologies they are unprepared for and often uneducated about. The push to automate and eliminate humans from the database management process has collided with the trend of storing more data. This lethal...

Percona Live SessionsOperations


May 22, 2020

State of Open Source Database - Peter Zaitsev - Percona Live Online 2020

It has been an exciting year in the open-source Database industry, with more choice, more cloud, and key changes in the industry. In his keynote address, Peter Zaitsev of Percona will dive into the key developments over the last year, including the most important open-source database software releases, the significance of cloud-native solutions in a multi-vendor multi-cloud world, the new criticality of security challenges, the evolution...

Percona Live SessionsPercona Open Source Software


Pages