by Borys Belinsky | Aug 17, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.6.41-84.1 on August 17, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.6.41, including all the bug fixes in it. Percona Server for MySQL...
by Borys Belinsky | Aug 17, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.5.61-38.13 on August 17, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.5.61, including all the bug fixes in it. Percona Server for...
by Avinash Vallarapu | Aug 17, 2018 | Insight for DBAs, MySQL, PostgreSQL
Replication is one of the well-known features that allows us to build an identical copy of a database. It is supported in almost every RDBMS. The advantages of replication may be huge, especially HA (High Availability) and load balancing. But what if we need to build...
by Colin Charles | Aug 17, 2018 | Cloud, MariaDB, MongoDB, MySQL, Percona Events
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Beyond the MongoDB content that will be at Percona Live Europe 2018, there is also a bit of an agenda for MongoDB Europe...
by Corrado Pandiani | Aug 16, 2018 | Insight for Developers, MongoDB, Open Source, Percona Software
by Tim Vaillancourt | Aug 15, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Percona Events, Percona Software, Webinars
Please join Percona’s Sr. Technical Operations Architect Tim Vaillancourt as he presents Developing an App on MongoDB: Tips and Tricks on Thursday, August 16th, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now A lot of developers prefer using MongoDB...
by Lorraine Pocklington, Community Manager | Aug 14, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Open Source, Percona Events
Recently, we initiated a new project, the Open Source Database Community Blog. One way to think of this is as an online, year round version of the Percona Live conferences. If you have a story to tell, an experience to share, or a lesson to be learned send it along....
by Dimitri Vanoverbeke | Aug 13, 2018 | Cloud, MySQL, Webinars
Please join Percona’s Solution Engineer, Dimitri Vanoverbeke as he presents Amazon Migration Service: The Magic Wand to Migrate Away from Your Proprietary Environment to MySQL on Tuesday, August 14th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4).
by Avinash Vallarapu | Aug 10, 2018 | Insight for DBAs, PostgreSQL
The performance of a PostgreSQL database can be compromised by dead tuples since they continue to occupy space and can lead to bloat. We provided an introduction to VACUUM and bloat in an earlier blog post. Now, though, it’s time to look at autovacuum for...
by Colin Charles | Aug 10, 2018 | MariaDB, MongoDB, MySQL, Percona Events, PostgreSQL, ProxySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. The call for submitting a talk to Percona Live Europe 2018 is closing today, and while there may be a short extension, have...
by Yves Trudeau | Aug 9, 2018 | MySQL, Percona Software, Security
Recently, I wrote a blog post showing how to enforce SELinux with Percona XtraDB Cluster (PXC). The Linux distributions derived from RedHat use SELinux. There is another major mandatory discretionary access control (DAC) system, AppArmor. Ubuntu, for example, installs...
by Tate McDaniel | Aug 9, 2018 | Cloud, MySQL, Percona Events, Percona Software, Webinars
Please join Autodesk’s Senior Database Engineer, Vineet Khanna, and Percona’s Sr. MySQL DBA, Tate McDaniel as they present Migrating to Aurora and Monitoring with PMM on Thursday, August 9th, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now Amazon Web...
by Peter Zaitsev | Aug 9, 2018 | Cloud, MySQL, Percona Software
When deployed through Docker Percona Monitoring and Management (PMM) uses environment variables for its configuration For example, if you want to adjust metrics resolution you can pass -e METRICS_RESOLUTION=Ns as an option to the docker run command: Shell docker...
by Peter Zaitsev | Aug 7, 2018 | Benchmarks, Insight for DBAs, MongoDB, MySQL, Percona Software
In Percona Monitoring and Management (PMM) 1.13 we have adopted Prometheus 2, and with this comes a dramatic improvement in resource usage, along with performance improvements! What does it mean for you? This means you can have a significantly larger number of servers...
by Vinicius Grippa | Aug 7, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll discuss how to set a replication from MySQL 8.0 to MySQL 5.7. There are some situations that having this configuration might help. For example, in the case of a MySQL upgrade, it can be useful to have a master that is using a newer version of...
by Avinash Vallarapu | Aug 6, 2018 | Insight for DBAs, PostgreSQL
Implementation of MVCC (Multi-Version Concurrency Control) in PostgreSQL is different and special when compared with other RDBMS. MVCC in PostgreSQL controls which tuples can be visible to transactions via versioning. What is versioning in PostgreSQL? Let’s...
by Tibor Korocz | Aug 6, 2018 | MySQL, Percona Software, ProxySQL, Webinars
Please join Percona’s Architect, Tibi Köröcz as he presents Utilizing ProxySQL for Connection Pooling in PHP on Tuesday August 14, 2018, at 8:00 am PDT (UTC-7) / 11:00 am EDT (UTC-4). Register Now ProxySQL is a very powerful tool, with extended capabilities....
by Dmitriy Kostiuk | Aug 3, 2018 | MongoDB, Percona Events, Percona Live, Percona Software
Percona announces the release of Percona Server for MongoDB 3.6.6-1.4 on August 3, 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 Colin Charles | Aug 3, 2018 | MariaDB, MySQL, Percona Live, PostgreSQL, Storage Engine
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Don’t wait, submit a talk for Percona Live Europe 2018 to be held in Frankfurt 5-7 November 2018. The call for...
by Alok Pathak | Aug 2, 2018 | Cloud, Insight for DBAs, MySQL
Amazon RDS is a managed relational database service that makes it easier to set up, operate, and scale a relational database in the cloud. One of the common questions that we get is “What is Multi-AZ and how it’s different from Read Replica, do I need both?”. I...
