Buy Percona ServicesBuy Now!

Lock Down: Enforcing AppArmor with Percona XtraDB Cluster

 | August 9, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Security

Enforcing AppArmor with Percona XtraDB Cluster

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 AppArmor by default. If you are concerned by computer security and use PXC on Ubuntu, you […]

Read More

Webinar Thursday Aug 9: Migrating to AWS Aurora, Monitoring AWS Aurora with PMM

 | August 9, 2018 |  Posted In: Amazon Aurora, AWS, Events and Announcements, MySQL, Percona Monitoring and Management, PMM, Technical Webinars

Monitoring Amazon Aurora with PMM

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 Services (AWS) Aurora is one of the most popular cloud-based RDBMS […]

Read More

How to Change Settings for PMM Deployed via Docker

 | August 9, 2018 |  Posted In: Containers, Docker, MySQL, Percona Monitoring and Management, PMM

change settings for PMM deployed docker

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:

You would think if you want to change the setting for existing installation you can just stop the container with docker stop  and […]

Read More

Resource Usage Improvements in Percona Monitoring and Management 1.13

 | August 7, 2018 |  Posted In: Benchmarks, Insight for DBAs, MongoDB, MySQL, Percona Monitoring and Management, PMM

PMM 1-13 reduction CPU usage by 5x

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 and database instances monitored by the same PMM installation. Or you can […]

Read More

Basic Understanding of Bloat and VACUUM in PostgreSQL

 | August 6, 2018 |  Posted In: Insight for DBAs, PostgreSQL

VACUUM and Bloat 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 consider the case of an Oracle or a MySQL Database. What happens when you perform a DELETE or an […]

Read More

Webinar Tues 8/14: Utilizing ProxySQL for Connection Pooling in PHP

 | August 6, 2018 |  Posted In: MySQL, Percona Monitoring and Management, Percona XtraDB Cluster, PMM, ProxySQL, Technical Webinars

ProxySQL for connection pooling

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. This presentation will demonstrate how to use ProxySQL to gain functionality (seamless […]

Read More

Percona Server for MongoDB 3.6.6-1.4 Is Now Available

 | August 3, 2018 |  Posted In: Events and Announcements, MongoDB, Percona Live, Percona Server for MongoDB, Percona Software

MongoRocks

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 that is a fully-compatible, drop-in replacement for MongoDB 3.6 Community Edition. It supports MongoDB 3.6 protocols and drivers. Percona […]

Read More

This Week in Data with Colin Charles 47: MySQL 8.0.12 and It’s Time To Submit!

 | August 3, 2018 |  Posted In: MariaDB, MyRocks, MySQL, MySQL 8.0, Percona Live, PostgreSQL

Colin Charles

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 proposals is ending soon, there is a committee being created, and it is a […]

Read More