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

    May 26, 2020

    Unbounded scale: Using Vitess for scaling write intensive workloads - Percona Live Online 2020

    Unbounded scale: using Vitess for scaling write intensive workloads by Morgan Tocker, Daniel Guzman Burgos
    Scaling very large MySQL applications is the ultimate challenge, and there's no native solution for it. Since vertical scaling is not sustainable in time, horizontal scaling is the smartest move. Sharding issues within MySQL are not trivial but also not imposible. We will discuss thoses issues and how Vitess handle those to...

    Percona Live SessionsMySQLScalability

    May 26, 2020

    Creating an Open Source MySQL Firewall - Alex Rubin - Percona Live Online 2020

    Creating an Open Source MySQL Firewall

    Percona Live SessionsMySQLPerformance Optimization

    May 26, 2020

    Declarative Caching with Postgres and Redis - Kyle Davis - Percona Live Online 2020

    The concept of caching is not complicated: store the results of a query for a short period of time in a fast storage engine so you touch the slow and/or expensive database less. This simple concept often hides application-level complexity as not all queries should be cached. Deciding what to cache and what not to cache depends on many factors:
    Will there be a performance benefit? Already short running queries may have negligible...

    Percona Live SessionsPostgreSQLOperations