May 26, 2020

Enhancing MySQL Security at LinkedIn- Karthik Appigatla - Percona Live Online 2020

In this talk, we will discuss how security is enhanced for MySQL at LinkedIn. The following areas will be covered:

1- A brief overview of MySQL at LinkedIn
2- MySQL Access Management- Privileged User Access Control- Fine-grained Access Control- Access to application owners
3- SSL- Applications to Databases- Replication
4- Audit Framework- Audit Plugin- Syslog to Kafka- Query Analyzer
5- How applications get...

Percona Live SessionsMySQLSecurity

May 26, 2020

Comparison of Kubernetes Operators for MySQL - Mykola Marzhan - Percona Live Online 2020

Running databases in Kubernetes attracts a lot of attention today. Orсhestration of MySQL on Kubernetes is no way a straightforward process. There are several good MySQL based solutions in the open-source world, made by Oracle, Presslabs, and Percona. Having a common base, they differ in self-healing capabilities, consistency guarantees, storage capabilities, monitoring, proxying and backup / restore support, etc. So, let’s make a fair...

Percona Live SessionsContainers and AutomationMySQL

May 26, 2020

Running Elasticsearch at large scale - Alex Cercel - Percona Live Online 2020

ElasticSearch is a high-performance search engine based on Apache Lucene. It is growing in popularity which means that more and more users are running part of their search patterns against the information stored on this datastore. However, it’s quite difficult to find a comprehensive set of best practices that will assist in efficiently running large scale clusters. In this talk, I will cover tuning parameters and approaches that will help...

Percona Live SessionsSearch and Indexing

May 26, 2020

ClickHouse New Features 2020 - Aleksei Milovidov - Percona Live Online 2020

Aleksei Milovidov presented a subset of the most unusual ClickHouse features that you may have never heard of:
  • ClickHouse as a hardware benchmark;
  • ClickHouse without a server;
  • ClickHouse for semistructured data;
  • ClickHouse to accelerate MySQL;
  • ClickHouse integration for machine learning tools;
  • ClickHouse on GPU...
  • Percona Live SessionsOperations

    May 26, 2020

    Parallelism in PostgreSQL - Ibrar Ahmed - Percona Live Online 2020

    PostgreSQL’s architecture is process-based instead of thread-based. PostgreSQL launches a process “postmaster” on startup and after that spans a new process whenever a new client connects to PostgreSQL. Before version 10 there was no parallelism in a single connection. It is true that multiple queries from a different client can have parallelism because of process architecture, but a single query runs serially and did not have parallelism...

    Percona Live SessionsPostgreSQL

    May 26, 2020

    Expert MariaDB: Utilise MariaDB Server Effectively - Colin Charles - Percona Live Online 2020

    Let's take a simple Oracle-backed application, and migrate it to MariaDB Server 10.4. While we are at it, let's learn about how to use system versioned tables, Galera 4, the MyRocks storage engine, Flashback to rollback tables/databases to an older snapshot, and also use the built-in thread pool. This and more is possible in 3 hours, as MariaDBServer 10.4 has been out for some time now (June 2019) and it has many new features, some of...

    Percona Live SessionsMariaDBOperations

    May 26, 2020

    Kubernetes - the Swiss Army Knife for your ProxySQL deployments - Rene Cannao - Percona Live 2020

    ProxySQL is a high performance proxy from design to implementation. It speaks the MySQL protocol, and can go beyond load balancing. This talk covers various deployment options for ProxySQL in a Kubernetes environment.
    Typically ProxySQL is deployed in one of three ways depending on the scale and needs of your environment:
    - Directly on each application server
    - On a separate server (or layer)
    - Cascaded, i.e. on each...

    Percona Live SessionsMySQLPerformance Optimization

    May 26, 2020

    Dark corners of the MySQL code base - Daniel Black - Percona Live Online 2020

    As you'd expect with a 25+ year code base there are aspects of the MySQL codebase that are unglamorous. These dark corners contain implementations that introduce behaviour that users depend upon, that changing will introduce storage or replication compatibility issues, or just don't attract the resources to sufficiently rewrite. These areas of code can lead to performance degradation by having code that doesn't utilize hardware in an...

    Percona Live SessionsMySQLOperations

    May 26, 2020

    OpenSource cost-efficiency in action: analyzing 500B rows - Alexander Zaitsev - Percona Live Online

    OpenSource cost-efficiency in action: analyzing 500B rows on a single ClickHouse server

    Percona Live SessionsOperations

    May 26, 2020

    Percona Monitoring and Management 2.6 - Security Threat Tool - Percona Live Online 2020

    Steve Hoffman, Daniel GB In this presentation, we will talk about Uber's journey from using Cassandra as one of the primary databases to an in-house scalable and consistent replacement built on top of MySQL. We will talk about some of the challenges related to reliability, developer productivity and efficiency that we faced when using Cassandra. We will go over the architecture of the in-house replacement, the design principles that we...

    Percona Live SessionsPercona Monitoring and Management