by Borys Belinsky | Oct 25, 2017 | Monitoring, MySQL, Percona Software
In this blog post, we’ll look at Percona Monitoring and Management’s pmm-admin list command. The pmm-admin list command shows all monitoring services you have added using the pmm-admin add command. Starting with version 1.4.0, Percona Monitoring and...
by Tyler Duzan | Oct 19, 2017 | Cloud, Insight for DBAs, Insight for Developers, MongoDB, MySQL
Percona latest blog poll asks how you currently host applications and databases. Select an option below, or leave a comment to clarify your deployment! With the increased need for environments that respond more quickly to changing business demands, many enterprises...
by Matthew Boehm | Oct 18, 2017 | Insight for DBAs, MySQL, Open Source, Webinars
Join Percona’s Senior Architect, Matthew Boehm, as he presents What You Need to Get the Most Out of Indexes – Part 2 webinar on Thursday, October 19, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now Proper indexing is key to database performance. Finely tune...
by Colin Charles | Sep 29, 2017 | MariaDB, MongoDB, MySQL, Open Source, Percona Live
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Europe 2017 Dublin We’ve spent a lot of time in the last few months organizing Percona Live Europe...
by Yves Trudeau | Sep 22, 2017 | Insight for DBAs, MySQL
For most people (including me until recently) database XA transactions are a fuzzy concept. In over eight years with Percona, I have never had to deal with XA transactions. Then a few weeks ago I got two customers having issues with XA transactions. That deserves a...
by Dave Avery | Jul 25, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s, Architect, Manjot Singh as he presents Database Backup and Recovery Best Practices (with a Focus on MySQL) on Thursday, July 27, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now In the case of a failure, do you know how long it will take to...
by Dave Avery | Apr 25, 2017 | Cloud, MySQL, Percona Live, PostgreSQL
The Percona Live Open Source Data Conference 2017 day one is rolling right along, and we’re already in the afternoon sessions. In this blog, we’ll look at Citus Data’s presentation on how to design your SaaS database to scale with Postgres. If you’re...
by Siddhant Sawant | Mar 21, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at how to get rid of the unused Foreign Key (FK) constraint and/or related columns/keys with the help of pt-online-schema-change and the power of its plugins. Before we proceed, here is a useful blog post written by Peter Zaitsev...
by Peter Zaitsev | Feb 16, 2017 | MySQL
In this blog we’ll look at the results from Percona’s blog poll on what programming languages you’re using for backend development. Late last year we started a poll on what backend programming languages are being used by the open source community. The three...
by Dave Avery | Feb 2, 2017 | MySQL, Percona Events
Percona is calling on you! Vote for Percona for Database of the Year in LinuxQuestions.org Members Choice Awards 2016. Help Percona get recognized as one of the best database options for data performance. Percona provides free, fully compatible, enhanced, open source...
by Przemysław Malkowski | Dec 27, 2016 | Insight for DBAs, Insight for Developers, MongoDB, MySQL
This blog discusses how to prepare your database for the new leap second coming in the new year. At the end of this year, on December 31, 2016, a new leap second gets added. Many of us remember the huge problems this caused back in 2012. Some of our customers asked...
by Dave Avery | Dec 21, 2016 | MongoDB, MySQL
Take Percona’s blog poll on what programming languages you’re using for backend development. While customers and users focus and interact with applications and websites, these are really just the tip of the iceberg for the whole end-to-end system that allows...
by Rick Golba | Dec 14, 2016 | Insight for DBAs, MongoDB, MySQL
In this blog post, we’ll discuss the differences between row store and column store databases. Clients often ask us if they should or could be using columnar databases. For some applications, a columnar database is a great choice; for others, you should stick...
by Dave Avery | Sep 21, 2016 | Insight for DBAs, MongoDB, MySQL
Join Percona’s Sr. Technical Operations Architect, Tim Vaillancourt on Thursday, September 22, at 10 am PDT (UTC-7) for the webinar Black Friday and Cyber Monday: How to Avoid an E-Commerce Disaster. This webinar will provide some best practices to ensure the...
by Tim Vaillancourt | Sep 14, 2016 | Insight for DBAs, MongoDB, MySQL, Webinars
This blog post discusses how you can protect your e-commerce database from a high traffic disaster. Databases power today’s e-commerce. Whether it’s listing items on your site, contacting your distributor for inventory, tracking shipments, payments, or customer data,...
by Dave Avery | Aug 2, 2016 | MySQL, Security
Take Percona’s database security downtime poll. As Peter Zaitsev mentioned recently in his blog post on database support, the data breach costs can hit both your business reputation and your bottom line. Costs vary depending on the company size and market,...
by Dave Avery | Aug 2, 2016 | Insight for DBAs, Insight for Developers
This blog reports the results of Percona’s high availability poll. High availability (HA) is always a hot topic. The reality is that if your data is not available, your customers cannot do business with you. In fact, estimates show the average cost of downtime...
by Dave Avery | Jan 28, 2016 | MySQL, Percona Software
Percona is calling on you! Vote Percona for Database of the Year in LinuxQuestions.org Members Choice Awards 2015. Help our Percona Server get recognized as one of the best database options for data performance. Percona Server is a free, fully compatible, enhanced,...