Videos from Percona

MongoDB Sharded Cluster is very well established to handle huge amounts of data across geographically separate data centers. Sharding the data across the shards evenly or specific to region/data centers based on the application requests are important. But sometimes the sharded cluster setup is not well designed, which leads to data being distributed improperly across shards so the application fails to serve the request within the...

Visualizing profiling information can be a very powerful tool for performance diagnostics, specially if we zoom right into the problem. Flame graphs were developed for this purpose and we use them on a daily basis at Percona to successfully solve complex performance issues. In this presentation, attendees will learn advanced techniques for profiling with performance and visualizing those profiles with flame graphs, as well as other...

It has been an exciting year in the open source database industry, with more choice, more cloud, and key changes in the industry. In his keynote address, Peter Zaitsev of Percona will dive into the key developments over the last year, including the most important open source database software releases, the significance of cloud-native solutions in a multi-vendor multi-cloud world, the new criticality of security challenges, the...

It's easy for Java developers (and users of other OO languages) to mix object-oriented thinking and imperative thinking. But when it comes to writing SQL the nightmare begins! Firstly, SQL is a declarative language and it has nothing to do with either OO or imperative thinking. It is relatively easy to express a condition in SQL but it is not so easy to express it optimally - and even worse to translate it to the OO paradigm. Secondly,...