Buy Percona ServicesBuy Now!

Finding the Right Direction: MongoDB Compass – Community Version

 | June 22, 2018 |  Posted In: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MongoDB

MongoDB Compass

In this blog post, we will talk a bit about the product MongoDB Compass. This new tool has 3 main versions, these being: Community, Enterprise and Enterprise Read Only. MongoDB Compass Community is free, but a bit limited. It allows you to connect to your MongoDB Database to run queries, check queries execution plans, manage indexes, and create, […]

Read More

Webinar Thu 6/21: How to Analyze and Tune MySQL Queries for Better Performance

 | June 20, 2018 |  Posted In: EXPLAIN, Insight for DBAs, Insight for Developers, MySQL, MySQL 101, Technical Webinars

database query tuning

Please join Percona’s MySQL Database Administrator, Brad Mickel as he presents How to Analyze and Tune MySQL Queries for Better Performance on Thursday, June 21st, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now   Query performance is essential in making any application successful. In order to finely tune your queries […]

Read More

Chunk Change: InnoDB Buffer Pool Resizing

 | June 19, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, open source databases, Percona Server for MySQL

innodb buffer pool chunk size

Since MySQL 5.7.5, we have been able to resize dynamically the InnoDB Buffer Pool. This new feature also introduced a new variable — innodb_buffer_pool_chunk_size — which defines the chunk size by which the buffer pool is enlarged or reduced. This variable is not dynamic and if it is incorrectly configured, could lead to undesired situations. […]

Read More

MongoDB: deploy a replica set with transport encryption (part 3/3)

 | May 31, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Security

MongoDB Encryption Replica Sets

In this third and final post of the series, we look at how to configure transport encryption on a deployed MongoDB replica set. Security vulnerabilities can arise when internal personnel have legitimate access to the private network, but should not have access to the data. Encrypting intra-node traffic ensures that no one can “sniff” sensitive data […]

Read More

MySQL Test Framework for Percona XtraDB Cluster

 | May 30, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster

MySQL Test Framework

At my latest webinar “MySQL Test Framework (MTR) for Troubleshooting”, I received an interesting question about MTR test cases for Percona XtraDB Cluster (PXC). Particularly about testing SST and IST. This post is intended to answer this question. It assumes you are familiar with MTR and can write tests for MySQL servers. If you are […]

Read More

Webinar Tues, 5/29: MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together

 | May 25, 2018 |  Posted In: Containers, High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona Server for MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL, Technical Webinars, XtraDB Cluster

Please join Percona’s Principal Architect Alex Rubin as he presents MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together to give you a highly available cluster database environment on Tuesday, May 29th at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   In this webinar, Alex will discuss how to deploy […]

Read More

Using dbdeployer to manage MySQL, Percona Server and MariaDB sandboxes

 | May 24, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Server for MySQL

dbdeployer by Giuseppe Maxia

Some years ago, Peter Z wrote a blogpost about using MySQL Sandbox to deploy multiple server versions. Last February, Giuseppe  introduced us to its successor: dbdeployer. In this blogpost we will demonstrate how to use it. There is a lot of information in Giuseppe’s post, so head there if you want a deeper dive. First step […]

Read More

Deploy a MongoDB Replica Set with Transport Encryption (Part 2)

 | May 23, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Security

document-replication

In this article series, we will talk about the basic high availability architecture of a MongoDB: the MongoDB replica set. Part 1 : We introduced basic replica set concepts, how it works and what its main features Part 2 (this post): We’ll provide a step-by-step guide to configure a three-node replica set Part 3: We’ll […]

Read More

Upcoming Webinar Thursday, 5/24: What’s New in MongoDB 3.6

 | May 22, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Percona Server for MongoDB, Technical Webinars

Running MongoDB

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents What’s New in MongoDB 3.6 on Thursday, May 24th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). In this webinar, Adamo will walk though what’s new in MongoDB 3.6, including: Change streams for building reactive, real-time applications Retryable writes for always-on […]

Read More