by Tim Vaillancourt | Apr 18, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Webinars
Please join Percona’s Senior Technical Operations Architect, Tim Vaillancourt as he presents Running MongoDB in Production, Part 1 on Thursday, April 19, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Are you a seasoned MySQL DBA that needs to add MongoDB to...
by David Ducos | Apr 17, 2018 | MySQL
In this blog post, we’ll look at using hints to analyze queries. There are a lot of things that you can do wrong when writing a query, which means that there a lot of things that you can do to make it better. From my personal experience there are two things you...
by Tibor Korocz | Apr 17, 2018 | Insight for DBAs, MySQL, Percona Software, ProxySQL, Webinars
Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial on Wednesday, April 18, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4). Never used Percona XtraDB Cluster before? Come join this 45-minute tutorial where we will...
by Dmitriy Kostiuk | Apr 16, 2018 | Insight for DBAs, MariaDB, MySQL
Due to continuous development and improvement, Percona Server for MySQL incorporates a number of improvements related to binary log handling and replication. This results in replication specifics, distinguishing it from MySQL Server. Temporary tables and mixed logging...
by Dmitriy Kostiuk | Apr 16, 2018 | Percona Software, ProxySQL
ProxySQL 1.4.7, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by Daniel Kowalewski | Apr 16, 2018 | Cloud, Webinars
Please join Percona’s Senior Technical Operations Engineer, Daniel Kowalewski as he presents Which Amazon Cloud Technology Should You Chose? RDS? Aurora? Roll Your Own? on Tuesday, April 17, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Are you running on...
by Aayushi Mangal | Apr 13, 2018 | Insight for DBAs, Insight for Developers, MongoDB
In this blog post, we will look at MongoDB replica set tag sets, which enable you to use customized write concern and read preferences for replica set members. This blog post will cover most of the questions that come to mind before using tag sets in a production...
by Colin Charles | Apr 13, 2018 | Cloud, MariaDB, MongoDB, MySQL, Percona Software, ProxySQL, Storage Engine
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live is just over a week away — there’s an awesome keynote lineup, and you really should register. Also...
by Dmitriy Kostiuk | Apr 12, 2018 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.14-2.12 on April 12, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database...
by Przemysław Malkowski | Apr 12, 2018 | Insight for DBAs, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More In this blog post, I’ll look at point-in-time recovery (PITR) options for MySQL, MariaDB and...
by Borys Belinsky | Apr 12, 2018 | MySQL, Percona Software
Percona announces the release of Percona Monitoring and Management 1.9.1. PMM (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 environment for maximum security...
by Dave Avery | Apr 12, 2018 | Cloud
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 Jericho Rivera | Apr 11, 2018 | Insight for DBAs, MySQL, ProxySQL
In this blog post, we demonstrate a new feature in ProxySQL Admin: support for multiple clusters. In a previous blog post, Ramesh and Roel introduced a new tool that helps configured Percona XtraDB Cluster nodes into ProxySQL. However, at that time it only worked for...
by Laurie Coffin | Apr 11, 2018 | Percona Live
We’ve posted the Percona Live 2018 keynote addresses for the seventh annual Percona Live Open Source Database Conference 2018, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, CA. This year’s keynotes explore topics ranging...
by Francisco Bordenave | Apr 10, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at options for migrating database charsets to utf8mb4. Migrating charsets, in my opinion, is one of the most tedious tasks in a DBA’s life. There are so many things involved that can screw up our data, making it work is always...
by Sveta Smirnova | Apr 10, 2018 | MySQL, Webinars
Percona’s Principal Support Engineer, Sveta Smirnova presents the webinar MySQL Test Framework for Troubleshooting on April 12, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). MySQL Test Framework (MTR) provides a unit test suite for MySQL. MySQL Server...
by Adamo Tonete | Apr 9, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Percona Software
In this blog post, we will cover how to start MongoDB database software in the three most used platforms: Windows/Linux/MacOS. If you have just started with NoSQL databases, you might wonder how to evaluate if MongoDB is a good fit for your application. Percona...
by Aayushi Mangal | Apr 9, 2018 | Insight for DBAs, Insight for Developers, MongoDB
In this blog post, we will look at how chunks split and migrate in MongoDB sharding. Sometimes even using good shard keys can create imbalanced chunks. Below, we’ll look at how jumbo chunks affect MongoDB sharding, how they are created and why they need to split...
by Tim Vaillancourt | Apr 6, 2018 | Insight for DBAs, MongoDB, Percona Software
In this blog post, we will discuss the MongoDB Hot Backup feature in Percona Server for MongoDB and how it can help you get a safe backup of your data with minimal impact. Percona Server for MongoDB Percona Server for MongoDB is Percona’s open-source fork of...
by Przemysław Malkowski | Apr 6, 2018 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll look at how to approach pt-table-checksum errors. pt-table-checksum is one of the most popular tools in Percona Toolkit, and it is widely used to identify data differences between masters and slaves. Therefore, as Percona Support...
