Alexander joined Percona in 2013. Alexander worked with MySQL since 2000 as DBA and Application Developer. Before joining Percona he was doing MySQL consulting as a principal consultant for over 7 years (started with MySQL AB in 2006, then Sun Microsystems and then Oracle). He helped many customers design large, scalable and highly available MySQL systems and optimize MySQL performance. Alexander also helped customers design Big Data stores with Apache Hadoop and related technologies.
Performance Schema is powerful diagnostic instrument for:
- Query performance
- Complicated locking issues
- Memory leaks
- Resource usage
- Problematic behavior, caused by inappropriate settings
It comes with hundreds of options which allow precisely tune what to instrument. More than 100 consumers store collected data.
In this tutorial we will try all important instruments out. We will provide test environment and few typical problems which could be hardly solved without Performance Schema. You will not only learn how to collect and use this information, but have experience with it.
Kubernetes, and its most popular distribution OpenShift, receives a lot of interest as a container orchestration platform. However, databases remain a foreign entity, primarily because of their stateful nature.
In this presentation I discuss how to deploy Open Source databases (MySQL/Percona XtraDB Cluster and MongoDB) on Kubernetes/Openshift. For Percona XtraDB Cluster (PXC) we will be using MySQL Proxy to implement read/write splitting.
If you have never used Kubernetes and Openshift, I will do a quick introduction to these technologies. There will also be a demo where I will set up a PXC cluster with ProxySQL as well as MongoDB replicaset in Openshift Origin and will try to break it.
By the end of this webinar you will have a better understanding of:
* How to leverage Kubernetes/Openshift in your environments
* How to deploy opensource databases in Kubernetes/Openshift with StatefulSet.
* How to operate the databases in Kubernetes
Everyone wants to have a highly available (HA) database. But which solution do you choose and what should you consider?
In this training session, we will look into a wide set of existing and new HA solutions, including
1. MySQL replication based HA solutions (MHA, Orchestrator) and routing options (ProxySQL, HA Proxy)
2. Clustering solutions (Percona XtraDB Cluster, MySQL NDB Cluster)
3. Cloud-based solutions (AWS RDS/Aurora, Google Cloud SQL)
4. Container-based solutions (Kubernetes/Openshift)
We will discuss the advantages and disadvantages of each solution and show some basic demos.
PostgreSQL 11- Bruce Momjan
PostgreSQL benefits from over 20 years of open source development and has become the preferred open source relational database for developers. PostgreSQL 11 was released on October 18. It provides users with improvements to overall performance of the database system, with specific enhancements associated with very large databases and high computational workloads.
MongoDB 4.0- Alexander Rubin
Do you love MongoDB? With version 4.0 you have a reason to love it even more! MongoDB 4.0 adds support for multi-document ACID transactions, combining
the document model with ACID guarantees. Through snapshot isolation, transactions provide a consistent view of data and enforce all-or-nothing execution to maintain data integrity. And not only transactions - MongoDB 4.0 has more exciting features like non-blocking secondary teads, improved sharding, security improvements and more.
MariaDB 10.3- Arjen Lentz
MariaDB benefits from a thriving community of contributors. The latest release, MariaDB 10.3, provides several new features not found anywhere else, as well backported and reimplemented features from MySQL."