Buy Percona ServicesBuy Now!

Webinar 6/28: Securing Database Servers From External Attacks

 | June 27, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, PostgreSQL, Replication, Security, Technical Webinars

securing database servers

Please join Percona’s Chief Evangelist Colin Charles on Thursday, June 28th, 2018, as he presents Securing Database Servers From External attacks at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   A critical piece of your infrastructure is the database tier, yet people don’t pay enough attention to it judging by how […]

Read More

Webinar 6/27: MySQL Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance

 | June 26, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MySQL, MySQL 101, Percona Server for MySQL, Performance Schema, Technical Webinars

performance troubleshooting MySQL monitoring tools

Please join Percona’s Principal Support Escalation Specialist Sveta Smirnova as she presents Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance on Wednesday, June 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   During the MySQL Troubleshooting webinar series, I covered many monitoring and logging tools such as: General, slow, […]

Read More

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

Zone Based Sharding in MongoDB

 | June 13, 2018 |  Posted In: Insight for Developers, MongoDB, Security

MongoDB shard zones

In this blog post, we will discuss about how to use zone based sharding to deploy a sharded MongoDB cluster in a customized manner so that the queries and data will be redirected per geographical groupings. This feature of MongoDB is a part of its Data Center Awareness, that allows queries to be routed to particular […]

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