Please watch Percona’s Senior Software Engineer, Ibrar Ahmed as he presents the “PostgreSQL High-Performance Tuning and Optimization" webinar.
PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with least resources can run it. PostgreSQL does not give optimum performance on high permanence machines because it is not using the...
Michael Benshoof, Technical Account Manager at Percona, brings his talk, Schema Review 101: How and What You Should Be Looking at.
The goal of this talk is to review the key features that would be part of a schema review, including things such as largest tables, index issues and table activity. Since learning how to profile your data is important when looking at capacity planning, architecture, and application design, I'll also...
Percona Server 8.0 features you always wanted but were afraid to ask for: SEQUENCE_TABLE() and Data Masking.
In the first part of this talk, we will give you a brief introduction to SEQUENCE_TABLE() - a new MySQL table function available in Percona Server 8.0.20-11. We will go through a few examples of how it can be used to generate simple integer sequences, sets of random numbers, pseudo-random string values, etc. As a bonus, we...
It is common knowledge that built-in asynchronous active-active replication is not safe. I remember times when the official MySQL User Reference Manual stated that such an installation is not recommended for production use. Some experts repeat this claim even now.
While this statement is generally true, I worked with thousands of shops that successfully avoided asynchronous replication limitations in active-active setups.
MySQL/InnoDB constantly performs merge and split operations, and you have very limited visibility of them. But they can bite you, and bite hard, especially if using a spindle storage VS SSD (which have different issues, by the way).
This is an important point to keep in mind. In InnoDB you cannot have fragmented records, but you can have a nightmare at the page-extent level.
The sad story is there is also very little we...
Broken MySQL means broken Application, so maintaining insights in MySQL operational performance is critical.
Thankfully MySQL 8 offers a lot in terms of observability to resolve problems quickly and get great insights into opportunities for optimization. In this talk, we will cover most important observability improvements in MySQL 8 ranging from Performance Schema and Information Schema to enhanced error logging and optimizer...
MongoDBBackup and Recovery
- Importance of securing database and access restriction
- Benefits of centralized access control...
MongoDBSecurityPercona Open Source Software