Monthly Archives - June 2016

Docker automatic MySQL slave propagation

MySQL Group Replication

In this post, we’ll discuss Docker automatic MySQL slave propagation for help with scaling.
In my previous posts on the Docker environment, I covered Percona XtraDB Cluster. Percona XtraDB Cluster can automatically scale by conveniently adding new nodes using the highly automated State Snapshot Transfer. State Snapshot Transfer allows a new node to copy data […]

Read more

Running Percona XtraDB Cluster nodes with Linux Network namespaces on the same host

wsrep-stages

This post is a continuance of my Docker series, and examines Running Percona XtraDB Cluster nodes with Linux Network namespaces on the same host.
In this blog I want to look into a lower-level building block: Linux Network Namespace.
The same as with cgroups, Docker uses Linux Network Namespace for resource isolation. I was looking into cgroup […]

Read more

Webinar Thursday June 23: Choosing a MySQL High Availability Solution Today

GTID Replication

Please join Percona, Technical Account Manager, Michael Patrick on Thursday, June 23, 2016 at 10 AM PDT (UTC-7) as he presents “Choosing a MySQL High Availability Solution Today.”
High availability (HA) is one of the solutions to improve performance, avoid data outages, and recover quickly from disasters. An HA environment helps guarantee that your database doesn’t […]

Read more

InnoDB locks and transaction isolation level

Overlooked MySQL performance optimization

What is the difference between InnoDB locks and transaction isolation level? We’ll discuss it in this post.
Recently I received a question from a user about one of my earlier blog posts. Since it wasn’t sent as a comment, I will answer it here. The question:

> I am reading your article:
> https://www.percona.com/resources/technical-presentations/troubleshooting-locking-issues-percona-mysql-webinar
> Full table scan locks […]

Read more

MongoDB Security: Why pay for Enterprise when Open Source has you covered?

MongoDB Security

Does ensuring MongoDB security justify the cost of the Enterprise version? In my opinion, the answer is no.
MongoDB Inc© blasted an email with a study showing that the average cost of a data breach can be $5.9M. You can find the key finding in IBM’s 2015 report here:
NH Learning Solutions
Key findings:
Data breaches cost the most in the US and Germany […]

Read more

Scaling Percona XtraDB Cluster with ProxySQL in Kubernetes

wsrep-stages

How do you scale Percona XtraDB Cluster with ProxySQL in Kubernetes?
In my previous post I looked how to run Percona XtraDB Cluster in a Docker Swarm orchestration system, and today I want to review how can we do it in the more advanced Kubernetes environment.
There are already some existing posts from Patrick Galbraith (https://github.com/kubernetes/kubernetes/tree/release-1.2/examples/mysql-galera) […]

Read more

Why MongoRocks: Deprecating PerconaFT and MongoDB Optimistic locking

deprecating PerconaFT

In this post, we’ll discuss the rationale behind deprecating PerconaFT and embracing RocksDB.
Why is Percona deprecating PerconaFT in favor of RocksDB?
Many of you may have seen Peter Zaitsev’s recent post about Percona embracing RocksDB and deprecating PerconaFT. I’m going to shed a bit more light on the issues between the locking models for PerconaFT’s and MongoDB’s […]

Read more

Troubleshooting hardware resource usage webinar: Q & A

Overlooked MySQL performance optimization

In this blog, I provide answers to the Q & A for the Troubleshooting hardware resource usage webinar.
First, I want to thank everybody who attended the May 26 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer during the webinar, […]

Read more

Installing MongoDB 3.2 and upgrading MongoDB replica set

MySQL Performance Optimization

In this post, we’ll examine a couple of ways for upgrading MongoDB replica set.
With the release of MongoDB 3.2, comes a rash of new features and improvements. One of these enhancements is improved replica sets. From MongoDB: “A replica set in MongoDB is a group of mongod processes that maintain the same data set. […]

Read more

MongoDB and non-existent collections

MongoDB and non-existent collections

In this blog, I will discuss how I found some of my basic SQL assumptions that don’t hold true when dealing with MongoDB and non-existent collections.
Coming from a MySQL background, I have some assumptions about databases that don’t apply to MongoDB (or other kinds of databases that are neither SQL-based nor relationally-inspired).
An example of […]

Read more