Laurie Coffin, Percona's CMO kick starts the keynotes!
Open source database adoption continues to grow in enterprise organizations, as companies look to scale for growth, maintain performance, keep up with changing technologies, control risks and contain costs. In today's environment, a single database technology or platform is no longer an option, as organizations shift to a best-of-breed, polyglot strategy to avoid vendor lock-in, increase agility and enable business growth.
Following Peter's keynote, we will have a round of lightning talks featuring the latest releases from PostgreSQL, MongoDB and MariaDB.
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."
This keynote highlights the collaborative journey PaddyPowerBetfair and Percona have taken through the adoption of MySQL within the PPB enterprise. The keynote focuses on how Percona has assisted PPB in adopting MySQL, and how PPB has used this partnership to deliver a full DBaaS for MySQL solution on Openstack. (This case study will be presented in full later in the day with a 50 minute presentation by the PPB DBA and cloud automation teams.)
PostgreSQL is an advanced open source database software that is completely community driven.
It is also important to understand how different it is from MySQL conceptually and where is it different from MySQL.
This talk starts with a brief overview on PostgreSQL and conceptual differences between PostgreSQL and MySQL.
MongoDB 4.0 brings transactional properties from the SQL world to the NoSQL world. Now supporting snapshot isolation, commits and rollbacks are one of the most exciting features of MongoDB 4.0. Moreover, MongoDB 4.0 brings interesting enhancements like change streams, SHA-2 authentication, and security enhancements to create users using authentication restrictions.
In this session we will walk through the new features available on MongoDB 4.0:
Security enhancements and SHA-2 authentication
Change streams and read concern
MMAP deprecation on 4.2
MongoDB mobile database
It's been 3 years now since we've shifted 100% of our production workloads into containers. We will provide an overview of our infrastructure and environment, introduce our service discovery solution and reveal what we call â€œBackend High Availability Pillarsâ€. We will reveal our secrets to successfully operate stateful apps into containers and will detail our past and future challenges:
- 2014: config management (chef) to dedicated on-prem servers
- 2015: RKT containers orchestrated through Fleet on hundreds of on-prem servers
- 2017: RKT containers orchestrated through Kubernetes on hundreds of on-prem servers
- 2018: Docker containers orchestrated through Kubernetes on a Cloud Provider (WIP)
We will introduce Percona Server 8.0 - what's new since Percona Server 5.7 and how it's different from MySQL 8.0.
The session shows real use case scenarios for the MySQL 8 new features like Resource Groups, instant column addition and others that make DBA's life easier.
Have you heard about USE Method (Utilization - Saturation - Errors), RED (Rate - Errors - Duration) or Golden Signals (Latency - Traffic - Errors - Saturations)?
In this presentation, we will talk briefly about these different, but similar â€œfocusesâ€ and discuss how we can apply them to the data infrastructure performance analysis troubleshooting and monitoring.
We will use MySQL as an example but most of the talk will apply to other database technologies as well.
Backup is critical for database maintenance, especially when providing database service on the cloud. For Alibaba Cloud ApsaraDB, the backup system is one of the most import basic infrastructures and faces many challenges because of the cloud environment.
In this topic, I will share how we use and improve Percona XtraBackup to provide backup/recover service at Alibaba Cloud, such as backup validate, resource usage control, multi engines backup (InnoDB, TokuDB and MyRocks), and DB/Table level backup, etc.
Since the beginning, Facebook has used a conventional username/password to secure access to production MySQL instances. Over the last few years, we've been working on moving to x509 TLS client certificate authenticated connections. Given the many types of languages and systems at Facebook that use MySQL in some way - this required a massive amount of changes for a lot of teams.
This talk is a partially technical overview of how our new solution works and part hard-learned tricks for getting an entire company to change their underlying MySQL client libraries.
The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution. This talk uses the explain command to show how the optimizer interprets queries and determines optimal execution. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can take to understand and perhaps improve its behaviour.
Every new version of MongoDB comes with exciting new features and a lot of improvements and version 4.0 couldn't be an exception to this rule. An upgrade from previous versions will unlock long waiting features like transactions but at the same time without proper planning could be catastrophic for your organization.
This presentation will guide you through the stapes for planning and implementing an upgrade to MongoDB 4.0. We will examine how MongoDB 4.0 affects your organization ecosystem and what changes might be necessary prior to the upgrade. We will demonstrate the upgrade steps with a detailed rollback plan. Finally, we will cover some post-upgrade considerations that will allow you to release the power of MongoDB 4.0.
How are you doing integration tests with your datastore?
* Mocking is not an option since you want to test the actual system.
* There are some in-memory implementations, like H2 or HSQLDB for relational databases, but there are still subtle differences to your production system and not all datastores have in-memory cousins.
* Using the actual datastore in your tests is possible, but managing it, running tests in parallel,... is far from ideal.
So what is the solution? There are some very neat solutions based on containers, namely the Docker-Maven-Plugin and TestContainers. From your tests you can start a lightweight, throwaway instance of your datastore and this talk will walk you through how to do that.
This session will be interesting for everyone looking for the latest news about MySQL 8.0 Performance:
- MySQL 8.0 is GA now !
- but what about MySQL 8.0 Performance? ;-)
- the latest benchmark results obtained with MySQL 8.0 will be in the center of the talk
- because every benchmark workload for MySQL is a "problem to resolve"
- and each resolved problem is a potential gain in your production!
- many important internal design changes are coming with MySQL 8.0
- how to bring them in action most efficiently?
- what kind of trade-offs to expect, what is already good, and what is "not yet"?
- how well MySQL 8.0 is able to use the latest HW?
- could you really speed-up your IO by deploying your data on the latest flash storage?
- these and many other questions are answered during this talk + proven by benchmark results.
NOTE: since MySQL 8.0 we're following a "continuous release" model, so with every update there is some new improvement coming, the performance included ;-))
Percona XtraDB Cluster (a.k.a PXC) is multi-master high-availability clustering solution. Given the multi-master aspect, there are multi-guards to protect cluster from entering an inconsistent state. Most of these guards are configurable based on user environment but if they are not configured properly it could cause the cluster to stall, fail, error-out.
In this session, we would go over some of these failure scenarios like cluster entering non-primary due to network partitioning, cluster stall due to flow control, data inconsistency causing shutdown of node, common problem during initial catch up (a.k.a State Snapshot transfer (SST)), delay in purging of transaction, blocking DDL causing complete cluster to staff, misconfigured cluster, etcâ€¦
We would also discuss how to solve some of these problems or have to safely recover from these failures.
Prometheus, now a graduated CNCF project, is the de facto leader in the monitoring and metrics space. With the 2.0 launch nearly a year behind us, we are now focused on making Prometheus boring. i.e, more stable, more usable and even MOAR user-friendly!
This talk will cover the new storage briefly and then move on to new developments and the future roadmap of the project which includes among other things better remote integrations, backfilling API, security improvements and OpenMetrics.
We would like to present our journey in building MySQL Database As A Service on OpenStack at Paddy Power Betfair.
We would like to discuss the help and support we have had from Percona throughout our adoption of MySQL at PPB and also how we met the challenges in building a mature DBaaS on PPB's private OpenStack cloud using Percona software.
At the Wikimedia Foundation, we aim for perfect privacy of our users. That means not only enforcing TLS (https) between our users and the datacenters but all intermediate steps, including database access.
When you are a top 5 website with hundreds of thousands of queries per second and billions of users but a very limited budget, that is not easy, especially for MySQL. This is a description of our experience, including operational and performance pain points, of rolling out encryption.
We also talk about what has changed in the ecosystem since the introduction of MySQL 8.0 and MariaDB 10.3.
PostgreSQL is an advanced open source database that is completely community driven. Continuous development and performance improvements while maintaining a secondary focus on Oracle compatibility gave PostgreSQL a great market penetration. When a database server is deployed in production we often wish to achieve several 9's of availability. Is that even possible with PostgreSQL? What is the combination of tools that you could combine and implement to achieve High Availability (HA) and automatic failover in PostgreSQL? How can we avoid data loss during such failover's? We'll address these questions and then some more in this talk.
In this talk we will cover the backup methods available on MongoDB, being from a simple mongodump to the hotbackup tool available on Percona Server for MongoDB.
Backups are important and more important is to be aware of the pros and cons of a backup method.
This is an intermediate topic for DBAs and SysAdmins who wants to learn a bit more about Backups.
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
More and more people have mobile phones and more and more people use some IoT devices which are which are collecting many metrics and details example the Geo Locations.
In this presentation, I am going to focus on the Geo Location data and how the new features in MySQL 8 can help us.
I am going to show a use case from one of my customers. They are collecting location information from cars and one of their challenging problem to find cars which were crossing a randomly marked area on the map. I am going to show if MySQL 8 can help this and if yes how?
Also the "traditional" show me the hotels/restaurants/pubs nearby me or in this city, is there any improvement in MySQL 8 which can help us here?
During this talk, I explain how the Group Replication replication works.
This is a theoretical talk in which I explain in details what replication is and how it works.
I discuss what certification is and how it's done. What is XCOM and GCS?
Is Group Replication synchronous?
What is the benefit of Single Primary Mode?
What are the caveats of such replication?
Why is Paxos Mencius more efficient than Totem? Is it always?
After this presentation, the audience should be comfortable with the technical terms and understand how does it work.
Don't miss this talk, the magician will reveal his tricks!
The goal of is to show my own tools of administration & monitoring, I started developed this in 2010 like a mixte of commands for audit MySQL Server, after each client I improved this tools, today my clients enjoy to use PmaControl to know what happens with their database! The time is come to open this software.
What it's can do?
- No configuration / autodetection for all
- Replication monitoring
- Topology in real time (SST/Donor detection + progress)
- Clean efficiently
- UI for MySQL-sys
- BenchMark UI (with sysbench)
- Switch a slave to another master (even with M/S between them without GTID)
Taking existing infrastructure to Google Cloud has been a challenge, and our tiny team did it at breakneck speed. We survived that move and have the scars to prove it. We'll review how we got there, and the challenges that we've faced now that we're out of the datacenter. In this lecture, we will talk about the decisions that we've made for our high availability, DR solution, and database hosting.
* CloudSQL vs. Self-managed instance
* IOPS limitations
* Both bacon saving and issues that we've had with it.
* IP Aliases
* DR solution
A critical piece of your infrastructure is the database tier, yet people don't pay enough attention to it judging by how many are bitten via poorly chosen defaults, or just a lack understanding of running a secure database tier. In this talk, I'll focus on MySQL/MariaDB, PostgreSQL and MongoDB, and cover external authentication, auditing, encryption, SSL, firewalls, replication, and more gems from over a decade of consulting in this space from Percona's 4,000+ customers.
PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. The default configuration is designed in such a way that PostgreSQL can run on any system with least resources. PostgreSQL does not give optimum performance on high permanence machine because it is not using the all available resource. PostgreSQL provides a system you can tune your database according to your workload and machine specification. Other than PostgreSQL we can also tune our Linux box so that database load can work optimally. Here we learn how to tune PostgreSQL and will see the results of that tuning, We will also touch some of the Linux kernel parameters tuning.
NoSQL databases and especially MongoDB fits in all kind of companies - from small Startups to Enterprise Companies-.
In this talk, we will discuss how MongoDB can be used in Enterprise environment and what features Percona Server for MongoDB offers to help those companies to integrate MongoDB with an existing environment and also to be compliant with security certifications.
We will demonstrate use cases, how to configure roles-based access, LDAP integration, auditing, encryption at rest.
This talk will provide a high level overview of automation tooling, the pros and cons of each option, and how to apply them to managing the operations of your databases using working examples.
In this session, learn what happens in a MySQL 5.7-to-MySQL 8.0 upgrade. Discover how the upgrade precheck tool can help you prepare for your upgrade by identifying old issues in your database and collecting 5.7 metadata and re-establishing it in the uniformly stored MySQL 8.0 data dictionary. Other topics covered include upgrading from 8.0 and onward, going for an automated upgrade experience, and why an automated downgrade is challenging.
MySQL 8 is the new kid on the block, and Percona has already had some customers migrate excitedly to the new release. In this session learn practical migration knowledge: what you need to know if you're already an experienced MySQL DBA, and how to move from MySQL 5.5, 5.6, and 5.7 to MySQL 8.0. Topics covered include the stability of the new release, improvements around high availability, how MySQL 8.0 is more performant, all the new security features (from better passwords to roles) to aid in compliance, and of course, improved manageability and observability enhancements. This is a practical field guide for early MySQL 8 adopters.
Do you already run stock PMM in your environment and want to learn how you extend the PMM platform? Come learn about:
1. Dashboard Customizations
* How to create custom dashboard from existing graphs, or build Cross Server Dashboards
2. External Exporters - Monitor any service, anywhere!
* Adding an exporter, view the data in data exploration, to deploying a working Dashboard
3. Working with custom queries (MySQL and PostgreSQL)
* Execute SELECT statements against your database and store in Prometheus
* Build Dashboards relevant to your environment
4. Customizing Exporter Options
* Enable de-activated functionality that applies to your environment
5. Using Grafana Alerting
* How to set up channels (SMTP, Slack, etc)
* How to configure thresholds and alerts
6. Using MySQL/PostgreSQL Data Source
* Execute SELECT statements against your database and plot your application metrics
At Zalando we run PostgreSQL at scale: a few hundred database clusters in sizes from a few megabytes up to 10 terabytes of data. What is a bigger challenge than running a high-OLTP multi-terabyte PostgreSQL cluster? It is the migration of such a cluster from the bare-metal data center environment to AWS.
There were multiple problems to solve and questions to answer:
* Which instance type to choose: i3 with ephemeral volumes or m4/r4 + EBS volumes?
* Should we give Amazon Aurora a try?
* There is no direct connection from AWS to the data-center. How to build a replica on AWS and keep it in sync if VPN is not an option?
* The database is used by a few hundred employees for ad-hoc queries; ideally, they should retain access through the old connection url.
* How to backup such a huge DB on AWS?
* We should be able to switch back to the data-center if something goes wrong.
In this talk I am going to provide a detailed account of how we managed to successfully solve all these problems.
The purpose of the talk is to present data-at-rest encryption implementation in Percona Server for MySQL.
Differences between Oracle's MySQL and MariaDB implementation.
- How it is implemented?
- What is encrypted:
- General tablespace?
- Double write buffer/parallel double write buffer?
- Temporary tablespaces? (KEY BLOCKS)
- Slow/general/error logs?
- MyISAM? MyRocks? X?
- Performance overhead.
- Transportable tablespaces. Transfer key.
- Keyrings in general
- Key rotation?
- General-Purpose Keyring Key-Management Functions
- Is useful? How to make it profitable?
- Keyring Vault
- How does it work?
- How to make a transition from keyring_file
Locking is critical for providing high concurrency for any database â€” you cannot fully utilize your hardware if locking is throttling its use. This talk explores all aspects of locking in Postgres by showing queries and their locks; covered lock types include row, table, shared, exclusive, and advisory lock types. The high concurrency provided by Multiversion Concurrency Control (MVCC) is also covered.
Introduction about MongoDB Shards and their internals. How to configure and form design for the Shards. Including multiple DC setup, backup instance etc. Explaining about the shard key and choosing the right one - pros and cons. What to do with the Shards and what not to do. tips and tricks & troubleshooting Shard related issues like orphan documents, duplicate _id etc due to application logic.
Apache Cassandra 4.0 has several enhancements. One of the biggest enhancements is switching from blocking network IO using JDK Sockets to Non-Blocking IO with Netty. As a result, Cassandra has seen gains in performance and efficiency. These gains translate into real-world costs and allow Cassandra to scale better. This presentation will take you on a tour of the improvements of Cassandra's network layer (old & new) and help quantify the gains in real-world terms.
Up to MySQL 5.5, replication was not crash safe: after a crash, it would fail with â€œduplicate keyâ€ or â€œrow not foundâ€ error, or might generate silent data corruption. It looks like 5.6 is much better, right? The short answer is maybe: in the simplest case, it is possible to achieve replication crash safety but it is not the default setting. MySQL 5.7 is not much better, 8.0 has safer defaults but it is still easy to get things wrong.
Crash safety is impacted by replication positioning (File+Pos or GTID), type (single-threaded or MTS), MTS settings (Database or Logical Clock, and with or without slave preserve commit order), the sync-ing of relay logs, the presence of binary logs, log-slave-updates and their sync-ing. This is very complicated stuff and even the manual is confused about it.
In this talk, I will explain the impact of above and help you finding the path to crash safety nirvana. I will also give details about replication internals, so you might learn a thing or two.
In this presentation attendees will see the performance of a MySQL Server increase by automatic tuning using an open source GA (Genetic Algorithm) with surrounding smart bits. The full interface code will be made publicly available as open source on GitHub.
Genetic Algorithms - a kind of Artificial Intelligence - have been used for a long time, but only recently the interest towards database applications has spiked.
You will see the transactions per second increase and increase again as the server is being adjusted automatically.
You will walk away with a better understanding of Genetic Algorithms, it's application to automated database tuning, and how to start with (or continue) your own experiments in this area.
All new work, this setup has not been showcased anywhere before.
Troubleshooting the database-related problems turns out to be not a simple task even if you run your database on-premise. And performance debug can become a nightmare when you run it as a managed service in AWS/GCP/Azure, because you have no access to the underlying OS, and series of DB metrics gathered by your monitoring solution is the only subject you have to explore.
The talk will make an overview of a monitoring possibilities available for MySQL/PostgreSQL managed database in case of AWS, GCP, and Azure cloud providers. We will review what monitoring data can be gathered, speak about data granularity, and discuss ways to export these metrics to Prometheus for their simplified representation and wide/complex troubleshooting analysis of the whole instance.
Keeping data safe is the top responsibility of anyone running a database. Learn how the Google Cloud SQL team protects against data loss. Cloud SQL is Google's fully-managed database service that makes it easy to set up and maintain MySQL and PostgreSQL databases in the cloud. In this session, we'll dive into Cloud SQL's storage architecture to learn how we check data down to the disk level. We will also discuss PostgreSQL checksums and infrastructure Cloud SQL uses to verify that checksums for data files are accurate without affecting performance of the database.
In this talk, we take a look at the whole stack and I don't just mean LAMP,
we'll cover what an attack surface is and some areas you may look to ensure
that you can reduce it.
What's an attack surface?
Acronym Hell, what do they mean?
Vulnerability naming is this media naming stupidity or driving the message
Detection, Prevention and avoiding the boy who cried wolf.
Emerging technologies to keep an eye on or even implement yourself to help
improve your security posture.
A live compromise demo (or backup video if something fails) which covers
compromising a PCI compliant network structure to reach the database system
and ultimately exploit multiple failures to gain bash shell access over the
The Elephant Shed is an Open Source PostgreSQL Appliance that bundles and integrates proven components, required for easy management of a PostgreSQL server.
It takes more than one piece of software to create a reliable and serviceable platform. There are different approaches to fill the gap, but usually Open Source offers all the bits and pieces needed. However, these need to be well integrated. Elephant Shed is such an integration of all the necessary tools for a high-performance PostgreSQL platform.
The wheel is not reinvented. Instead of new developments, established and reliable open source projects that fullfill the needs of the specific aspect are assembled into the Elephant Shed PostgreSQL appliance. These are integrated within a single user interface. Automated scripts in the background ensure that the interaction of all these tools runs smoothly.
This presentation reasons why Elephant Shed was created and shows the technical details and the advantages it brings.
Learn how to monitor MongoDB using Percona Monitoring and Management (PMM) so that you can:
* gain greater visibility of performance and bottlenecks MongoDB
* Consolidate your MongoDB servers into the same monitoring platform you already use for MySQL and PostgreSQL
* Respond more quickly and efficiently in Severity 1 issues
We'll show how using PMM's native support for MongoDB so that you can have MongoDB integrated in only minutes!
Prometheus has become the go-to system for monitoring cloud-native infrastructures such as Kubernetes, with lots of integration points and options.
In this talk, we will look at all the relevant pieces for setting up Prometheus monitoring of your Kubernetes cluster - primarily from a user's perspective but also peeking under the hood to see how things work.
On the Prometheus side, we'll cover the different ways that service discovery and relabelling can be used, and how they make Prometheus so flexible.
On the Kubernetes side, we'll look at the alphabet soup of available metrics exporters (kube-state metrics, cAdvisor, node exporter, and friends).
Finally, we'll take a step back and consider how Prometheus' somewhat unique design and feature set fits into the broader landscape of monitoring systems, and how it is especially suited to cloud-native environments like Kubernetes.
MySQL 8 introduces a feature that is explained in a single document page, but that can help a lot if correctly used.
It is well hidden, in the optimization: optimizing of the MySQL server chapter.
I am talking of Resource Groups.
Resource groups permit assigning threads running within the server to particular groups so that threads execute according to the resources available to the group.
Group attributes enable control over its resources, to enable or restrict resource consumption by threads in the group. DBAs can modify these attributes as appropriate for different workloads.
This small simple feature can be a blast in case you have contention between different type of load on your database.
The simplest example is a combination of OLTP/OLAP or OLTP/ETL.
In this presentation, I will illustrate the feature and how it can be easily and successfully implement.
Also covering those contexts, like large enterprises, where code dynamic is not as agile as we would like to be.
MySQL 8.0 makes it possible to write queries that do more. MySQL can now traverse hierarchies, analyze data in new ways, and combine JSON and spatial data with traditional types -- all in the same query.
In this talk, we'll look at common table expressions (CTEs), window functions, geography support and JSON functionality, and how these can be used to do things no MySQL query has ever done before.
If you're curious about what these features are or what you can do with them, then this talk is for you.
Getting Percona Monitoring and Management (PMM) up and running on Docker is just a matter of a few simple steps. Now, if your goal is to have a production-ready, long term monitoring solution, there are additional points to consider.
Furthermore, using PMM's stack for other components of your infrastructure may be a good way to consolidate monitoring across your systems.
In this session we are going to cover both tweaking your PMM installation for production and options to extend its default capabilities.
MyRocks is widely used in Alibaba Cloud products, including RDS MySQL and HybirdDB for MySQL. We have many improvements on MyRocks, such as
Online backup MyRocks
A new feature, secondary clustering index
Optimizing auto increment insert
Optimizing replace into
The MariaDB Foundation has started a new effort to coordinate finding and fixing security vulnerabilities in the code base of MariaDB and MySQL.
In this talk, the current activities of the MariaDB Foundation's security efforts are presented, including for example, the recently devised Responsible Disclosure Policy and Hacker One bug bounty program, as well as future plans for continuous and automated security testing to be baked into our Continuous Integration and Testing pipelines.
As one of the world's most popular piece of server software and part of critical infrastructure, hosting vast amounts of databases, it is crucially important that it stays safe and operates without security issues. History has shown us we cannot trust any piece of software to be inherently secure, thus any project must have proper vulnerability disclosure and management procedures, be eager to collaborate with the security community and follow disclosure guidelines, as well as pro-actively look for security bugs in their own code base.
Learn how to monitor PostgreSQL using Percona Monitoring and Management (PMM) so that you can:
* gain greater visibility of performance and bottlenecks PostgreSQL
* Consolidate your PostgreSQL servers into the same monitoring platform you already use for MySQL and MongoDB
* Respond more quickly and efficiently in Severity 1 issues
We'll show how using PMM's native support for PostgreSQL (as of Release 1.14) that you can have PostgreSQL integrated in only minutes!
After working with MongoDB on different projects for more than 5 years, I've collected a few interesting tips/scripts that may help you with your projects and day-to-day tasks. These are some the areas I'll be referring to:
-Sharded clusters maintenance
Learn about different use cases for Percona Server for MongoDB on DC/OS, and see just how easy it is to configure a Percona Server for MongoDB cluster on this enterprise-grade platform.
Lots of database operations require the use of temporary tables. MySQL creates these temporary tables transparently, but this behaviour can be tuned and configured for optimal performance.
MySQL 8 introduces a new engine for in-memory temporary tables, that can replace the Memory engine used in previous releases.
In this session, we will offer an overview of the operations that require temporary tables and present the configuration options that rule this feature.
We will also show some benchmarks to compare the performance of the different internal temporary table engines.
Lag in asynchronous replication is proportional to the gap in throughput between the master and slave. While a great deal of work has been done to make masters faster on multi-core machines, slaves have been left behind. Today, the master-slave throughput gap is essentially a parallelism gap. Parallel application of a serial log of transactions is not trivial.
In this work, our aim was to match the slave's throughput with the master's instead of just making it 'X' times faster. We use information already present in row based binary logs to extract fine-grained dependencies between row mutations which enables the slave to schedule transactions to multiple threads just like the master would have. We also explore how we can relax the transaction execution model on the slave to make them more lightweight and boost single threaded performance.
TiDB is an open source distributed scalable hybrid transactional and analytical processing (HTAP) database built by PingCAP. It also speaks the MySQL protocol and uses RocksDB as the underlying storage engine!
This talk provides an introduction and overview of TiDB, tailored for those with a strong background in MySQL. I will use MySQL as an example to explain various implementation details of TiDB, and translate terminology to MySQL/InnoDB terms.
A new DB stack needs to be deployed and a decision needs to be made where to deploy it ...
Use dedicated servers, on-prem or via an IaaS provider, as that is how and where the application is running, or maybe because there is extensive config management available that will make the job quick and easy?
Or go DBaaS because that is the future and a lot of companies are taking that route? Or the thought of not having to worry about all of the Operating system quirks, including security issues, is really appealing to you?
In this talk, we're going to have a look at the benefits and restrictions of Roll-your-Own vs DBaaS, more specifically Amazon RDS/Aurora and Google CloudSQL
Security should always be one of your top concerns for any database deployment. In this talk I will discuss the top 5 things you can do to secure your PostgreSQL database. Using real world use cases and common practices, I will outline what is available to you as an IT professional to ensure you can make your PostgreSQL database secure. The session will focus on versions 9.6 and 10.