Jun 29, 2020

How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster

In this webinar, Sveta Smirnova, MySQL Engineer at Percona, will uncover nuances of PXC schema upgrades and point out details you need to give extra attention.

Percona XtraDB Cluster (PXC) is a 100% synchronized cluster in regards to DML operations. It is ensured by the optimistic locking model and ability to rollback transaction which cannot be applied on all nodes.

However, DDL operations are not transactional in MySQL....

Percona XtraDB ClusterOperations

Jun 9, 2020

MySQL Ecosystem in 2020

Join Alkin Tezusal, Percona Technical Expert, as he covers the past, present and future of MySQL as an Open Source Database.

During this webinar he will discuss:
  • Use cases of MySQL as well as edge cases of MySQL topologies using real-life examples and "war" stories
  • How scalability and proxy wars make MySQL topologies more robust to serve webscale shops
  • Open-source tools, utilities, and surrounding MySQL...


Jun 5, 2020

ProxySQL 2.0 native support for Percona XtraDB Cluster (PXC) 5.7 - Vinicius Grippa

In this session, I will cover the new functionalities introduced by ProxySQL 2.X and how simple it became when we compare to ProxySQL 1.X versions when it was necessary to use an external script with the scheduler. A demonstration will show how to configure ProxySQL for PXC. Subsequently, new functionalities will be covered to explore the potential of the new version using SSL in the front end to communicate with the application and how to...

Percona XtraDB ClusterOperations

May 26, 2020

Cassandra where and how - John Schulz - Percona LIve Online 2020

You have decided you want to deploy your application using Cassandra. What flavor of Cassandra do you want to use? Do you want to do it open source or enterprise? If Enterprise, Datastax or Scylla? On-premise or in the cloud? Self-managed or Cassandra as a service?
In this talk I will discuss:
- The various Cassandra or Cassandra compatible databases including Apache Cassandra, DSE, Scylla, Azure xxx and Yugabyte.
- Self-...

Percona Live SessionsOperations

May 26, 2020

Scaling financial audit logs at TransferWise with MongoDB - Pedro Albuquerque - Percona Live 2020

TransferWise is a global technology company that is building the best way to move money around the world and 6M users are transferring more than $5 billion every month with us. All transfers within TransferWise are processed by strict state machine rules handled by "Transfer Service". The state machine has a lot of different states like "New", "Money Received", "Converted", "Transferred", and the Transfer object itself contains the most...

Percona Live SessionsMongoDBOperations

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

    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

    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

    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