As a support engineer, every day I get dozens of pt-stalk captures from our customers containing samples of iostat, vmstat, top, ps, SHOW ENGINE INNODB STATUS, SHOW PROCESSLIST and a multitude of other diagnostics outputs.
These are the tools of the trade for performance and troubleshooting, and we must learn to digest these outputs in an effective and systematic way. This allows us to provide high-quality service to a large...
ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has already proved itself ready for the serious workloads.
We will talk about ClickHouse in general, some internals and why it is so fast. ClickHouse works in conjunction with MySQL -- traditionally weak for analytical workloads -- and this presentation demonstrates how to make the two systems work...
Are they syntactically similar? Where do these two query languages differ? Why would I use one over the other?
MariaDB is on the path of gradually diverging from MySQL. One obvious example is the internal data dictionary currently under development for MySQL 8. This is a major change to the way metadata is stored and used within the server, and MariaDB doesn’t have an equivalent feature. Implementing this feature could mark the...
Successful applications often become limited by MySQL performance. Michael will show you how to get great MySQL performance using Percona Monitoring and Management (PMM). There will be a demonstration of how to leverage the combination of the query analytics and metrics monitor when troubleshooting MySQL performance issues. We'll review the essential components of PMM, and use some of the most common database slowness cases as examples...
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL and MongoDB, Percona XtraBackup, Percona Toolkit, Percona XtraDB Cluster and Percona Monitoring and Management.
During this webinar Peter will talk about newly released features in Percona software, show a few quick demos and share with you highlights from the Percona open source software roadmap....
MongoDB has its own commands and function structures to ask the database to do work. In this talk, we will discuss how queries, updates, deletes and inserts work. However, we will go beyond these actions and also review what operators you should and shouldn’t use, and how they might actually drive your schema choices. Then we will talk about operationally sound ways for bulk deleting and inserting when you want to limit the impact on...
Backups are crucial in a world where data is digital and uptime is revenue. Environments are no longer bound to traditional data centers, and span multiple cloud providers as well a plethora of heterogeneous environments. We need bulletproof backups and impeccable recovery processes. This talk aims to answer the question "How should I backup my MySQL databases?" by providing 3-2-1 backup designs, best practices and real-world solutions...
MongoDB security breaches have regularly been in the news. What isn’t mentioned, however, is that it’s all been avoidable. Simple mistakes add up to giant headaches, and loss of management and customer confidence in you (the DBA). We will cut through the marketing hype and give you a real-world playbook on what to do and how to do it when securing your system. This includes enabling authentications, understand and building custom roles...
Clients require strong security measures for PCI, HIPAA or PHI. These standards require data managed by MySQL to be encrypted "at rest." InnoDB’s built-in encryption features work, but there are some caveats to that solution.
In this talk, you'll see how to encrypt your entire disk to protect everything from data, redo logs and binary logs.
In the case of a failure, do you know how long it will take to restore your database? Do you know how old the backup will be? In this presentation, we will cover the basics of best practices for backup, restoration and business continuity. Don’t put your company on the line due to bad data retention and backup policies.
For general inquiries, please send us your question and someone will contact you.
