by Peter Zaitsev | Jan 3, 2020 | MySQL, Open Source
In MySQL 8, Information Schema was basically re-written to utilize the all-New Data Dictionary which made it faster and better in many ways. Yet it also introduces some very counterintuitive behaviors when it comes to how actual and consistent data is.Here is a simple... by Peter Zaitsev | Nov 22, 2019 | Monitoring, MySQL, Percona Software
As Grafana powers our star product – Percona Monitoring and Management (PMM) – we have developed a lot of experience creating Grafana Dashboards over the last few years. In this article, I will share some of the considerations for designing... by Peter Zaitsev | Nov 19, 2019 | MySQL
I often need to install a certain version of MySQL, MariaDB, or Percona Server for MySQL to run some experiments, whether to check for behavior differences or to provide tested instructions. In this blog series, I will look into how you can install MySQL, MariaDB, or... by Peter Zaitsev | Oct 31, 2019 | Percona Services, Percona Software
One of the great things about Percona, and a Percona Support contract, is that we not only guarantee application performance but we also provide bug fixes for covered software—and not just advice on how to use it. This is most likely missing from most... by Peter Zaitsev | Oct 24, 2019 | Percona Events
Every fall I enjoy traveling to key events to meet Percona’s customers and software users. Аfter meetup in Ryazan on November 5th sponsored by HighLoad++ in Moscow along with six other Percona experts. My talks will be: BpfTrace – Finally a... by Peter Zaitsev | Oct 23, 2019 | Monitoring, MySQL
MySQL Workbench is a great multi-purpose GUI tool for MySQL, which I think is not marketed enough by the MySQL team and is not appreciated enough by the community for what it can do. MySQL Workbench Licensing MySQL Workbench is similar to MySQL Server and is an... by Peter Zaitsev | Sep 25, 2019 | Monitoring, Percona Software
As the saying goes, a picture is worth 1000 words – and this is why we don’t just talk about Percona Monitoring and Management (PMM) but also have a demo which allows you to explore many PMM features without having to install it.Though there is only so... by Peter Zaitsev | Aug 21, 2019 | Cloud, Percona Software
While testing our PMM2 Beta and other Dockerized applications, you may want to clean up your docker install and start from scratch. If you’re not very familiar with Docker it may not be that trivial. This post focuses on cleaning up everything in docker so you... by Peter Zaitsev | Aug 14, 2019 | MySQL, Percona Software
While we often run MySQL on larger scale systems in Production for Test and Dev, sometimes we want to run MySQL on the tiniest cloud instances possible or just run it on our laptops. In these cases, MySQL 8 and MySQL 5.7 memory consumption is quite important.In... by Peter Zaitsev | Jun 14, 2019 | Percona Events
Not long after this year’s SouthEast LinuxFest 2019 in mid-June I’ll be speaking at a series of open source database meetups in Russia & UK, plus a big data MeetUp in France. At Percona we’re well aware of the growing number of Percona software... by Peter Zaitsev | Apr 30, 2019 | MySQL, Webinars
Join Percona CEO Peter Zaitsev and PingCAP Senior Product and Community Manager Morgan Tocker as they present How to horizontally scale MySQL with TiDB while avoiding sharding issues on Wednesday, May 1st, 2019, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). View... by Peter Zaitsev | Mar 4, 2019 | Cloud, Insight for DBAs, MySQL, Webinars
Join Percona CEO Peter Zaitsev as he presents High Availability and Disaster Recovery in Amazon RDS on Wednesday, March 6th, 2019, at 11:00 AM PST (UTC-8) / 2:00 PM EST (UTC-5). View the Recording In this hour-long webinar, Peter describes the differences between high... by Peter Zaitsev | Feb 15, 2019 | Benchmarks, Insight for DBAs, MySQL
While implementing ClickHouse for query executions statistics storage in Percona Monitoring and Management (PMM), we were faced with a question of choosing the data type for metrics we store. It came down to this question: what is the difference in performance... by Peter Zaitsev | Feb 5, 2019 | Insight for DBAs, MongoDB, MySQL, Percona Software, Webinars
Join Percona CEO Peter Zaitsev as he presents Percona Software News and Roadmap Update on Wednesday, February 6, 2019, at 11:00 AM PST (UTC-8) / 2:00 PM EST (UTC-5). View the Recording Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona... by Peter Zaitsev | Jan 9, 2019 | Cloud, Insight for DBAs, MySQL
One of the most exciting features Amazon Aurora Serverless brings to the table is its ability to go to sleep (pause) when idle. This is a fantastic feature for development and test environments. You get access to a powerful database to run tests quickly, but it goes... by Peter Zaitsev | Jan 4, 2019 | Cloud, Insight for DBAs, MySQL
Amazon Aurora with MySQL Compatibility comes in three editions which, at the time of writing, have quite a few differences around the features that they support. Make sure you don’t assume the newer Aurora 2.x supports everything in Aurora 1.x. On the... by Peter Zaitsev | Dec 17, 2018 | Cloud, MySQL
When I attended AWS Re:Invent 2018, I saw there was a lot of attention from both customers and the AWS team on Amazon RDS Aurora Serverless. So I decided to take a deeper look at this technology, and write a series of blog posts on this topic.In this first... by Peter Zaitsev | Dec 12, 2018 | Cloud, Hardware and Storage, MySQL
At AWS Re:Invent 2018 there were many great announcements of AWS New Services and New Features, but one basic feature that I’ve been waiting for years to be released is still nowhere to be found.AWS Elastic Block Storage (EBS) is great and... by Peter Zaitsev | Dec 11, 2018 | Insight for Developers, MySQL, Webinars
Please join Percona’s CEO Peter Zaitsev as he presents MySQL 8 for Developers on Wednesday, December 12th, 2018 at 11:00 AM PST (UTC-7) / 2:00 PM EST (UTC-5). Register Now There are many great new features in MySQL 8, but how exactly can they help your... by Peter Zaitsev | Oct 30, 2018 | MariaDB, MongoDB, MySQL, Open Source, Percona Software, PostgreSQL
As MongoDB® has changed their license from AGPL to SSPL many are concerned by this change, and by how sudden it has been. Will SSPL be protective enough for MongoDB, or will the next change be to go to an altogether proprietary license? According to our poll,...