Monthly Archives - November 2016

WiredTiger B-Tree versus WiredTiger In-Memory: Q & A

MySQL Character Sets

In this blog, I will provide answers to the Q & A for the WiredTiger B-Tree versus WiredTiger In-Memory webinar.
First, I want to thank everybody for attending the October, 13 webinar. The recording and slides for the webinar are available here. Below is the list of questions that I wasn’t able to fully answer […]

Read more

Help Us Shape the Future of Percona

Let us know what you think about Percona, and what we should be thinking about for the future.
Over the last ten years, Percona has grown considerably. We’ve moved from being a strictly MySQL company, to a company that supports MongoDB and other open source databases. Percona Live and Percona Live Europe have become key […]

Read more

All You Need to Know About GCache (Galera-Cache)

GCache

This blog discusses some important aspects of GCache.
Why do we need GCache?
Percona XtraDB Cluster is a multi-master topology, where a transaction executed on one node is replicated on another node(s) of the cluster. This transaction is then copied over from the group channel to Galera-Cache followed by apply action.
The cache can be discarded immediately once the […]

Read more

Is Docker Good for Your Database?

Docker

This blog post reviews the appropriateness of Docker and other container solutions for your database environment.
A few weeks back, I wrote a fairly high-level blog post about containers. It covered what you should consider when thinking about using Docker, rkt, LXC, etc. I hope you’ve taken the chance to give it a quick read. It’s a […]

Read more

Webinar Thursday, November 17: MySQL High Availability with Percona XtraDB Cluster 5.7

Percona XtraDB Cluster 5.7

Join Percona’s Percona XtraDB Cluster Lead Software Engineer Krunal Bauskar for a webinar on Thursday, November 17, 2016, at 7:30 am PST on MySQL High Availability with Percona XtraDB Cluster 5.7.
Percona XtraDB Cluster 5.7 is our brand new MySQL 5.7 compatible Galera-based high availability (HA) solution. Whether you’re new to MySQL clustering technology, or […]

Read more

Percona Monitoring and Management 1.0.6 is now available

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.0.6 on November 15, 2016.

PMM Server is distributed through Docker Hub
PMM Client packages are available on the download page

The instructions for installing or upgrading Percona Monitoring and Management 1.0.6 are available in the documentation. Detailed release notes are available here.
New in PMM Server:

Prometheus 1.2.2
External static files are […]

Read more

Using Vault with MySQL

Using Vault with MySQL

Using Vault with MySQL
In my previous post I discussed using GPG to secure your database credentials. This relies on a local copy of your MySQL client config, but what if you want to keep the credentials stored safely along with other super secret information? Sure, GPG could still be used, but there must be […]

Read more

MongoDB Through a MySQL Lens

MongoDB and MySQL

This blog post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Delving into NoSQL coming from an exclusively SQL background can seem like a daunting task. I have worked with SQL in both small MySQL environments and large Oracle SQL environments. 
When is it […]

Read more

Amazon AWS Service Tiers

This blog post discusses the differences between the Amazon AWS service tiers.
Many people want to move to an Amazon environment but are unsure what AWS service makes the most sense (EC2, RDS, Aurora). For database services, the tiering at Amazon starts with EC2, then moves up to RDS, and on to Aurora. Amazon takes on […]

Read more

Is Your Query Cache Really Disabled?

Query Cache

This blog post was motivated by an internal discussion about how to fully disable query cache in MySQL.
According to the manual, we should be able to disable “Query Cache” on the fly by changing
query_cache_type to 0, but as we will show this is not fully true. This blog will show you how to properly disable “query […]

Read more