Videos from Percona | Page 2
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...
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...
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