by Mike Grayson | Oct 16, 2020 | Insight for DBAs, MongoDB, Percona Software
MongoDB is one of the most popular databases and is one of the easiest NoSQL databases to set up for a DBA. Oftentimes, relational DBAs will inherit MongoDB databases without knowing all there is to know about MongoDB. I encourage you to check out our Percona blogs...
by Michael Patrick | Apr 8, 2020 | Database Trends, Insight for DBAs, Percona Services
As I interface with large clients as a Technical Account Manager (TAM) at Percona, one thing I have noticed is the evolution of the DBA role. With the rise of the cloud, DBAs seem to be spending less time doing traditional DBA roles of performance tuning, configuring...
by Yves Trudeau | Jan 22, 2020 | Insight for DBAs, MySQL, Percona Software, Storage Engine
As the second part of the earlier post Give Love to Your SSDs – Reduce innodb_io_capacity_max! we wanted to put together some concepts on how InnoDB flushing works in recent Percona Server for MySQL versions (8.0.x prior to 8.0.19, or 5.7.x). It is important to...
by Jobin Augustine | Jan 17, 2020 | Insight for DBAs, PostgreSQL
Python 2 has officially completed its life as of Jan 1st, 2020 and the Python 2.x branch will not be maintained anymore. You might be seeing repeated notices of deprecation in log files and terminals like: Shell DEPRECATION: Python 2.7 will reach the end of its life...
by Alkin Tezuysal | Jan 15, 2020 | Cloud, Insight for DBAs, MySQL
In this blog post, we will continue to explore Vitess and test an example database provided in its repository. This is Part III of the previously discussed installation of Vitess on minikube environment, so please make sure to follow those steps to bring the cluster...
by Alok Pathak | Jan 14, 2020 | Cloud, Insight for DBAs, MySQL
The promise of DBaaS like RDS is to reduce operational overhead (among other things) and one of the stellar cases is upgrades (major and minor). The suggested procedure involves just a couple of steps. For example, using AWS Console, you can enable “Auto minor...
by Yves Trudeau | Dec 18, 2019 | Insight for DBAs, MySQL, Storage Engine
The innodb_io_capacity and innodb_io_capacity_max are often misunderstood InnoDB parameters. As consultants, we see, at least every month, people setting this variable based on the top IO write specifications of their storage. Is this a correct choice? Is it an...
by Marco Tusa | Aug 13, 2019 | Insight for DBAs, MySQL
by Colin Charles | Jan 22, 2018 | Insight for DBAs, MariaDB, MySQL, Open Source, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents Differences Between MariaDB and MySQL on Wednesday, January 24, 2018, at 7:00 am PST (UTC -8) / 10:00 am EST (UTC -5). Register Now Tags: MariaDB, MySQL, Percona Server for MySQL, DBA, SysAdmin, DevOps...
by Michael Coburn | Jan 16, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Software, Webinars
Join Percona’s Product Manager Michael Coburn as he presents MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) Part 2 on Thursday, January 18, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Register Now Tags: Percona...
by Bradley Mickel | Sep 14, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll discuss the MySQL default configuration changes between 5.6 and 5.7. MySQL 5.7 has added a variety of new features that might excite you. However, there are also changes in the current variables that you might have overlooked. MySQL 5.7...
by Dave Avery | May 18, 2016 | MongoDB, MySQL
Please join Alexander Rubin, Percona Principal Consultant, for his webinar MongoDB administration for MySQL DBA on Thursday, May 19 at 10 am PDT (UTC-7). If you are a MySQL DBA and want to learn MongoDB quickly – this webinar is for you. MySQL and MongoDB share...
by Kortney Runyan | Oct 16, 2015 | Percona Events
The MySQL 101 track was introduced at the 2015 Percona Live MySQL Conference & Expo in Santa Clara, California. This track was tailored specifically for software developers and other specialists with technical backgrounds wanting to acquire the basic skills needed...
by David Busby | Dec 23, 2014 | Insight for DBAs, MySQL, Security
This is a long overdue blog post from London’s 44con Cyber Security conference back in September. A lot of old memories were brought to the front as it were; the one I’m going to cover in this blog post is: file carving. So what is file carving? despite...
