Elasticsearch is well known as a highly scalable search engine that stores data in a structure optimized for language based searches but its capabilities and use cases don't stop there. In this tutorial, I'll give you a hands-on introduction to Elasticsearch and give you a glimpse at some of the fundamental concepts.
Database administration is challenging, and Elasticsearch is not an exception to that rule. In this tutorial, we will cover various administrative topics like Installation and Configuration, Cluster/Node management, Indexes management and Monitoring Cluster Health which will help you. Building applications on top of an Elasticsearch are also challenging and raise concerns about schema design. In this tutorial, we will cover developer-oriented topics like Mappings and Analysis, Aggregations and Schema Design that will help you build a robust application on top of Elasticsearch.
There will be lab sessions at the end of some chapters so please have your laptops with you.
Running MongoDB in production can be challenging.
In this tutorial, we will cover how to configure the database, and how to parse and interpret logs and metrics to make your day by day easier.
We will learn how to:
Interpret the MongoDB logs and server status output
Use "currentOp" command to check current queries running
Use the Database Profiler
Configure Linux for production, including OS parameters, network parameters, and disks configurations
Safely run maintenance in replica sets and shards
Create indexes without performance degradation
Pick the right shard key, and when and why to use shard tags
Use benchmark and load replaying tools
Choose the best backup method
Monitor your system with PMM
Evaluate if your application can take advantage of transactions in 4.0
Configure Change Streams and get notifications with a few lines
Tutorial on the foundations of query optimization to speed up query execution with MySQL 8.0 and MariaDB 10.3:
* Example database and environment setup
* Query profiling (what queries to optimize first?)
* Access types and basic indexing
- How indexes work to speed-up queries
- BTREE indexes
- InnoDB peculiarities
* Multi-column indexing
- Column order
- Index condition pushdown
* FULLTEXT indexing
* Join execution and optimization
- Other strategies and variants: MRR and hash joins
* Subquery issues
- Issues with subqueries in older versions
- Semi-Join execution and other optimizations
There is a stigma attached to database proxies when it comes to MySQL. This tutorial hopes to blow away that stigma by showing you what can be done with a proxy designed from the ground up to be performant. That proxy is ProxySQL. In this tutorial we will not only explain how ProxySQL can make your databases(MariaDB, MySQL, Percona Server) process more transactions than without a proxy we will show you how you can leverage ProxySQL to pre-qualify upgrades, test the impact of schema changes, perform seamless failovers, rewrite offensive queries on the fly, and help you install and configure the proxy to manage queries.
During this tutorial, attendees will get their hands on virtual machines and migrate standard Master - Slave architectures to the new MySQL InnoDB Cluster (native Group Replication) with minimal downtime.
We will highlight the new improvements made in MySQL 8.0 regarding Group Replication and InnoDB Cluster and explain the benefits of the major improvement in the latest release !
This tutorial is focused on teaching PostgreSQL to professionals that are already experienced with MySQL or Oracle. Relational databases share a lot of similar concepts. You may find it easier if we help you relate the concepts of PostgreSQL with Oracle/MySQL. Thus, we would start with PostgreSQL Architecture for Oracle/MySQL DBAs. As we discuss from basics, even a beginner may adapt the concepts easily. Thus, the approach we take with this tutorial is to present an overview of the PostgreSQL architecture and operation in view of MySQL's and Oracle's. We'll mix lecture with hands-on work, having the audience apply the concepts we present in practice in a lab format before covering new ones, starting with a simple and quick installation of PostgreSQL and going all the way to setup and maintain a stand by replica. By the end of the day attendees shall walk away from this tutorial with a good understanding of how PostgreSQL works and feel confident enough about it.
Following are the main points being discussed in this tutorial :
Brief history of PostgreSQL and its features
PostgreSQL Architecture for MySQL/Oracle DBAs and beginners.
Installation of PostgreSQL
Creating/Start/Stop a PostgreSQL Cluster and the components of a Data Directory
PostgreSQL parameters/settings you need to know
PostgreSQL User Management
MVCC in PostgreSQL
VACUUM and Transaction ID Wraparound in PostgreSQL
Types of Indexes
EXPLAIN in PostgreSQL
Logical and Physical Backups and PITR
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.
In this tutorial, we will build a shard from scratch, starting from a single instance, then learning how the replica set works in detail. You will learn how to convert a single instance to a replica set and why a single instance is not a good fit for production. After understanding the replica-set concepts we will start a sharded cluster using best practices, learn how the shard works internally, what chunk and shard keys are, how to split data across different regions (geo-partitioning), how to perform an upgrade and also how to scale up and down the cluster. All of those steps will be performed in a secure environment with authentication enabled and monitoring by PMM.
InnoDB: What you didn't know about the storage engine that powers most of the Web
InnoDB is the most commonly used storage engine for MySQL 8.0 and Percona Server for MySQL, and is the focus for the majority of storage engine development by the MySQL and Percona teams.
In this tutorial, we will look at the InnoDB architecture, including new developments in MySQL 8.0 as well as Percona Server for MySQL. We will explain how InnoDB should be used to get the best performance from your application. We will provide specific advice on server configuration, schema design, application architecture and hardware choices.
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.
Never used Percona XtraDB Cluster before? Come join this half-day tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster.
In this tutorial we are going to show you how can you install Percona XtraDB Cluster with ProxySQL and monitor it with PMM.
We will also cover topics like bootstrap, IST, SST, Certification, common-failure situations and online schema changes.
This entire tutorial is extremely hands on. We will supply instances for you to work with on your own laptop. You will be executing all the commands along with your instructors to gain first-hand experience.
This talk is designed for PostgreSQL administrators. It covers all aspects of PostgreSQL administration, including installation, security, file structure, configuration, reporting, backup, daily maintenance, monitoring activity, disk space computations, and disaster recovery. It shows how to control host connectivity, configure the server, find the query being run by each session, and find the disk space used by each database.
This is a hands-on tutorial covers how to set up monitoring for MySQL, MongoDB, and PostgreSQL database servers using the Percona Monitoring and Management (PMM) platform.
PMM is an open-source collection of tools for managing and monitoring MySQL, MongoDB, and PosgreSQL performance. It provides thorough time-based analysis for database servers to ensure that they work as efficiently as possible.
You will learn about:
- MySQL, MongoDB, and PostgreSQL monitoring best practices
- Metrics and time series
- Data collection, management and visualization tools
- Monitoring deployment
- How to use graphs to spot performance issues
- Query analytics for MySQL and MongoDB
- Alerting using Grafana
- Trending and capacity planning
- How to monitor HA
Please bring a laptop with an ssh client as you will be connecting to a Cloud-provisioned instance on which you will deploy PMM.