RUNNING MYSQL IN K8S Version: 03.10.19 Mykola Marzhan Has been - PowerPoint PPT Presentation

Oct 19, 2023 •157 likes •514 views

RUNNING MYSQL IN K8S Version: 03.10.19 Mykola Marzhan Has been developing deployment, update and monitoring systems since 2004. WHAT IS AN OPERATOR? OPERATORS WHAT IF IT FAILS? PRESSLABS OPERATOR PRESSLABS OPERATOR MYSQL OPERATOR MYSQL

RUNNING MYSQL IN K8S Version: 03.10.19
Mykola Marzhan Has been developing deployment, update and monitoring systems since 2004.
WHAT IS AN OPERATOR?
OPERATORS
WHAT IF IT FAILS?
PRESSLABS OPERATOR
PRESSLABS OPERATOR
MYSQL OPERATOR
MYSQL OPERATOR
PERCONA XTRADB CLUSTER
PERCONA XTRADB CLUSTER
WHAT ABOUT PERSISTENCY?
PERSISTENT VOLUME CLAIM PROVISIONER AWS EBS, AWS EFS OpenStack Cinder Google Cloud PD StorageOS Azure Disk, Azure File Flex Digital Ocean Flocker Ceph Quobyte Glusterfs Portworx Volume NFS Dell EMC ScaleIO iSCSI VMware vSphere Volume OpenEBS
PERSISTENCY PersistentVolumeClaim Automatic emptyDir Automatic hostPath
PERSISTENCY PersistentVolumeClaim PersistentVolumeClaim Automatic emptyDir Manual ReadWriteMany Automatic hostPath
PERSISTENCY PersistentVolumeClaim PersistentVolumeClaim PersistentVolumeClaim Automatic emptyDir Manual ReadWriteMany Automatic emptyDir Automatic hostPath Automatic hostPath
CAN I SCALE UP/DOWN?
  HOW CAN I RUN MULTI-REGION CLUSTER?
WHEN IS TRANSACTION FINISH? All nodes certified Majority of nodes certified Finished on master
PFFF, SO, IN SHORT   HOW CAN I RUN A MULTI-REGION CLUSTER?
WHAT ABOUT BACKUPS?
BACKUP DESTINATION S3 compatible storage PersistentVolumeClaim
BACKUP DESTINATION S3 compatible storage S3 compatible storage PersistentVolumeClaim
BACKUP DESTINATION S3 compatible storage S3 compatible storage S3 compatible storage PersistentVolumeClaim Google Cloud Storage Azure Blob Storage
BACKUP TOOL Percona XtraBackup mysqldump Percona XtraBackup direct streaming direct streaming save and stream
WHAT ABOUT RESTORE?
RESTORE SOURCE S3 compatible storage S3 compatible storage S3 compatible storage Persistent Volume Google Cloud Storage Azure Blob Storage HTTP URL
WHAT ABOUT MONITORING?
MONITORING Percona Monitoring   Prometheus Prometheus and Management MySQL Enterprise   Orchestrator Monitor
WHAT ABOUT ENCRYPTION?
ENCRYPTION TLS for client-server TLS for client-server No TLS for client-server TLS for replication TLS for replication No TLS for replication keyring is disabled keyring is disabled keyring is disabled
WHAT ABOUT EASY BUTTON?
Persistency Proxying Multi-Region Backups Monitoring Encryption Service Broker
Mykola Marzhan   mykola.marzhan@percona.com

Recommend

MySQL Replication Update MySQL 5.5 (GA) & MySQL 5.6.2 (Dev. Milestone) Lars Thalmann

<Insert Picture Here> MySQL Replication Update MySQL 5.5 (GA) & MySQL 5.6.2 (Dev. Milestone) Lars Thalmann Development Director MySQL Replication, Backup & Connectors O'Reilly MySQL Users Conference, April 2011 MySQL Releases

456 views • 42 slides

Providing Transparency for the Public Benefit A case study in running on-premise MySQL services

Providing Transparency for the Public Benefit A case study in running on-premise MySQL services using Percona XtraDB Cluster and ZFS Talk Outline OpenCorporates who/what/why ? Case study outline - Tech stack MySQL services history

697 views • 45 slides

MySQL Proxy Making MySQL more flexible Jan Kneschke jan@mysql.com MySQL Proxy proxy-servers

MySQL Proxy Making MySQL more flexible Jan Kneschke jan@mysql.com MySQL Proxy proxy-servers forward requests to backends and can transform, handle or block them released under the GPL see http://forge.mysql.com/wiki/MySQL_Proxy

945 views • 27 slides

PHP and MySQL Dr. E. Benoist Winter Term 2006-2007 PHP and MySQL 1 PHP and MySQL Introduction

Berner Fachhochschule - HTI PHP and MySQL Dr. E. Benoist Winter Term 2006-2007 PHP and MySQL 1 PHP and MySQL Introduction Basics of MySQL Create a Table See the content of a DB Tables: Change rows and Insert data Select

638 views • 53 slides

MySQL Proxy meets: binlogs Jan Kneschke MySQL Enterprise Tools mailto: jan@mysql.com What is

MySQL Proxy meets: binlogs Jan Kneschke MySQL Enterprise Tools mailto: jan@mysql.com What is MySQL Proxy Started Feb 2007 Current: MySQL Proxy 0.7.0 Source available on launchpad.net $ bzr branch lp:mysql-proxy Foundation of

308 views • 17 slides

The MySQL Ecosystem - understanding it, not running away from it! Colin Charles, Chief Evangelist,

The MySQL Ecosystem - understanding it, not running away from it! Colin Charles, Chief Evangelist, Percona Inc. colin.charles@percona.com / byte@bytebot.net http://bytebot.net/blog/ | @bytebot on Twitter FOSDEM, Brussels, Belgium 4 February 2018

634 views • 35 slides

MySQL Group Replication & MySQL InnoDB Cluster Production Ready? Kenny Gryp MySQL Practice

MySQL Group Replication & MySQL InnoDB Cluster Production Ready? Kenny Gryp MySQL Practice Manager Table of Contents Group Replication MySQL Shell (AdminAPI) MySQL Group Replication MySQL Router Best Practices Limitations Production?

993 views • 72 slides

Forecasting MySQL Scalability Baron Schwartz O'Reilly MySQL Conference & Expo 2011

Forecasting MySQL Scalability Baron Schwartz O'Reilly MySQL Conference & Expo 2011 Consulting Support Training Development For MySQL Percona Server Replaces MySQL Faster Queries More Consistent More Measurable More

670 views • 41 slides

PHP + MySQL MySQL on the command line is great and all well not its not really that great

PHP + MySQL MySQL on the command line is great and all well not its not really that great Using MySQL in PHP is somewhat similar to the command line: Set up a connection to a MySQL database Issue a bunch of commands to the

944 views • 43 slides

SQL & MySQL Jeff Siarto - TC 361 Whats the Difference? MySQL is a database SQL is

SQL & MySQL Jeff Siarto - TC 361 Whats the Difference? MySQL is a database SQL is a language to interact with the database SQL is used with other databases: Access, Oracle, Portage SQL, MS SQL, etc... MySQL Open source

392 views • 7 slides

Percona MySQL About Me Qunar.com DB Director

Percona MySQL About Me Qunar.com DB Director MySQL Inception MySQL ACMUG Oracle MySQL ACE Director What do we need to do for MySQL in

320 views • 20 slides

MySQL Cluster und MySQL Proxy Alles Online Diese Slides gibt es auch unter:

MySQL Cluster und MySQL Proxy Alles Online Diese Slides gibt es auch unter: http://rt.fm/s4p Agenda (Don't) Panic Web- und MySQL-Server MySQL Master-Master Cluster MySQL Proxy und Cluster MySQL

1.83k views • 31 slides

More on gdb for MySQL DBAs or Using gdb to study MySQL internals and as a last resort Valerii

More on gdb for MySQL DBAs or Using gdb to study MySQL internals and as a last resort Valerii Kravchuk, MySQL Support Engineer vkravchuk@gmail.com Who am I? Valerii (aka Valeriy ) Kravchuk : MySQL Support Engineer in MySQL AB, Sun and

376 views • 20 slides

Reducing Risk When Upgrading Your MySQL Environment Kenny Gryp MySQL Practice Manager My

Reducing Risk When Upgrading Your MySQL Environment Kenny Gryp MySQL Practice Manager My Experience as MySQL Consultant On Upgrading MySQL it's quite complex... Kenny Gryp MySQL Practice Manager Table of Contents The Ocial Documentation

1.13k views • 77 slides

MySQL X Protocol Talking to MySQL Directly over the Wire Simon J Mudd

MySQL X Protocol Talking to MySQL Directly over the Wire Simon J Mudd <simon.mudd@booking.com> Percona Live Europe Amsterdam 5 th October 2016 Content What is MySQL X protocol How does it work Building Drivers

793 views • 60 slides

Geographic Features in MySQL Tibor Korocz Percona What do I try to answer today? - Can MySQL

Geographic Features in MySQL Tibor Korocz Percona What do I try to answer today? - Can MySQL 8 help us with the common usecases? - Distance Calculation. - What is near by me? - Does MySQL 8 give us better options/solutions for these

1.14k views • 52 slides

Performance Guide for MySQL Cluster Mikael Ronstrm, Ph.D Senior MySQL Architect Sun

Performance Guide for MySQL Cluster Mikael Ronstrm, Ph.D Senior MySQL Architect Sun Microsystems MySQL Cluster Application Application Application MySQL Client MySQL Client MySQL Client Application Application MySQL MySQL MySQL

737 views • 50 slides

MySQL @Twitter: No More Forkin - Migrating to MySQL Community Version Twitter, Inc. MySQL

Twitter, Inc. MySQL @Twitter: No More Forkin - Migrating to MySQL Community Version Twitter, Inc. MySQL @Twitter Background Migration Process Migration Challenges Post-Deployment Challenges Future Plans Q&A

703 views • 44 slides

Securing customer data (PII) in MySQL Alexander Rubin VirtualHealth PRIVILEGED + CONFIDENTIAL

Securing customer data (PII) in MySQL Alexander Rubin VirtualHealth PRIVILEGED + CONFIDENTIAL About me Working with MySQL for 10-15 years Started at MySQL AB 2006 Sun Microsystems, Oracle (MySQL Consulting) Percona since 2014

1.13k views • 44 slides

Why MySQL Replication Fails, and How to Get it Back September, 26, 2017 Sveta Smirnova Sveta

Why MySQL Replication Fails, and How to Get it Back September, 26, 2017 Sveta Smirnova Sveta Smirnova MySQL Support engineer Author of MySQL Troubleshooting JSON UDF functions FILTER clause for MySQL Speaker Percona

1.4k views • 139 slides

Managing MySQL at Scale Pradeep Nayak & Junyi (Luke) Lu Production Engineers - MySQL Infra

Managing MySQL at Scale Pradeep Nayak & Junyi (Luke) Lu Production Engineers - MySQL Infra Agenda 1 Terminology 2 Lifecycle of a MySQL instance 3 How do we migrate MySQL instance 4 How do we migrate shard 5 Balancing 6 Testing

919 views • 50 slides

An API for Reading the MySQL Binary Log Lars Thalmann Mats Kindahl Development Director, MySQL

<Insert Picture Here> An API for Reading the MySQL Binary Log Lars Thalmann Mats Kindahl Development Director, MySQL Lead Software Engineer, MySQL Replication, Backup & Connectors Replication & Utilities The following is

459 views • 42 slides

Deploying MySQL and MongoDB in Kubernetes Alexander Rubin Percona About me Working with

Deploying MySQL and MongoDB in Kubernetes Alexander Rubin Percona About me Working with MySQL for 10-15 years Started at MySQL AB, Sun Microsystems, Oracle (MySQL Consulting) Joined Percona in 2013 2 What is Kubernetes?

734 views • 60 slides

MariaDB MySQL Corrected Michael Monty Widenius About Monty Original author of MySQL

MariaDB MySQL Corrected Michael Monty Widenius About Monty Original author of MySQL Co-Founder of MySQL Ab (with David Axmark and Allan Larsson) Founder of Monty Program Ab Swedish-Finn Purveyor of salmiakkikossu and

707 views • 32 slides