by Matt Yonkovit | Apr 14, 2020 | Database Trends, Open Source
A four-part blog series by Matt Yonkovit, Percona Chief Experience Officer. Read Matt’s other blogs in this series – “Baseline Data and the Size of the Market”, “The Most Popular Open Source Databases 2020”, and “When is Open...
by Matt Yonkovit | Apr 7, 2020 | Database Trends, Open Source
A four-part blog series by Matt Yonkovit, Percona Chief Experience Officer. Read Matt’s other blogs in this series – “Migrating from Proprietary Software to Open Source”, “The Most Popular Open Source Databases 2020′, and...
by Rachel Pescador | Mar 31, 2020 | Database Trends, Open Source
Share your knowledge and experience to help inform the open source community! In 2019, we ran our first ever Open Source Data Management Software Survey, resulting in some interesting data on the state of the open source database market. Some notable statistics...
by IP | Mar 20, 2020 | Open Source
While we can act on the advice of the WHO and our governments, there’s no doubt that COVID-19 leaves many of us feeling pretty helpless. And while it might seem a small personal contribution, as a community we can lend our computing power to Folding@home, an open...
by Rachel Pescador | Feb 25, 2020 | Cloud, Database Trends, Percona Services, Percona Software
The race to the cloud continues gaining pace, and many businesses have already enthusiastically embraced the new opportunities and efficiencies the cloud can bring. But, for those companies with more traditional technology structures and a lack of cloud knowledge...
by Rachel Pescador | Jan 27, 2020 | Database Trends, Open Source, Percona Services, Percona Software
What is Vendor Lock-In? When a company becomes too reliant upon a single vendor or solution, they can find themselves victims of vendor lock-in. Vendor lock-in is a common problem for companies that use proprietary software, databases, or platforms. Issues arise when...
by Evgeniy Patlan | Jan 2, 2020 | MySQL, Open Source
For Linux, the most common way to distribute software is binary packages in the rpm or deb format. Most packages are included in the official distribution repositories or 3rd party software repositories. Nevertheless, there are some cases where you need to...
by Michael Patrick | Jan 2, 2020 | Database Trends, Insight for DBAs, Insight for Developers, Open Source
In your organization, who decides what database platform will be utilized for that new application being built? For many groups, that decision is made by the Development Team while for others, it is the Database Team. But, which is best equipped to make that...
by Matt Yonkovit | Dec 10, 2019 | Database Trends, Open Source
If you work in open source, we’re going to bet you may not know that what you do every day affects a billion people. Surprised? You shouldn’t be! In fact, that number is most likely even larger than that, given the popularity of open source software throughout...
by Kenn Takara | Oct 4, 2019 | Insight for DBAs, MySQL, Percona Software
Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make the process more robust and easier to use. mysqldump and rsync are no longer supported SST methods. Support for mysqldump was deprecated starting with...
by Matt Yonkovit | Mar 13, 2018 | Insight for DBAs, Percona Live, Security
In this post, we discuss database security compliance, what you should be looking at and where to get more information. As Percona’s Chief Customer Officer, I get the opportunity to talk with a lot of customers. Hearing about the problems that both their technical...
by Dave Avery | Mar 7, 2018 | Percona Live, PostgreSQL, Security
Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post...
by Sveta Smirnova | Feb 28, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Performance Schema for MySQL Troubleshooting on Thursday, March 1, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5). Register Now Performance Schema, first introduced in version 5.5,...
by Peter Zaitsev | Feb 28, 2018 | Insight for DBAs, Monitoring, MySQL
In this blog post, I’ll look at how you can analyze raw MySQL query logs with ClickHouse. For typical query performance analyses, we have an excellent tool in Percona Monitoring and Management. You may want to go deeper, though. You might be longing for the...
by Borys Belinsky | Feb 27, 2018 | MySQL, Percona Events, Percona Software
The latest release of Percona Monitoring and Management (PMM) 1.8.0 is available as of February 27, 2018. Percona Monitoring and Management is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own...
by Dave Avery | Feb 21, 2018 | Cloud, MariaDB, MongoDB, MySQL, Percona Live
The conference session schedule for the seventh annual Percona Live 2018 Open Source Database Conference, taking place April 23-25 at the Santa Clara Convention Center in Santa Clara, CA is now live and available for review! Advance Registration Discounts can be...
by Dave Avery | Feb 8, 2018 | Cloud, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live
Percona has revealed the line-up of in-depth tutorials for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, Calif. Secure your spot now with Advanced Registration prices...
by Ananias Tsalouchidis | Feb 7, 2018 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For...
by Michael Coburn | Feb 6, 2018 | Monitoring, MySQL, Open Source, Percona Software
In this blog post, we’ll introduce how you can look at some experimental Percona Monitoring and Management (PMM) features using Percona Labs builds on GitHub. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools...
by Peter Zaitsev | Feb 5, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look into four ways MySQL executes GROUP BY. In my previous blog post, we learned that indexes or other means of finding data might not be the most expensive part of query execution. For example, MySQL GROUP BY could potentially be...
