Percona Live ONLINE: Full Schedule

10:05 EDT

Why Public Database as a Service is Prime for Open Source Disruption

The database market is changing drastically in ways no one imagined 5 years ago. Database vendors are moving away from traditional deployment methods and embracing database as a service (DBaaS) as the default method to offer their database technologies to consumers and users. Much of this movement has been built because of the success and popularity of DBaaS offerings by major cloud vendors. Unfortunately, this is leading to a new era of NROSS ( Not really open source ) technologies that pretend to be free, open, and transparent but simply are not. As people wake up from the hangover’s caused by the incompatibilities, lack of portability, and increased costs they are looking at how to reclaim the openness, transparency, and freedom true open source has provided them in the past. Peter will explore the trends and give his opinions and ideas on how we need to disrupt the current trends to keep open source open, and give users the freedom of having a quality alternative.

Speakers

Peter Zaitsev

CEO, Percona

Peter Zaitsev co-founded Percona and assumed the role of CEO in 2006. As one of the foremost experts on MySQL strategy and optimization, Peter leveraged both his technical vision and entrepreneurial skills to grow Percona from a two-person shop to one of the most respected open source... Read More →

PZ Keynote PLO Oct2020 Why Public DBaaS Ripe for Open Source Disruption pptx

Tuesday October 20, 2020 10:05 - 10:30 EDT
Online

Keynote

10:30 EDT

The Democratization of Databases

This presentation covers the history of various governing structures and why democracy provides superior results. It then explains that open source is a form of democracy, compared to the methods used by proprietary software producers. It covers the many benefits Postgres hasenjoyed using an open development model, and how its future remains bright.

Speakers

Bruce Momjian

Vice President, Postgres Evangelist, EDB

Bruce Momjian is co-founder and core team member of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He has been employed by EDB since 2006. He has spoken at many international open-source conferences and is the author of PostgreSQL: Introduction and... Read More →

Slides Bruce Momjian pdf

Tuesday October 20, 2020 10:30 - 11:00 EDT
Online

Keynote

11:00 EDT

The Technological Response to a Global Pandemic - The Francis Crick Institute COVID19 Consortium Diagnostic Pipeline.

Since March 2020, the Francis Crick Institute has rapidly transformed its labs to become a COVID 19 diagnostic testing facility and contribute to the testing capacity for healthcare staff and patients in the North London community as part of our response to the global pandemic.

My presentation will share the work involved in setting the Francis Crick Institute up as a COVID19 testing facility, highlighting the technological journey to support the testing efforts and the considerations taken into account in relation to data governance, the importance of data auditing throughout the pipeline and the progress to date.

Speakers

Karen Ambrose

Team Lead, Research Data Services/Databases, The Francis Crick Institute

Karen Ambrose is the Head of the Research Data Services/Databases Team at the Francis Crick Institute. Her team have responsibility for databases at the Crick, storing everything from genetic data collected by research groups to operational process information, working with teams... Read More →

Slides Karen Ambrose pdf

Tuesday October 20, 2020 11:00 - 11:30 EDT
Online

Keynote

11:30 EDT

Organizing for Your Ethical Principles

Our job as engineers does not stop with eliminating technical defects and ensuring high reliability. Engineers of all kinds must ensure their work serves the public good. A service that reliably harms, exacerbates injustices, or excludes marginalized groups is not a service worth building and maintaining. Learn how to effectively accomplish change in your working conditions or your employer's products through grassroots employee advocacy

Speakers

Liz Fong-Jones

Field CTO, Honeycomb

Liz is a developer advocate, labor and ethics organizer, and Site Reliability Engineer (SRE) with 18+ years of experience. She is currently the Field CTO at Honeycomb, and previously was an SRE working on products ranging from the Google Cloud Load Balancer to Google Flights.

Emily Gorcenski

Head of Data, ThoughtWorks Germany

Organizing for Your Ethical Principles [Percona Live] pdf

Tuesday October 20, 2020 11:30 - 12:00 EDT
Online

Keynote

12:00 EDT

The Cloud is Inevitable

There is a reason why the cloud is gaining popularity. On one hand, software is growing and getting more complex. In contrast, the computing power of a single machine has more or less maxed out. The only way to keep growing is by distributing our software across machines. It is only a matter of time before this requirement starts to affect the databases. For many, it already has.
To face these changes, we have to evolve both in terms of the ability to distribute data, and with the kind of automation developers are starting to expect from cloud environments.
We will talk about how Vitess addresses these problems, allowing us to continue leveraging all the innovations that have gone into MySQL, and we'll cover what other options we have to move forward towards this unavoidable future.

Speakers

Sugu Sougoumarane

CTO, Planetscale, Inc.

Sugu is the co-creator of Vitess, and has been working on it since 2010. Prior to Vitess, Sugu worked on scalability at YouTube and was also part of PayPal in the early days. His recent interest is in distributed systems and consensus algorithms. He occasionally shares his thoughts... Read More →

Slides Sugu Sougoumarane pdf

Tuesday October 20, 2020 12:00 - 12:30 EDT
Online

Keynote

12:30 EDT

Engineering Data Reliably Using SLO Theory

Not so long ago, operations specialists worked much like today's data engineers do: with specialized skills, they were the people who kept sites running, who responded to emergencies, and who—unfortunately—spent much of their time dealing with incidents and other "fires." When the DevOps revolution came, this began to change. Better tools, better practices, and better culture shaped how Ops folks worked. A subset of that DevOps culture soon emerged: Site Reliability Engineers. These were people whose focus was not just on the day-to-day deployment of applications, but running platforms, products, and services with very high performance, very large scale, and with very high demand for reliability. Data Engineering was left out of this revolution.

But it is not too late! By taking concepts from SRE culture, in particular, the theory of Service Level Objectives, we look at how teams operating and developing data platforms and data products can be built more reliably through the use of quantitative measures and product thinking. This talk will discuss concrete examples of the benefits of this approach for data teams and how organizations can benefit from this mindset.

Speakers

Emily Gorcenski

Head of Data, ThoughtWorks Germany

Hosts

Alick Smith

Manager, Professional Services, Percona

Tuesday October 20, 2020 12:30 - 13:00 EDT
Online

Other OSDB

Difficulty Entry Level
Speaker Location Germany

13:00 EDT

Revision Control for Structured Data

Revision control for source code - and especially Git - has caused a great leap forward in software development and delivery. A similar revolution has not yet taken place in data. This talk will discuss the various open source databases that are approaching this problem, the underlying architectures and challenges in building both a 'Git for data' and a 'GitHub for data'.

It will posit that to be a true collaboration and distributed system, it must be:

1) decentralized
2) offline-first: work offline and then resync when online again
3) reliable: conflicts are handled properly
4) private: end-to-end-encrypted, if desired
5) efficient: only changes (diffs) to the data set are transmitted between participants
6) collaborative: multiple people can work on the same data set

Many applications choose the SaaS-route with one central database behind a web service and every frontend displays an instantaneous view of some part of the data set. This breaks most requirements.
The database-as-a-service approach with an MVCC database & the flexibility to version schemas is a prerequisite for success. Finally, the talk will look to the future and the dawn of CI/CD for data.

Speakers

Dr. Gavin Mendel-Gleason

CTO, TerminusDB

Dr Gavin Mendel-Gleason is CTO of TerminusDB. He is a former research fellow at Trinity College Dublin in the School of Statistics and Computer Science. His research focuses on databases, logic and verification in software engineering. His work includes contributing to the Seshat... Read More →

Hosts

Alick Smith

Manager, Professional Services, Percona

Slides Gavin Mendel Gleason pdf

Tuesday October 20, 2020 13:00 - 13:30 EDT
Online

Other OSDB

Difficulty Entry Level
Speaker Location USA

13:30 EDT

What If We Could Use Machine Learning Models as Tables?

In most machine learning tasks, one has to first organize data in some form and then turn it into information about the problem that needs to be solved. One could say that the requirement to train many machine learning algorithms is information, not just data. Given that most of the world's structured and semi-structured data (information) lives in databases, it makes sense to bring ML capabilities straight to the databases themselves. In this talk we want to present to the Percona community what we have learned in the effort of enabling existing databases like MariaDB and Postgres with frictionless ML powers.

Speakers

Jorge Torres

CEO, MindsDB

Jorge Torres is the Co-founder & CEO of MindsDB. He is also a visiting scholar at UC Berkeley researching machine learning automation and explainability. Before founding MindsDB, he worked for a number of data-intensive start-ups, most recently working with Aneesh Chopra (the first... Read More →

Hosts

Alick Smith

Manager, Professional Services, Percona

Slides Jorge Torres pptx

Tuesday October 20, 2020 13:30 - 14:00 EDT
Online

Cool New Technologies, Machine Learning

Difficulty Intermediate

14:00 EDT

Mastering Open Source Data Governance

With ever-changing data environments—such as the cloud—and data requirements, data maintenance, and management are becoming increasingly complicated. Data also exists in many forms, such as text, numbers, graphics, and video. After data are made meaningful, they become information, which is crucial to the operation of an enterprise.

Data governance ensures that:

• Stakeholder needs, conditions, and options are evaluated to determine balanced, mutually agreed enterprise objectives to be achieved through the acquisition and management of data/information resources.
• Direction is set for data/information management capabilities through prioritization and decision making.
• Performance and compliance of data/information resources are monitored and evaluated relative to mutually agreed-upon (by all stakeholders) direction and objectives.

Speakers

Elisha Chitsenga

Software Developer, Community, and Business Leader, Crestly Resorts

Elisha is a software developer with over 10 years of expertise, an accounting degree, a leader in the community and company, and a fully accredited information systems auditor. His main goals are to use cloud-based solutions, Linux, RISC-V, Python, and R coding to help the African... Read More →

Hosts

Camila Arocena

HR Assistant, Percona

PLO host briefing oct 2020 pptx

Tuesday October 20, 2020 14:00 - 14:30 EDT
Online

Security & Compliance

Difficulty Advanced
Speaker Location Zimbabwe

14:30 EDT

How Can Databases Capitalize on Computational Storage?

Systems and storage are evolving, with a new category of products called Computational Storage Devices emerging to alleviate problems with database performance bottlenecks and the costs of ever-growing datasets. Do you need to modify your database to capitalize on this emerging class of storage? What advantages can you get without code changes? Can using “wasteful” data structures actually reduce storage footprint while improving performance? Join us as we answer these questions and provide examples of benefits you can see today and in the near future through combining Computational Storage with Database operations.

Further Information

We'll cover some of the results from the recent Percona blog/whitepaper on ScaleFlux CSD 2000 for MySQL and the upcoming paper on CSD 2000 for Postgres. Additionally, will touch on modifications to SQL and NoSQL to take greater advantage of Computational Storage for cost savings and performance improvements.

Speakers

Tong Zhang

Chief Scientist, ScaleFlux

Dr. Tong Zhang is a well-established researcher with significant contributions to the areas of data storage systems and VLSI signal processing. Dr. Zhang is a co-founder and Chief Scientist of ScaleFlux, responsible for developing key techniques and algorithms for Computational Storage... Read More →

JB Baker

VP of Marketing & Product Management, ScaleFlux

JB Baker is a successful technology business leader with a track record of driving top and bottom line growth through new products for enterprise and data center storage. He joined ScaleFlux in 2018 to lead Product Planning & Marketing as we expand the capabilities of Computational... Read More →

Hosts

Camila Arocena

HR Assistant, Percona

Slides Tong Zhang & JB Baker pdf

Tuesday October 20, 2020 14:30 - 15:00 EDT
Online

MySQL, Storage

Difficulty Entry Level
Why this level of difficulty? Computational storage is a relatively new class of products. So, we don't expect people to know much. Some MySQL/PG/KV-store knowledge would be helpful in getting the full value of the material.
Speaker Location USA

15:00 EDT

NoSQL Endgame

The amount of data collected by applications nowadays is growing at a scary pace. Many of them need to handle billions of users generating and consuming data at an incredible speed. Maybe you are wondering how to create an application like this? What is required? What works best for your project?

In this session, we'll compare popular Java and JVM persistence frameworks for NoSQL databases. We are going to look at Spring Data, Micronaut Data, Hibernate OGM, Jakarta NoSQL, and GORM (which indeed is actually a Marvel character in the Conan Universe. ;-)

How do they compare, what are the strengths, weaknesses, differences, and similarities? We'll show each of them with a selection of different NoSQL database systems (Key-Value, Document, Column, Graph) to learn how they take specific features and powers of a particular NoSQL type into consideration and provide support for.

Will there be a clear winner in the end, or maybe it depends on the particular DB type and use case and you might need more than one, with different strengths, just like the Avengers...?

Speakers

Werner Keil

Director, CATMedia

Werner Keil is a Cloud Architect, Eclipse RCP and Microservice expert for a large bank. Helping Global 500 Enterprises across industries and leading IT vendors.He worked for over 30 years as IT Manager, PM, Coach, SW architect and consultant for Finance, Mobile, Media, Transport and... Read More →

Thodoris Bais

Scrum Master / JUG Founder & Leader, ABN AMRO / Utrecht JUG

Thodoris Bais works as a Scrum Master for ABN Amro bank and contributes to the prosperity of the IT community in several ways. He is the Founder & Leader of Utrecht Java User Group, which counts around 2500 members and has hosted exceptional speakers (among others, James Gosling and... Read More →

Hosts

Camila Arocena

HR Assistant, Percona

Tuesday October 20, 2020 15:00 - 15:30 EDT
Online

NoSQL, Application Development

Difficulty Entry Level
Speaker Location Germany

15:30 EDT

Availability and Performance Tradeoffs in Global Database Deployments

A key benefit of cloud database services is the ability to launch a database in multiple regions with just a few clicks. Typically you’d use a global deployment to enable fast cross-region disaster recovery and to place the data close to your users for fast local performance. A global deployment brings up questions such as: how many regions do I need? What RPO and RTO should I aim for? How do I design a scalable global application? In this session, we’ll discuss tradeoffs to consider for workloads with a global footprint such as financial, travel, or gaming applications, using Amazon Aurora Global Database as an example. You can use these strategies for other MySQL- or PostgreSQL-based cloud services if they have similar capabilities.

Speakers

Kevin Jernigan

Principal Database Solution Architect, Amazon Aurora, Amazon Web Services

Hosts

Matthew Boehm

Senior Instructor / Senior Architect, Percona

Matthew joined Percona in the fall of 2012 as a MySQL Consultant; now Senior Architect / Senior Instructor. His areas of knowledge include the traditional LAMP stack, memcached, MySQL Cluster, massive sharding topologies, and PHP/GoLang/C/C++ MySQL development. Previously, Matthew... Read More →

Slides Kevin Jernigan pdf

Tuesday October 20, 2020 15:30 - 16:00 EDT
Online

Cloud

Difficulty Intermediate
Speaker Location USA

16:00 EDT

Full Observability for Application Monitoring

Traditional APMs are great at helping troubleshoot custom app performance until problems start to reside within the database. Databases continue to be black boxes to most APMs and, therefore, black boxes to the developers and teams using them. To gain full observability, you need to look at the application and associated apparition and services from the database point of view. Only then will you be able to find the root cause of performance issues. Learn how teams can start with high-level application performance monitoring and drill layers deep into database and query performance.
During this session, we’ll learn:

How to troubleshoot and trace application issues down to the database
How to tune databases and queries for better performance
How infrastructure can impact database performance
How new code affects database workload and query performance

Speakers

Markus Strauss

Senior Product Manager, SolarWinds

Markus Strauss is a senior product manager at SolarWinds, helping drive the future of the SolarWinds® Database Performance Monitor (DPM) product. He’s a seasoned professional with 20 years of experience in risk management, cybersecurity, and performance monitoring. Prior to SolarWinds... Read More →

Hosts

Matthew Boehm

Senior Instructor / Senior Architect, Percona

Slides Markus Strauss pptx

Tuesday October 20, 2020 16:00 - 16:30 EDT
Online

Observability, Application Development

Difficulty Advanced
Speaker Location USA

16:30 EDT

Power Hour, Managing Databases at Scale - Percona

Power Hour on Managing Databases at Scale will give 3 companies 20 minutes each to present their stances on managing databases at scale using Cloud, a hybrid environment, and also Kubernetes and Operators. Percona, Nutanix, and AWS will be present.

Speakers

Peter Zaitsev

CEO, Percona

PZ PLO Oct2020 Managing Databases at Scale Percona pptx

Tuesday October 20, 2020 16:30 - 16:50 EDT
Online

Cloud

16:50 EDT

Power Hour, Managing Databases at Scale - Nutanix

Speakers

Bala Kuchibhotla

SVP, GM - Era & Business Critical Apps, Nutanix

Bala Kuchibhotla is SVP, GM - Era & Business Critical Apps. He leads product strategy, engineering, GTM for Database-as-a-Service platform and solutions for business critical apps at Nutanix. Prior to Nutanix, He was Architect, Vice President at Oracle where he led Oracle DB private... Read More →

Nutanix Era Percona Conference pdf

Tuesday October 20, 2020 16:50 - 17:10 EDT
Online

Cloud

Difficulty Intermediate
Speaker Location USA

17:10 EDT

Power Hour, Managing Databases at Scale - AWS

Speakers

Sirish Chandrasekaran

General Manager of Amazon Relational Database Service, Amazon Web Services

Sirish joined Amazon in 2016 and held various engineering and product responsibilities across AmazonAurora and Amazon RDS before taking on his current role as GM of Amazon RDS. Prior to joiningAmazon, Sirish was an executive at Dropbox, where he held various roles focused on their... Read More →

20201020 Managing DBs at Scale in Cloud AWS pdf

Tuesday October 20, 2020 17:10 - 17:30 EDT
Online

Cloud

Difficulty Intermediate
Speaker Location USA

17:30 EDT

The "411" on PMM

Percona Monitoring and Management (PMM) is the premier application on the market to monitor your open source database environment. Deploy PMM to:

Monitor your databases
Alert you based on your communication preference when an issue arises
Leverage diagnostic and troubleshooting tools to identify the root cause of the issue
Engage PMM's management tools to remedy and maintain your database environment

PMM is an on-premises, server installed application completely open source without licensing fees.
Within this session, Percona's PMM team will highlight and demonstrate the latest feature and functionality.

Speakers

Brandon Fleisher

Senior Outbound Product Manager, Percona

While new to Percona in 2020, Brandon brings a wealth of skills and experience to the software Product Management discipline shepherding over 20 products through the Product lifecycle in the last 18+ years for companies in a variety of industry verticals. Brandon also spent 10 years... Read More →

Steve Hoffman

SVP, Engineering in Eng-Platform, Percona

A lifelong technologist, Steve got his start in high performance, high availability computing while in college at Penn State. As his career in technology progressed through programming and systems engineering, he made the transition into leadership and has never looked back. His... Read More →

Hosts

Michael Coburn

Principal Architect, Percona

Michael joined Percona as a Consultant in 2012 after having worked with high volume stock photography websites and email service provider platforms. With a foundation in Systems Administration, Michael acted as Product Manager responsible for Percona Monitoring and Management (PMM... Read More →

Slides Brandon Fleisher & Steve Hoffman pptx

Tuesday October 20, 2020 17:30 - 18:00 EDT
Online

Monitoring

Difficulty Intermediate
Speaker Location USA

18:00 EDT

Analytical Queries in MySQL

MySQL's sweet spot is known to be online transaction processing (OLTP), and it can support a very high load of short transactions. Many users will also want to run analytical queries (OLAP) on their MySQL data. Often they achieve this by exporting their data to another database system that is tailored for analytical queries. However, this introduces overhead and delay that can be avoided by running your analytical queries directly in your MySQL database.

This presentation will discuss how you can tune your complex analytical queries to achieve better performance with MySQL. We will look at some of the queries from the well-known TPC-H/DBT-3 benchmark, and show how we can improve the performance of these queries through query rewrites, optimizer hints, and improved configuration settings. We will also compare the performance of these queries to other database systems like MariaDB and PostgreSQL, and discuss how MySQL could be improved to better support these queries.

Further Information
While this presentation will mainly focus on MySQL, we will also compare with MariaDB and Postgres and discuss what causes the difference in performance between the systems.

Speakers

Øystein Grøvlen

Senior Staff Engineer, Alibaba

Øystein Grøvlen is a Senior Staff Engineer in Alibaba Cloud, where he works in the Database Products Group.Before joining Alibaba, Øystein worked for 10 years in the MySQL optimizer team at Sun/Oracle. At Sun Microsystems, he was also a contributor on the Apache Derby project and... Read More →

Hosts

Michael Coburn

Principal Architect, Percona

Slides Øystein Grøvlen pdf

Tuesday October 20, 2020 18:00 - 18:30 EDT
Online

MySQL, Application Development

Difficulty Advanced
Core Technology MySQL
Why this level of difficulty? Query optimization is in itself a pretty advanced topic, and I think many advanced users at Perconal Live will appreciate a presentation that increase their knowledge about optimization topics.
Speaker Location USA

18:30 EDT

How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster

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. This adds complexity when you need to change the schema of the database.

Changes made by DDL may affect the results of the queries. Therefore all modifications must replicate on all nodes prior to the next data access. For operations that run momentarily, it can be easily achieved, but schema changes may take hours to apply. Therefore in addition to the safest synchronous blocking schema upgrade method: TOI, - PXC supports more relaxed, though not safe, method RSU.

RSU: Rolling Schema Upgrade is advertised to be non-blocking. But you still need to take care of updates, running while you are performing such an upgrade. Surprisingly, even updates on not related tables and schema can cause RSU operation to fail.

In this talk, I will uncover nuances of PXC schema upgrades and point to details you need to take special care about.

Further Information
Schema change is a frequent task, and many do not expect any surprises with it. However, the necessity to replay the changes to all synchronized nodes adds complexity. I made a webinar on a similar topic which was recorded and available for replay. Now I have found that I share a link to the webinar to my Support customers approximately once per week. Not having a good understanding of how schema change works in the cluster leads to lockups and operation failures. This talk will provide a checklist that will help to choose the best schema change method.

Speakers

Sveta Smirnova

Principal Support Engineering Coordinator, Percona

Sveta Smirnova is a MySQL Support Engineer with over 10 years of experience. She currently works in Percona. Her main professional interests are problem-solving, working with tricky issues, bugs, finding patterns that can solve typical issues quicker, teaching others how to deal with... Read More →

Hosts

Tim Sharp

Product Manager, Percona

Slides Sveta Smirnova pdf

Tuesday October 20, 2020 18:30 - 19:00 EDT
Online

MySQL

Difficulty Advanced, Entry Level
Speaker Location USA

19:00 EDT

From Containers to Kubernetes Operators

"Containers are the new ZIP format to distribute software" is a fitting description of today's development world. However, it is not always that easy and this talk highlights the development of a container strategy for datastores over time:

Docker images: A new distribution model.
Docker Compose: Local demos and a little more.
Helm Chart: Going from demo to production.
Kubernetes Operator: Full control with upgrades, scaling,...

Besides the strategy, we are also discussing specific technical details and hurdles that appeared during the development. Or why the future will be a combination of Helm Chart and Operator (for now).

Speakers

Philipp Krenn

Developer Advocate, Elastic

Philipp lives to demo interesting technology. Having worked as a web, infrastructure, and database engineer for more than ten years, Philipp is now working as a developer advocate at Elastic â€” the company behind the open source Elastic Stack consisting of

Hosts

Tim Sharp

Product Manager, Percona

Tuesday October 20, 2020 19:00 - 20:00 EDT
Online

Cool New Technologies

Difficulty Intermediate
Core Technology Kubernetes
Speaker Location Austria

20:00 EDT

MySQL Ecosystem on ARM

The ARM ecosystem is quickly evolving as a cost-effective alternative to run High-Performance Computing (HPC) software. It continues to grow with some major cloud players hosting ARM-based cloud servers.
MySQL too joined the ecosystem with 8.x. MariaDB already has made its presence. But besides the mainline server, a lot of tools are yet to get ported to ARM.

In this talk, we will explore what all aspects of the MySQL ecosystem are part of ARM, work in progress, optimization being done for ARM, challenges involved, Is it safe to run MySQL (or its variant) on ARM?, community and industry support, performance aspect (especially with x86_64), etc...

Speakers

Krunal Bauskar

Engineer, Huawei

Krunal Bauskar has been actively working in the MySQL space for over a decade. He is currently driving the adoption of the ARM ecosystem for MySQL/MariaDB/Percona through his #mysqlonarm initiative working at Huawei. In the past he has worked on multiple MySQL projects viz. undo log... Read More →

Hosts

Mike Grayson

MongoDB Database Engineer, Percona

Mike Grayson is a MongoDB Database Enginer at Percona, the unbiased open source database experts. Mike has been involved in many aspects of the MongoDB community since he started using the database in 2014. Heading the Western NY MongoDB User Group, blogging and being involved in... Read More →

Slides Krunal Bauskar pdf

Tuesday October 20, 2020 20:00 - 20:30 EDT
Online

MySQL

Difficulty Advanced, Intermediate
Why this level of difficulty? We plan to talk about MySQL ecosystem and so talk presume audience are aware of some basic background of ecosystem and tools in use.
Speaker Location India

20:30 EDT

How Does Geo-Replication Work in TiDB?

It's very challenging to support high availability and consistency in cross data center deployment. TiDB is a distributed HTAP database that speaks MySQL protocols. This talk will introduce how TiDB solves the problem by some unique designs based on Raft, and how those designs make TiDB run fast and cheap in these scenarios.

Speakers

Jay Lee

Senior Engineer, PingCAP

Jay Lee is a TiKV maintainer, a distributed system expert, and the author of open source projects grpc-rs, raft-rs, etc.

Hosts

Mike Grayson

MongoDB Database Engineer, Percona

How Does Geo replication Work in TiDB pdf

Tuesday October 20, 2020 20:30 - 21:00 EDT
Online

High Avaliability

Difficulty Advanced, Entry Level
Speaker Location China

21:00 EDT

SQL Row Store vs Data Warehouse: Which Is Right for Your Application?

MySQL and PostgreSQL are the goto SQL databases for a huge number of services. But what if your service generates billions or even trillions of records? This talk helps listeners decide when applications work better with a SQL data warehouse.

Using MySQL and ClickHouse as examples, we'll work through use cases like transaction processing and computation of aggregates to see where each shines. Along the way we'll explore key technical differences:

row vs. column storage
query parallelization
sharding and replication
concurrency support
transaction models

Finally, we'll discuss how to handle use cases that require the capabilities of both. Listeners will leave with clear criteria and a deeper understanding of database internals that enable them to make the right choice(s) for their own use cases.

Speakers

Robert Hodges

CEO, Altinity

Robert Hodges is CEO of Altinity, an enterprise provider for ClickHouse data warehouse. He's also a database geek with experience on at least 20 DBMS types. Robert caught the Kubernetes bug at VMware in 2018.

Hosts

Travis Futas

Senior Compliance Manager, Percona

Travis is an in-house attorney that manages Percona's privacy and compliance practices. His background is in technology and commercial law, with an emphasis on information security, privacy, and healthcare compliance. Outside of Percona, Travis sits on the board of a private organization... Read More →

Slides Robert Hodges pdf

Tuesday October 20, 2020 21:00 - 21:30 EDT
Online

MySQL, Application Development

Difficulty Entry Level
Why this level of difficulty? It's important to have introductory materials that help application developers make sane choices about technology. Hope this is successful.
Speaker Location USA

21:30 EDT

Introducing Kunlun Distributed Database Cluster

Kunlun Distributed Database Cluster is a distributed DBMS that aims to combine the best of both MySQL and PostgreSQL to meet the challenges of an ever-growing amount of data to manage and provide users with a highly performant, highly available, highly scalable and fault-tolerant, easy to use and manage database system that requires minimal human maintenance.

Kunlun Distributed Database Cluster enables users to define table sharding rules so that it automatically distributes tablets properly to available storage shards. We implemented the two-phase commit protocol to do distributed transaction commit; We use MySQL group replication for high availability in storage shards. We fixed a series of MySQL XA bugs to make Kunlun's distributed transaction processing highly reliable. We modified PostgreSQL to do far more than its FDW capabilities --- we implemented not only the global transaction coordinator but also concurrent asynchronous communication with MySQL storage shards and enhanced its query processing for best performance when accessing remote data in storage shards. Also, we implemented reliable DDL synchronization among multiple computing nodes of a cluster, the benefit is that all computing nodes have consistent metadata stored locally so that they can do query processing accurately with the best performance.

Come and see:

Kunlun design and architecture, key features, performance metrics, and how&why Kunlun can make the use of MySQL-8.0 group replication convenient and easy.
What issues exist with MySQL-8.0 XA transaction processing and how they are fixed in Kunlun Distributed Database Cluster, besides performance enhancements to MySQL-8.0.
How distributed query optimization in Kunlun makes queries performant and minimizes distribute query execution costs.
How dynamic table sharding distributes tablets properly as more storage shards are added to the cluster.
How global deadlocks come into being and how they are detected and resolved.
How DDL statements are synchronized among all computing nodes of a Kunlun cluster and how to make the synchronization fault-tolerant and reliable.

Speakers

David Zhao

database systems expert, zettadb

Zhao Wei (David Zhao) has been working on database kernels throughout his career. He worked on Oracle Berkeley DB and MySQL in the two outstanding global teams in Oracle during 2007 and 2015, and he worked in Tencent to upgrade its TDSQL from a table sharding solution to a full-fledged... Read More →

Hosts

Travis Futas

Senior Compliance Manager, Percona

Slides David Zhao pdf

Tuesday October 20, 2020 21:30 - 22:00 EDT
Online

Cool New Technologies, MySQL

Difficulty Intermediate
Core Technology MySQL
Why this level of difficulty? I want more people to know about Kunlun distributed database and the technologies behind it. People will grasp some of all of the session based on their existing knowledge to DBMS, mysql and/or postgresql.
Speaker Location China

22:00 EDT

How to Protect the SQL Engine From Running Out of Memory

Running a SQL usually requires the database to allocate working memory to the process that executes a SQL. However, the uncontrolled size of the input data source or the intermediate data generated by calculation may trigger an Out of Memory (OOM) crash. Thus, the memory management mechanism of the computing layer is necessary.

In this talk, we will introduce how we prevented the database, taking TiDB as an example, from the OOM crash caused by excessive memory consumption during a calculation, such as disk spilling and adaptive adjustment.)

Speakers

Huaiyu Xu

Research and Develop Engineer, PingCAP

Huaiyu Xu is an engineer at PingCAP, responsible for the development of TiDB SQL Engine.

Song Gao

Infrastructure Engineer, PingCAP

Song Gao is an engineer at PingCAP, responsible for the development of TiDB Scheduling. He is passionate about cloud-native and open-source technologies.

Hosts

Ann Schlemmer

CEO, Percona

Ann is a seasoned leader & advocate for open source with over 15 years experience in open source. CEO of Percona, a world-class open source database software firm, she is driven by passion for people & belief in open source's power to create an inclusive tech industry. Her authenticity... Read More →

How to Protect the SQL Engine From Running Out of Memory pdf

Tuesday October 20, 2020 22:00 - 22:30 EDT
Online

MySQL

Difficulty Intermediate
Speaker Location China

22:30 EDT

The MySQL Ecosystem Comparison

MySQL is unique in many ways. It supports plugins. It supports storage engines. It has been around for 25 years. It is owned by Oracle, thus birthing a popular branch in Percona Server for MySQL and a popular fork in MariaDB Server. You're a busy DBA having to maintain a mix of this. Or you're a CIO planning to choose one branch/fork. How do you go about picking? How do you go about supporting multiple databases? Find out more in this talk.
The ecosystem is now beyond just a comparison between MySQL 8, Percona Server for MySQL 8 and MariaDB Server 10.5. The ecosystem itself includes other tools, e.g. proxies like MySQL Router, ProxySQL, and MariaDB MaxScale. We should also throw into the mix High Availability solutions like group replication, but also the many variants of Galera Cluster: Percona XtraDB Cluster (PXC), MariaDB Galera Cluster and upstream.
In addition to the server deep-dive as to what feature differences exist between MySQL/Percona Server/MariaDB Server, the ecosystem tools as a whole are covered as well. Within 50 minutes, you'll leave informed and hopefully more knowledgable on what to pick.
This is the comparison talk you want to go for! It is in-depth, highly technical, and very tabular. And it comes from an independent 3rd party who has experience with all of the servers.

Speakers

Colin Charles

Consultant, codership (galera cluster)

Colin Charles is a Consultant at Codership, the makers of Galera Cluster. Previously, Colin was on the founding team of MariaDB Server, and has been around the MySQL ecosystem including being an early employee at MySQL, and worked actively on the Fedora and OpenOffice.org projects... Read More →

Hosts

Ann Schlemmer

CEO, Percona

The MySQL Ecosystem Comparison pdf

Tuesday October 20, 2020 22:30 - 23:00 EDT
Online

MySQL

Difficulty Intermediate
Core Technology MySQL
Why this level of difficulty? It is an entry level comparison but an intermediate talk because you are better off knowing stuff as we can't explain in time, the differences with JSON or CTE implementations
Speaker Location Malaysia

23:00 EDT

pg_stat_monitor: A cool extension for better monitoring using PMM

pg_stat_monitor is a statistics collection tool authored by Percona and contributed to the community. It is based on pg_stat_statements, an existing PostgreSQL contrib module. The major shortcoming in pg_stat_statements is that it accumulates all the queries and their statistics but does not provide aggregated statistics nor histogram information. In this case, a user needs to calculate the aggregate, which is quite expensive. pg_stat_monitor provides the pre-calculated aggregates.
pg_stat_monitor collects and aggregates data on a bucket basis. The size and number of buckets is configured using GUC (Grand Unified Configuration). The buckets are used to collect the statistics and aggregate them into a bucket. This talk covers the usage of pg_stat_monitor and how it is an improvement on pg_stat_statements.
pg_stat_monitor is added to Percona Monitoring and Management to collect query metrics. This provides users the ability to see examples instead of fingerprints. pg_stat_monitor provides more accurate data because of bucket based logic. Also, collecting data from pg_stat_monitor provides better performance than pg_stat_statements.

Speakers

Ibrar Ahmed

Sr. Software Architect, Percona

Ibrar Ahmed is a Software Architect in Percona LLC. Prior to coming to open source development, he had vast experience in software design and development. His main focus was on system-level embedded development. After joining EnterpriseDB in 2006, an Enterprise PostgreSQL company... Read More →

Nurlan Moldomurov

Software Engineer, Percona

Hosts

Ann Schlemmer

CEO, Percona

Slides Ibrar Ahmed & Nurlan Moldomu pptx

Tuesday October 20, 2020 23:00 - 23:30 EDT
Online

PostgreSQL

Speaker Location Pakistand & Kyrgystan

23:30 EDT

PostgreSQL WAL and Commit Synchronization, Optimization Opportunities

PostgreSQL uses different types of WAL records for recording activities happening on the database. A deeper understanding of what they are, how they are synchronized, what the optimization opportunities are, etc., can lead to a better-tuned system.

This talk also discusses the different sets of PostgreSQL parameters and their impact on WAL and optimization considerations for a high-performance database.

This talk covers:

What the WAL records are
Synchronization considerations
What is important from the host IO subsystem
Parameters for tuning
Different levels of tuning, Instance, Database, User, Session, and Transaction,
and how it impacts performance.
WAL Propagation to standby
Synchronous standby, important points to be considered
Remote write, flush, and replay stages.

This talk also includes small code snippets, demonstrations, and efficiency comparisons.

Speakers

Jobin Augustine

PostgreSQL Escalation Specialist, Percona

Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 19 years of working experience as consultant, architect, administrator, writer, and trainer in PostgreSQL, Oracle and other database technologies. He has always been an active participant in the Open... Read More →

Hosts

Mukesh Kumar

MongoDB DBA, Percona

Slides Jobin Augustine pdf

Tuesday October 20, 2020 23:30 - Wednesday October 21, 2020 00:00 EDT
Online

PostgreSQL

Difficulty Advanced
Why this level of difficulty? This talk can be beneficial to Intermediate as well as advanced users.
Speaker Location India

00:00 EDT

MariaDB 10.5 New Features for Troubleshooting

The recently released MariaDB 10.5 GA includes many new useful features, but I'd like to concentrate on those helping DBAs and Support engineers to find out what's going on when some problem happens. Specifically, I'd like to present and discuss Performance Schema updates to match MySQL 5.7 instrumentation, new tables in the INFORMATION_SCHEMA to monitor the internals of a generic thread pool, and improvements of ANALYZE for statements.

MariaDB 10.5 Enterprise may add more troubleshooting features, especially for Galera, and assuming this really happens they are also going to be presented briefly.

The goal of this session is to show new ways to understand solving performance problems now available in MariaDB 10.5.

Speakers

Valerii Kravchuk

Principal Support Engineer, MariaDB Corporation

Valerii Kravchuk helps MySQL and MariaDB users and DBAs to resolve their problems since 2005. Worked in MySQL AB, Sun, Oracle, Percona and, since 2016, in MariaDB Corporation. MySQL Community Contributor of the year 2019.

Hosts

Mukesh Kumar

MongoDB DBA, Percona

Slides Valerii Kravchuk pdf

Wednesday October 21, 2020 00:00 - 01:00 EDT
Online

MariaDB

Difficulty Advanced, Intermediate
Core Technology MariaDB
Why this level of difficulty? I expect attendees to have some experience in troubleshooting and performance tunings, maybe more with MySQL than MariaDB. They will see old MySQL tricks that finally can be applied and totally new insights into server internals.
Speaker Location Ukraine

01:00 EDT

Boosting MySQL Performance

Discover the basic tips and tricks on how to build your MySQL schemas so you don't get caught up in early performance problems. Learn how to select your tables data types and what performance implications they have. Review how indexing works, as well as basic indexing tips and tricks. A healthy schema is one of the first steps to having a performant database.

Speakers

Jose Luis Martinez

Chief Cloud Officer, Voovio Technologies

I'm a specialist in Cloud Architectures with a strong knowledge of AWS (Amazon Web Services), currently holding 5 AWS Certifications.I have a strong background in:Web development and technologiesMySQL / Relational DatabasesNoSQL databasesMonitoring infrastructureE-mail solutionsProgramming... Read More →

Hosts

Mukesh Kumar

MongoDB DBA, Percona

Boosting MySQL Performance pdf

Wednesday October 21, 2020 01:00 - 02:00 EDT
Online

MySQL

Difficulty Intermediate
Why this level of difficulty? I doubt between Entry and Intermediate. I chose intermediate because I've exposed this to people that work day to day with MySQL and don't know about this topic.
Speaker Location Spain

02:00 EDT

Best Practice in Design and Implementing MySQL Geographic Distributed, High Availability Solutions

Nowadays implementing different grades of business continuity for the data layer storage is a common requirement. When designing architectures that include MySQL as a data layer, we have different options to cover the required target. Nevertheless we still see a lot of confusion when in the need to properly cover concepts such as High Availability and Disaster Recovery. Confusion that often leads to improper architecture design and wrong solution implementation. This presentation aims to remove that confusion and provide clear guidelines when in the need to design a robust, flexible resilient architecture for your data layer.

Speakers

MarcoTusa

Technical Leader MySQL, Percona

Marco Tusa had his own international practice for the past twenty-eight years. His experience and expertise are in a wide variety of information technology and information management fields, covering research, development, analysis, quality control, project management and team management... Read More →

Hosts

Evgeniy Patlan

Sr. Build / Release Engineer, Percona

Slides Marco Tusa pdf

Wednesday October 21, 2020 02:00 - 02:30 EDT
Online

MySQL

Difficulty Intermediate
Speaker Location Italy

02:30 EDT

Vitess Online Schema Migration Automation

For many, running an online schema migration operation is still a manual job: from building the correct command, through identifying where the migration should run and which servers are to be affected, to auditing progress and completing the migration. Sharded environment poses an additional burden, as any logical migration must be applied multiple times, once for each shard.

What if you could just issue an ALTER TABLE ... statement, and have all that complexity automated away?
Vitess, an open source sharding framework for MySQL, is in a unique position to do just that. This session shows how Vitess's proxy/agent/topology architecture, together with gh-ost, are used to hide schema change complexity, and carefully schedule and apply schema migrations.

Speakers

Shlomi Noach

Engineer, PlanetScale

Engineer and database geek, works at PlanetScale as a maintainer for open source Vitess. Previously at GitHub. Interested in database infrastructure solutions such as high availability, reliability, enablement, automation and testing. Shlomi is an active MySQL community member, authors... Read More →

Hosts

Evgeniy Patlan

Sr. Build / Release Engineer, Percona

Shlomi Noach PLEU2020 Vitess online schema migration automation pdf

Wednesday October 21, 2020 02:30 - 03:00 EDT
Online

MySQL

Difficulty Intermediate
Why this level of difficulty? The session will appeal to people who have experiences the pains of running schema migrations. However, it is not too deep technically (e.g. no source code analysis involved).
Speaker Location Israel

03:00 EDT

Security and Traceability on Distributed Database Systems

Managing a single PostgreSQL instance can be challenging when failures happen. Replicas can be added and promoted when needed. However, application traffic has to be redirected to the new primary. At OVHcloud, a major cloud computing provider in Europe, we use load balancers in front of our databases clusters on production. In that case, PostgreSQL sees then all client connections coming from those IP addresses. That means we couldn't base the pg_hba.conf settings on source IP addresses. That also means, in the logs, all slow queries, DDL queries, connections and disconnections are obfuscated. In a world where where security and traceability is a strong requirement for PCI DSS compliant infrastructures, we had to find a solution. This talk will present you our findings and how we could implement transparent load balancing in a distributed database system.

Speakers

Julien Riou

Tech Lead, OVHcloud

DBA since 2012 in the web hosting world. Open source DBMS specialist (PostgreSQL, MySQL). Currently Tech Lead in the databases team at OVHcloud, a major Cloud Computing provider in Europe.

Hosts

Filip Hanaczewski

DBA Manager, Percona

Slides Julien Riou pdf

Wednesday October 21, 2020 03:00 - 03:30 EDT
Online

PostgreSQL

Difficulty Intermediate
Speaker Location Belgium

03:30 EDT

DBdeployer, the Community Edition

DBdeployer, an open source tool that allows easy deployment of many MySQL/Percona servers in the same host, has passed two years of development. Its latest additions have aimed at improving ease of use for both beginners and experts.

This talk will show how to start with dbdeployer with an empty box, and quickly populate it with recent and less recent server versions, all at the command line.

Speakers

Giuseppe Maxia

Software Explorer and creator of tools, vmware

Formerly at MySQL AB, and then through acquisitions at Sun Microsystems and Oracle, and currently at Formerly at MySQL AB, and then through acquisitions at Sun Microsystems and Oracle, and currently at VMware through a merge. I am active member of the MySQL community and long timer... Read More →

Hosts

Filip Hanaczewski

DBA Manager, Percona

Slides Giuseppe Maxia pdf

Wednesday October 21, 2020 03:30 - 04:00 EDT
Online

Cool New Technologies, Deployment

Difficulty Intermediate
Speaker Location Spain

04:00 EDT

SELinux Fun With MySQL and Friends

SELinux (Security Enhanced Linux) provides an enhanced security mechanism for more advanced access control and auditing. It allows your application software and your system users to only access the resources it's been preconfigured to allow. Of course, when you want to move your data- or log files to a non-standard location these policies will stop your database from starting.

The easy way out is obviously to set SELinux to disabled or permissive. But someone once said: "Every time you disable SELinux a kitten dies". We'll show you a few ways how you can find out if it actually is SELinux that is blocking you and how to update the policies to properly keep your system secured.

Speakers

Matthias Crauwels

Principal Consultant, Pythian Services Inc

Since the age of 10 I’ve always been passionate about computers. I’ve been working with them ever since. In 2005 I got my degree in computer science. I used to work at a major Belgian university where I was developing e-learning applications. In that position, I was the one who... Read More →

Hosts

Michal Nosek

Enterprise Architect, Percona

During ten years of his career, Michal took different roles from a software engineer and business analyst to a technical sales consultant, always staying close to the technology. He has hands-on experience with a broad range of programming languages and database technologies in different... Read More →

SELinux fun with MySQL and friends pdf

Wednesday October 21, 2020 04:00 - 04:30 EDT
Online

Security & Compliance

Difficulty Intermediate
about Since the age of 10 I’ve always been passionate about computers. I’ve been working with them ever since. In 2005 I got my degree in computer science. I used to work at a major Belgian university where I was developing the e-learning applications. In that position, I was the one who looked after the databases. From there on I grew to be their MySQL DBA. In 2017 I left the university and joined Pythian as a MySQL Database Consultant. Currently I am a Lead Database Consultant in one of Pythian’s MySQL teams.
Why this level of difficulty? some linux knowledge is required

04:30 EDT

Serverless Databases: The Good, the Bad, and the Ugly

Starting with AWS, the major cloud providers offer different options to run a MySQL or a MySQL-compatible database on the cloud. A new approach is to rely on so-called serverless (relational) databases like Aurora Serverless that offer both traditional TCP connections and HTTP API access. Can serverless really be the future? Can data API really replace a MySQL connector? What are the major limitations of a serverless database cluster and do they really protect from inefficient use of database resources?

Speakers

Renato Losio

Principal Cloud Architect, Funambol

Renato is the Principal Cloud Architect at Funambol and an AWS Data Hero. He has over 15 years of experience as a software engineer, tech lead, and cloud architect across Italy, the UK, Portugal, and Germany. His main working interests include location-based services, relational... Read More →

Hosts

Michal Nosek

Enterprise Architect, Percona

Serverless Databases The Good, the Bad, and the Ugly pptx

Wednesday October 21, 2020 04:30 - 05:00 EDT
Online

Cloud

Difficulty Entry Level
Speaker Location Germany

05:00 EDT

MySQL 8.0 Document Store - Discovery of a New World

MySQL Document Store enables us to work with SQL relational tables and schema-less JSON collections. So instead of having a mixed bag of databases, you can just rely on MySQL, where the JSON documents can be stored in collections and managed with CRUD operations. All you need to do is install the X plugin. In this session, you will learn what a document store is, how to install and use it, and all the reasons for considering it. We will also see several specific features helping developers and illustrate how the usual MySQL DBA can manage this new world.

Speakers

Frederic Descamps

MySQL Community Manager, Oracle

'@lefred has been working with OpenSource and MySQL for more than 20 years. After graduating in Management Information Technology, Frédéric started his career as a developer for a big multinational company. He will then opt for a consultant role with one of the first Belgian start-ups... Read More →

Hosts

Martin James

VP of Sales (EMEA & APAC), Percona

Slides Frederic Descamps Discovery of a new world pdf

Wednesday October 21, 2020 05:00 - 05:30 EDT
Online

MySQL

Difficulty Entry Level
Speaker Location Belgium

05:30 EDT

Using MongoDB with Kafka - Use Cases and Best Practices

Kafka is a distributed event streaming platform that has become very popular in the past couple of years.
In a MongoDB-Kafka architecture, MongoDB may be configured as both a Sink and a Source. With sink we mean to ingest events from your Kafka topics directly into MongoDB collections, exposing the data to your services for efficient querying, enrichment, and analytics. With source we mean publish data changes from MongoDB into Kafka topics for streaming to consuming apps.

We are going to cover both scenarios (using MongoDB as Sink and Source), by demonstrating ways to efficiently connect each datastore to the other. At the same time, we will cover use-cases and best practices when using Kafka and MongoDB together.

Speakers

Antonios Giannopoulos

Senior Database Administrator, Rackspace Technology

I am working as Senior NoSQL Database Administrator at Rackspace supporting thousands of MongoDB installations over the past 7 years. I have 18 years experience in databases and system engineering. I really enjoy challenges in sharding and schema design and love migrations from Relational... Read More →

Pedro Albuquerque

Staff Database Engineer, Wise (former TransferWise)

I have many years of working in various database technologies, which include relational and NoSQL platforms. I am currently focused on MariaDB, MongoDB and PostgreSQL datastores at Wise. Previously to Wise, I was focused on MongoDB at ObjectRocket by Rackspace, supporting customers... Read More →

Hosts

Martin James

VP of Sales (EMEA & APAC), Percona

Slides Pedro Albuquerque pdf

Wednesday October 21, 2020 05:30 - 06:00 EDT
Online

MongoDB

Difficulty Intermediate
Speaker Location UK & Portugal

06:00 EDT

DIY DBaaS with Percona Kubernetes Operators

In this talk, I will review the features of Percona Kubernetes Operators: Percona XtraDB Cluster Operator and Percona Server for MongoDB Operator.

We developed operators to automate most routine procedures you need to set up and manage a database, either MySQL or MongoDB.

I will walk you through actions that you will get familiar with how to start with operators to make it running; how to connect an application from both inside or outside of Kubernetes; how to perform scaling up and down; how to adjust configuration; how to troubleshoot and how to backup your data. Pretty much we will overview the steps you need to set up your own Database-As-Service in-house.

Speakers

Vadim Tkachenko

CTO, Percona

Vadim Tkachenko co-founded Percona in 2006 and serves as its Chief Technology Officer. He leads Percona CTO Labs, which focuses on technology research and performance evaluations of Percona and third-party products, designing hardware, filesystems, storage engines, and databases that... Read More →

Hosts

Dimitri Vanoverbeke

Senior Solutions Engineer, Percona

As a young padwan, Dimitri was triggered into IT by an early adoption in BASIC, DOS, the early windows era, and early Linuxadoption. This made him aware of the numerous pitfalls, challenges and actual fun of working in IT.In his career, Dim0 has worked for emerging technology organisations... Read More →

VT DIY DBaaS with Percona Kubernetes Operators pptx

Wednesday October 21, 2020 06:00 - 06:30 EDT
Online

Cool New Technologies

Difficulty Intermediate
Speaker Location USA

06:30 EDT

In and Out of the Weeds With MongoDB 4.4 Hedged Reads

When the MongoDB 4.4 release came out over the summer, it brought along several new features designed to improve performance overall. One of these was introducing Hedged Reads to address latency issues. High latency is annoying to end-users – just ask us. But that annoyance can lead to lost revenues. So… anything that can be safely done to reduce latency must be great right? We’ll see!

I’ll take us down into the grass and talk about what Hedged Reads are, how to enable and disable them, associated read preferences, how it determines which nodes to query for the results, and more. Then we’ll take a look at some query differences when enabled vs disabled and the performance benefits that may help get your application out of the weeds. And I’ll also address a few gotchas that might make you reconsider how bad those weeds really were.

Hosts

Dimitri Vanoverbeke

Senior Solutions Engineer, Percona

Kimberly Wilkins

NoSQL Tech lead - MongoDB, Percona

Kimberly Wilkins is the MongoDB Technical Lead at Percona with 20+ years of experience managing and architecting databasesKimberly has been a Principal Engineer, a solutions architect, a manager, and a DBA. During those roles she has built out and managed expert database teams across... Read More →

Kimberly Wilkins In and Out of the Weeds with MongoDB 4 4 Hedged Reads PLO October 2020 final pdf

Wednesday October 21, 2020 06:30 - 07:00 EDT
Online

MongoDB

Difficulty Intermediate
Speaker Location USA

07:00 EDT

Sharding: DIY or Out of the Box Solution?

Once vertically scaling your databases can’t help you any further you need to think about sharding them. Sharding basically means you are going to distribute your (write) workload over multiple database hosts using an algorithm. For some open source databases, you get sharding out of the box, but for MySQL, you don’t. This means you either implement a sharding yourself and have absolute control over what data goes where or choose an out of the box solution like Vitess.

When MessageBird hit the limits on one of our cornerstone databases, we had to implement a sharding solution fast. With strong time constraints at hand, this meant we had to act fast and created our own sharding solution. Luckily we were able to reuse most of our existing infrastructure for this purpose. However, once it was time to shard another database, we took a step back and evaluated whether we should use our own solution once more or pick a sharding platform like Vitess.

In this talk, I’ll take you through the good, bad, and ugly of sharding, the choices you have to make, and the obstacles you can expect during your journey.

Speakers

Art van Scheppingen

Senior Database Engineer, MessageBird

Art van Scheppingen is a Senior Database Engineer at MessageBird with focus on database scalability and reliability. He's a pragmatic MySQL and Database expert with over 20 years experience in web development. He previously worked in various database architectural roles and as Senior... Read More →

Hosts

Dimitri Vanoverbeke

Senior Solutions Engineer, Percona

Art Percona Live October 2020 DIY Sharding vs Vitess final pdf

Wednesday October 21, 2020 07:00 - 07:30 EDT
Online

Other OSDB

Difficulty Advanced
Why this level of difficulty? Sharding is definitely not for the faint hearted and not even Vitess will solve that. ;)
Speaker Location Netherlands

07:30 EDT

The State of ProxySQL, 2020 Edition

ProxySQL is a high performance, high available, protocol aware proxy for MySQL. 2.0 has been GA for some time now, and there have been a lot of changes that come in point releases as well, such that you can benefit from them.

Listen to René, the founder of ProxySQL, take you through some of the new features in 2.0, and how you can effectively utilize them. Some topics that are covered include:
- LDAP authentication
- SSL for client connections
- AWS Aurora usage
- native clustering support for Percona XtraDB Cluster (PXC) / Galera Cluster / group replication
- Kubernetes deployments

This is the talk to take you from intermediate ProxySQL user to expert in the 2.0 feature set. There will also be talk about the roadmap for what is coming next.

Speakers

Rene Cannao

CEO, ProxySQL LLC

René has over 2 decades of experience as System, Network and Database Administrator, focusing mainly on MySQL. In this period he build an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance. From... Read More →

Hosts

Ali Ndlovu

Product Designer, Percona

Slides Rene Cannao pdf

Wednesday October 21, 2020 07:30 - 08:00 EDT
Online

MySQL

Speaker Location Malta

08:00 EDT

Between Toothpicks and Steel: Scaling for Real People

Most software engineers would make terrible civil engineers. A software engineer tasked with building a bridge in the middle of nowhere might say “I heard that the George Washington Bridge in NYC gets 103 million vehicles per year, what if my bridge got 104 million vehicles? The George Washington Bridge has the best practice!”

On the other end of the spectrum, you have the software engineer that built a model on their desktop and decided to just scale it up to a real-life bridge. After all, if toothpicks and school glue worked on a small scale, why can’t they work on a big scale?

In reality, most of us are building applications that operate squarely between the scale of one person on a laptop and the massive, FAANG company scale. This type of scale can be challenging as the real goal is to achieve a well-performing, stable system that stays in budget and on time.

In this talk, we’ll go over strategies to build a data layer that is responsive to deluges but not overbuilt. These strategies will focus on practical development, architecture, and infrastructure guidance that helps you separate the need from the want of designing a right-sized application. In addition, some stories will be told from the trenches of building both applications that refused to scale and those that were massively overbuilt.

Speakers

Kyle J Davis

Head of Developer Advocacy, Redis Labs

Kyle Davis is the Head of Developer Advocacy at Redis Labs. Before joining Redis Labs, he worked as an independent full-stack architect and code quality consultant. Kyle is the author of Redis Microservices for Dummies (Wiley) and has written extensively about developing with Redis.Kyle... Read More →

Hosts

Ali Ndlovu

Product Designer, Percona

Slides Kyle Davis pptx

Wednesday October 21, 2020 08:00 - 08:30 EDT
Online

Other OSDB

Difficulty Entry Level
Why this level of difficulty? This talk is mostly conceptual - technical details will be given in a way that will apply to a wide range of experience and skill levels.
Speaker Location USA

08:30 EDT

Building Data Lake with MariaDB ColumnStore

VirtualHealth empowers healthcare organizations to achieve enhanced outcomes while maximizing efficiency and lowering costs.

Among approaches providing customers with continuous access to their OLTP data, we evaluated a relational data lake approach that retains master data in its original form and format. Data scientists can access the data lake with many analytics tools supporting data consumption via MySQL clients such as ODBC and JDBC.
To reduce costs, we chose MariaDB ColumnStore taking advantage of its inherent data compression and S3 storage support. We present real-world analytics use cases and share lessons learned, such as:

Why the OLAP queries are slow in the OLTP environment?
What type of queries benefits most from the MariaDB ColumnStore architecture?
How to transfer OLTP data to the MariaDB ColumnStore?

Speakers

Sasha Vaniachine

MySQL Database Administrator, VirtualHealth

Sasha is a MySQL enthusiast experienced in troubleshooting and resolving scalability issues across the full software stack. In industry and academia, he scaled up data processing from terabytes to petabytes, while minimizing data losses below an acceptable level. Earlier in his career... Read More →

Hosts

Marcos Albe

Principal Support Engineer, Percona

After 12 years working as a developer for local and remote firms, Marcos decided to pursuit true love and become full time DBA, so he has been doing MySQL Support at Percona for the past 11+ years, providing lead web properties with advise on anything-MySQL and in-depth system performance... Read More →

Slides Sasha Vaniachine pdf

Wednesday October 21, 2020 08:30 - 09:00 EDT
Online

MariaDB

Difficulty Intermediate
Speaker Location USA

09:00 EDT

Achieving PCI Compliance With Percona Server for MongoDB, or Getting as Close as Possible

This talk will discuss the process and technical details of PCI compliance, and how these are implemented with Percona Server for MongoDB.

Regulatory compliance is high on the list of concerns for companies across multiple industry vertices, for many good reasons. We’ll discuss what compliance means, where responsibilities lie for providing a compliant environment and then provide a practical guided walkthrough on the journey of turning your Percona Server for MongoDB into a PCI compliant platform, or we’ll show you how to get it pretty close.

Speakers

Brian Walters

Director of Solution Engineering, Percona

Brian has over 20 years of experience in the database and technology space. He holds a Bachelor's degree in Organizational Leadership. Brian's career has included roles as Database Architect, Solutions Architect, Product Manager, and Pre-Sales Engineer. Brian spent 7 years at Teradata... Read More →

Travis Futas

Senior Compliance Manager, Percona

Hosts

Travis Futas

Senior Compliance Manager, Percona

Marcos Albe

Principal Support Engineer, Percona

Slides Travis and Brian pptx

Wednesday October 21, 2020 09:00 - 09:30 EDT
Online

MongoDB

Difficulty Intermediate
Why this level of difficulty? This talk will approach compliance as a prodcut of configuration. Therefore, the attendee is expected to have an introductory level understanding of how to configure MongoDB.
Speaker Location USA

09:30 EDT

Advanced Optimization and Troubleshooting MySQL Using PMM2

Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering your applications need to be able to handle changing traffic workloads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBA’s are also expected to find cost-efficient means of solving these issues. In this presentation, we will demonstrate the advanced options of PMM version 2 that enables you to solve these challenges, which is built on free and open-source software. We will look at specific, common MySQL problems and review them.

Speakers

Peter Zaitsev

CEO, Percona

Hosts

Kimberly Wilkins

NoSQL Tech lead - MongoDB, Percona

PZ PLO Oct2020 Advanced MySQL TroubleShooting Observability PMM pptx

Wednesday October 21, 2020 09:30 - 10:00 EDT
Online

MySQL

Difficulty Intermediate
Speaker Location USA

10:00 EDT

Panel: Running Databases in Containers

Speakers

Andrey Elenskiy

Software Engineer, Arista Networks

Gabriela Ferrara

Developer Advocate, Google

Deepthi Sigireddi

Software Engineer, PlanetScale

Shuan Deng

Senior Cloud Engineer, PingCAP

Yelei Wu

Software Engineer, PingCAP

Hosts

Rick Vasquez

Chief of Staff to CXO, Percona

Hands-on technical practitioner with real-world experience in some of the largest open source database deployments in the world. Translating technical and business requirements to the relevant groups is my passion.

Wednesday October 21, 2020 10:00 - 11:00 EDT
Online

Difficulty Advanced

11:00 EDT

Soar Higher With MariaDB SkySQL - The Ultimate MariaDB Cloud

SkySQL is the first and only database-as-a-service (DBaaS) to bring the full power of MariaDB Platform to the cloud, combining powerful enterprise features and world-class support with unrivaled ease of use and groundbreaking innovation. Built for mission-critical applications and enterprise governance, SkySQL augments automation with the human expertise and experience needed to support and manage mission-critical deployments in the cloud – whether it’s a single development database or thousands of production databases.

In this session you will learn about SkySQL and the underlying Kubernetes and cloud services that power it.

Speakers

Manjot Singh

Lead Enterprise Architect, MariaDB Corporation

Manjot Singh is Lead Enterprise Architect with MariaDB. He has been working with MySQL and MariaDB for 2 decades and has previously been a Systems Administrator, Database Administrator and Architect for Fortune 50 companies, government and well known consultancies such as Percona... Read More →

Tim Yim

VP Cloud Platform Operations, MariaDB

Tim Yim has over twenty years in technology building industry-leading cloud platforms. He is VP of cloud platform operations at MariaDB Corporation where he leads a team of engineers that built the ultimate MariaDB Cloud, SkySQL, from the ground up. Previously, Tim was director of... Read More →

Hosts

Kimberly Wilkins

NoSQL Tech lead - MongoDB, Percona

Slides Manjot Singh & Tim Yim pdf

Wednesday October 21, 2020 11:00 - 11:30 EDT
Online

Cloud

11:30 EDT

Databases on Kubernetes

As more companies are moving to kubernetes and cloud native as a standard for developing net new functionality something has to happen to the legacy workloads. Often times we see a lift and shift mentality into kubernetes, we will talk about how that mentality can be dangerous or cause more work than expected.

Speakers

Rick Vasquez

Chief of Staff to CXO, Percona

Slides Rick Vasquez pptx

Wednesday October 21, 2020 11:30 - 12:30 EDT
Online

Cool New Technologies

Core Technology Kubernetes
Speaker Location USA

12:30 EDT

PostgreSQL 13

PostgreSQL version 13 was released on September 24th. As usual, this new release comes with well over a hundred new features, both for existing users looking to upgrade and new users looking to build or migrate. In this keynote, we'll look at a few of the bigger ones, and what they can do.

Speakers

Magnus Hagander

PostgreSQL and Open Source Software Consultant, Redpill Linpro

Magnus Hagander is a member of the PostgreSQL Core Team and a developer and code committer in the PostgreSQL Global Development Group.Magnus is one of the original developers of the Windows port of PostgreSQL. These days, he mostly works on other parts of the PostgreSQL backend, recently... Read More →

Slides Magnus Hagander pdf

Wednesday October 21, 2020 12:30 - 13:00 EDT
Online

Keynote

13:00 EDT

The State of MongoDB, Its Open Source Community, and Where Percona Is Going With It

Join us at Percona Live Online for this keynote as we discuss the most recent release of MongoDB and some of its features that users are still most excited about. Then we will also discuss the direction of MongoDB and other NoSQL technologies and the impact to the Open Source Community as more vendors continue to push toward an all-on-one platform that many developers and CTO’s are beginning to see as Oracle of NoSQL technologies.
We will also talk about efforts at Percona to help potentially overcome that focus towards single vendor lock-in, how many customers are looking for other options, and how Percona has some existing tools with more in the pipeline that may help mitigate being pushed.

Speakers

Kimberly Wilkins

NoSQL Tech lead - MongoDB, Percona

Kimberly Wilkins State of MongoDB Open Source Community Where Percona Is Taking It PLO October 2020 final (1) pptx

Wednesday October 21, 2020 13:00 - 13:30 EDT
Online

Keynote

13:30 EDT

The State of The Dolphin

I will talk about the latest improvements in MySQL 8.0 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.

Speakers

Frederic Descamps

MySQL Community Manager, Oracle

Slides Frederic Descamps State of the Dolphin v4 pdf

Wednesday October 21, 2020 13:30 - 14:00 EDT
Online

Keynote