Loading…
Attending this event?

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Tuesday, October 20
 

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
avatar for Peter Zaitsev

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 →



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

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
avatar for Bruce Momjian

Bruce Momjian

Vice President, Postgres Evangelist, EnterpriseDB
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... Read More →



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

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
avatar for Karen Ambrose

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 →



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

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
avatar for Liz Fong-Jones

Liz Fong-Jones

Principal Developer Advocate, Honeycomb
Liz is a developer advocate, labor and ethics organizer, and Site Reliability Engineer (SRE) with 16+ years of experience. She is an advocate at Honeycomb.io for the SRE and Observability communities, and previously was an SRE working on products ranging from the Google Cloud Load... Read More →
avatar for Emily Gorcenski

Emily Gorcenski

Head of Data, ThoughtWorks Germany



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

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
avatar for Sugu Sougoumarane

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 →



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

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
avatar for Emily Gorcenski

Emily Gorcenski

Head of Data, ThoughtWorks Germany

Hosts
avatar for Alick Smith

Alick Smith

Manager, Professional Services, Percona


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

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
avatar for Gavin Mendel-Gleason

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
avatar for Alick Smith

Alick Smith

Manager, Professional Services, Percona



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

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
avatar for Jorge Torres

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. Prior to founding MindsDB, he worked for a number of data-intensive start-ups, most recently working with Aneesh Chopra (the first... Read More →

Hosts
avatar for Alick Smith

Alick Smith

Manager, Professional Services, Percona



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

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
avatar for Elisha Chitsenga

Elisha Chitsenga

Software Developer - Security and Compliance, Crestclove Advisors PLC
Elisha is a finance/software developer and speaker with vast experience and knowledge in cloud technologies, security and compliance at Crestclove Advisors. Crestclove Advisors is a youth based open source organization advocating for tech based solutions to African challenges through... Read More →

Hosts
avatar for Camila Arocena

Camila Arocena

HR Assistant, Percona



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
avatar for Tong Zhang

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 →
avatar for JB Baker

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
avatar for Camila Arocena

Camila Arocena

HR Assistant, Percona



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
avatar for Werner Keil

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 →
avatar for Thodoris Bais

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
avatar for Camila Arocena

Camila Arocena

HR Assistant, Percona


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

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
avatar for Kevin Jernigan

Kevin Jernigan

Principal Database Solution Architect, Amazon Aurora, Amazon Web Services

Hosts
avatar for Matthew Boehm

Matthew Boehm

Senior Instructor, Percona



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

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
avatar for Markus Strauss

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
avatar for Matthew Boehm

Matthew Boehm

Senior Instructor, Percona



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
avatar for Peter Zaitsev

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 →



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

16:50 EDT

Power Hour, Managing Databases at Scale - Nutanix
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
avatar for Bala Kuchibhotla

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 →



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

17:10 EDT

Power Hour, Managing Databases at Scale - AWS
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
avatar for Sirish Chandrasekaran

Sirish Chandrasekaran

General Manager, Amazon RDS for PostgreSQL, MySQL, and MariaDB, Amazon Web Services
Sirish Chandrasekaran leads engineering for Amazon RDS for PostgreSQL, MySQL, and MariaDB. With over 20 years of experience in database and storage technologies spanning academia, technology consulting, and running one of the largest database fleets in the world, Sirish brings a unique... Read More →



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

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
avatar for Brandon Fleisher

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 →
avatar for Steve Hoffman

Steve Hoffman

VP of Platform Engineering, 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 successes... Read More →

Hosts
avatar for Michael Coburn

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 the Product Manager responsible for Percona Monitoring and Management... Read More →



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

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
avatar for Øystein Grøvlen

Ø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
avatar for Michael Coburn

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 the Product Manager responsible for Percona Monitoring and Management... Read More →



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
avatar for Sveta Smirnova

Sveta Smirnova

Principal Support Escalation Specialist, 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 which can solve typical issues quicker,  teaching others how to deal... Read More →

Hosts
avatar for Tim Sharp

Tim Sharp

Product Manager, Percona



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

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
avatar for Philipp Krenn

Philipp Krenn

Developer, Elastic
Philipp lives to demo interesting technology. Having worked as a web, infrastructure, and database engineer for over ten years, Philipp is now a developer advocate and community team lead in EMEA at Elastic — the company behind the Elastic Stack consisting of Elasticsearch, Kibana... Read More →

Hosts
avatar for Tim Sharp

Tim Sharp

Product Manager, Percona


Tuesday October 20, 2020 19:00 - 20:00 EDT
Online
  Cool New Technologies

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
avatar for Krunal Bauskar

Krunal Bauskar

Technical Advisor, Huawei
Krunal has been actively working in MySQL space for more than a decade now. He is currently driving the adaption of the ARM ecosystem for MySQL/MariaDB/Percona through his #mysqlonarm initiative working at Huawei.In past he has worked on multiple MySQL projects viz. undo log truncate... Read More →

Hosts
avatar for Mike Grayson

Mike Grayson

MongoDB DBA, Percona



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
avatar for Jay Lee

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
avatar for Mike Grayson

Mike Grayson

MongoDB DBA, Percona



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

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
avatar for Robert Hodges

Robert Hodges

CEO, Altinity
Robert Hodges has worked with database systems since 1983, including 20 different DBMS types ranging from pre-relational systems like M204 to MySQL to analytic databases like ClickHouse. He is currently CEO of Altinity.

Hosts
avatar for Travis Futas

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 →



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:
  1. 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.
  2. 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.
  3. How distributed query optimization in Kunlun makes queries performant and minimizes distribute query execution costs.
  4. How dynamic table sharding distributes tablets properly as more storage shards are added to the cluster.
  5. How global deadlocks come into being and how they are detected and resolved.
  6. How DDL statements are synchronized among all computing nodes of a Kunlun cluster and how to make the synchronization fault-tolerant and reliable.

Speakers
avatar for David Zhao Wei

David Zhao Wei

Founder of Kunlun Distributed DBMS, Kunlun
Formerly worked in Oracle Berkeley DB and MySQL teams from 2007 to 2015 as database kernel developer;Since October 2015, worked in TDSQL team of Tencent as database kernel developer, took the initiative to design and implement the distributed transaction processing and distributed... Read More →

Hosts
avatar for Travis Futas

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 →



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
avatar for Huaiyu Xu

Huaiyu Xu

Research and Develop Engineer, PingCAP
Huaiyu Xu is an engineer at PingCAP, responsible for the development of TiDB SQL Engine.
avatar for Song Gao

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
avatar for Ann Schlemmer

Ann Schlemmer

General Manager, Percona



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

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
avatar for Colin Charles

Colin Charles

Consultant, GrokOpen
Colin Charles is the Managing Consultant at GrokOpen. Previously, Colin was on the founding team of MariaDB Server, worked at MySQL and Percona, and worked actively on the Fedora and OpenOffice.org projects. Colin has been a MySQL user since 2000. He’s well known within open source communities, enjoys building business and market entry in APAC and has spoken at many conferences... Read More →

Hosts
avatar for Ann Schlemmer

Ann Schlemmer

General Manager, Percona



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
avatar for Ibrar Ahmed

Ibrar Ahmed

Senior Database 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 the system level embedded development. After joining EnterpriseDB in 2006, an Enterprise PostgreSQL company... Read More →
avatar for Nurlan Moldomurov

Nurlan Moldomurov

Software Engineer, Percona

Hosts
avatar for Ann Schlemmer

Ann Schlemmer

General Manager, Percona



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:
  1. What the WAL records are
  2. Synchronization considerations
  3. What is important from the host IO subsystem
  4. Parameters for tuning
  5. Different levels of tuning, Instance, Database, User, Session, and Transaction,
    and how it impacts performance.
  6. WAL Propagation to standby
  7. Synchronous standby, important points to be considered
  8. Remote write, flush, and replay stages.
This talk also includes small code snippets, demonstrations, and efficiency comparisons.

Speakers
avatar for Jobin Augustine

Jobin Augustine

Senior Support Engineer, 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
avatar for Mukesh Kumar

Mukesh Kumar

MongoDB DBA, Percona



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
 
Wednesday, October 21
 

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
avatar for Valerii Kravchuk

Valerii Kravchuk

Principal Support Engineer, MariaDB Corporation
Valerii worked on complex MySQL and MariaDB troubleshoting performance issues since 2005, in MySQL AB. Sun, Oracle, Percona and, since 2016, MariaDB Corporation. Blogging about MySQL bugs and more since 2012 at http://mysqlentomologist.blogspot.com/. As a result, got a MySQL Community Contributor of the Year 2019 award... Read More →

Hosts
avatar for Mukesh Kumar

Mukesh Kumar

MongoDB DBA, Percona



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
avatar for Jose Luis Martinez

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
avatar for Mukesh Kumar

Mukesh Kumar

MongoDB DBA, Percona



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
avatar for Marco Tusa

Marco Tusa

MySQL Technical Leader, 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, cover research, development, analysis, quality control, project management and team management... Read More →

Hosts
avatar for Evgeniy Patlan

Evgeniy Patlan

Sr. Build / Release Engineer, Percona



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

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
avatar for Shlomi Noach

Shlomi Noach

Engineer, PlanetScale
Engineer and database geek, working at PlanetScale on both open source Vitess as well as PlanetScaleDB. Interested in database infrastructure solutions such as high availability, reliability, enablement, automation and testing.Shlomi is an active MySQL community member, authors orchestrator... Read More →

Hosts
avatar for Evgeniy Patlan

Evgeniy Patlan

Sr. Build / Release Engineer, Percona



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
avatar for Julien Riou

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
avatar for Filip Hanaczewski

Filip Hanaczewski

DBA Manager, Percona



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

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
avatar for Giuseppe Maxia

Giuseppe Maxia

Software Explorer, VMware
Software Explorer and creator of tools.Formerly at MySQL AB, and then through acquisitions at Sun Microsystems and Oracle, and currently at VMware through a merge.I am an active member of the MySQL community and long timer open source enthusiast. During the past decades, I have worked... Read More →

Hosts
avatar for Filip Hanaczewski

Filip Hanaczewski

DBA Manager, Percona



Wednesday October 21, 2020 03:30 - 04:00 EDT
Online
  Cool New Technologies, Deployment

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
avatar for Matthias Crauwels

Matthias Crauwels

Lead Database Consultant, Pythian
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... Read More →

Hosts
avatar for Michal Nosek

Michal Nosek

Senior Solutions Engineer, Percona



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
avatar for Renato Losio

Renato Losio

Principal Cloud Architect, Funambol
Renato Losio is a software and cloud architect, a digital nomad and an accidental speaker. He has many years of experience as a software engineer, tech lead and cloud services specialist in Italy, UK, Portugal and Germany. He currently lives in Berlin and works remotely as principal... Read More →

Hosts
avatar for Michal Nosek

Michal Nosek

Senior Solutions Engineer, Percona



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

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
avatar for Frédéric Descamps

Frédéric Descamps

MySQL Community Manager, Oracle
"@lefred" has been consulting OpenSource and MySQL for almost 20 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the... Read More →

Hosts
avatar for Martin James

Martin James

VP of Sales (EMEA & APAC), Percona



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

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
avatar for Antonios Giannopoulos

Antonios Giannopoulos

Senior Database Administrator, Rackspace
I am working as Senior NoSQL Database Administrator at Rackspace supporting thousands of MongoDB installations over the past 6 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 →
avatar for Pedro Albuquerque

Pedro Albuquerque

Senior Database Engineer, 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 TransferWise.Previously to Transferwise, I was focused on MongoDB at ObjectRocket by Rackspace, supporting... Read More →

Hosts
avatar for Martin James

Martin James

VP of Sales (EMEA & APAC), Percona



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

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
avatar for Vadim Tkachenko

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
avatar for Dimitri Vanoverbeke

Dimitri Vanoverbeke

Senior Solutions Engineer, Percona



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

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
avatar for Dimitri Vanoverbeke

Dimitri Vanoverbeke

Senior Solutions Engineer, Percona
avatar for Kimberly Wilkins

Kimberly Wilkins

MongoDB Tech Lead, Percona
Kimberly is the MongoDB Technical Lead at Percona where she oversees the general direction of MongoDB offerings across the Global Services Teams and cross-functional departments. She has "a few" years of experience helping customers get the best performance out of the MongoDB instances... Read More →



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

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
avatar for Art van Scheppingen

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
avatar for Dimitri Vanoverbeke

Dimitri Vanoverbeke

Senior Solutions Engineer, Percona



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
avatar for René Cannaò

René Cannaò

ProxySQL, CEO
René founded ProxySQL in 2016 after developing it since 2013. He has over 15 years of experience as Database Administrator mostly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle, Senior Operational DBA at Blackbird, and consulting for small and large companies like... Read More →

Hosts
avatar for Ali Ndlovu

Ali Ndlovu

Product Designer, Percona



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
avatar for Kyle J Davis

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
avatar for Ali Ndlovu

Ali Ndlovu

Product Designer, Percona



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
avatar for Sasha Vaniachine

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
avatar for Marcos Albe

Marcos Albe

Principal Support Engineer, Percona



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

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
avatar for Brian Walters

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 →
avatar for Travis Futas

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 →

Hosts
avatar for Travis Futas

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 →
avatar for Marcos Albe

Marcos Albe

Principal Support Engineer, Percona



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
avatar for Peter Zaitsev

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 →

Hosts
avatar for Kimberly Wilkins

Kimberly Wilkins

MongoDB Tech Lead, Percona
Kimberly is the MongoDB Technical Lead at Percona where she oversees the general direction of MongoDB offerings across the Global Services Teams and cross-functional departments. She has "a few" years of experience helping customers get the best performance out of the MongoDB instances... Read More →



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

10:00 EDT

Panel: Running Databases in Containers
Speakers
avatar for Andrey Elenskiy

Andrey Elenskiy

Software Engineer, Arista Networks
avatar for Gabriela Ferrara

Gabriela Ferrara

Developer Advocate, Google
avatar for Deepthi Sigireddi

Deepthi Sigireddi

Software Engineer, PlanetScale
avatar for Shuan Deng

Shuan Deng

Senior Cloud Engineer, PingCAP
avatar for Yelei Wu

Yelei Wu

Software Engineer, PingCAP

Hosts
avatar for Rick Vasquez

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

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
avatar for Manjot Singh

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 →
avatar for Tim Yim

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
avatar for Kimberly Wilkins

Kimberly Wilkins

MongoDB Tech Lead, Percona
Kimberly is the MongoDB Technical Lead at Percona where she oversees the general direction of MongoDB offerings across the Global Services Teams and cross-functional departments. She has "a few" years of experience helping customers get the best performance out of the MongoDB instances... Read More →



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

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
avatar for Rick Vasquez

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 11:30 - 12:30 EDT
Online
  Cool New Technologies

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
avatar for Magnus Hagander

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 →



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

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
avatar for Kimberly Wilkins

Kimberly Wilkins

MongoDB Tech Lead, Percona
Kimberly is the MongoDB Technical Lead at Percona where she oversees the general direction of MongoDB offerings across the Global Services Teams and cross-functional departments. She has "a few" years of experience helping customers get the best performance out of the MongoDB instances... Read More →



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

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
avatar for Frédéric Descamps

Frédéric Descamps

MySQL Community Manager, Oracle
"@lefred" has been consulting OpenSource and MySQL for almost 20 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the... Read More →



Wednesday October 21, 2020 13:30 - 14:00 EDT
Online
 
  • Timezone
  • Filter By Date Percona Live ONLINE Oct 20-21, 2020
  • Filter By Venue Online
  • Filter By Type
  • Cloud
  • Cool New Technologies
  • High Avaliability
  • Keynote
  • MariaDB
  • MongoDB
  • Monitoring
  • MySQL
  • NoSQL
  • Observability
  • Other OSDB
  • PostgreSQL
  • Security & Compliance
  • Difficulty
  • Core Technology