Monthly Archives - March 2016

MongoDB at Percona Live: A Special Open Source Community Discount

12 Days Until Percona Live

We want MongoDB at Percona Live!
One of the main goals of the Percona Live Data Performance Conference 2016 is celebrating and embracing the open source community. The community’s spirit of innovation, expertise and competition has produced incredible software, hardware, processes and products.
The open source community is a diverse and powerful collection of companies, organizations […]

Read more

Docker MySQL Replication 101

Docker

In this blog post, we’ll discuss some of the basics regarding Docker MySQL replication. Docker has gained widespread popularity in recent years as a lightweight alternative to virtualization. It is ideal for building virtual development and testing environments. The solution is flexible and seamlessly integrates with popular CI tools.
 
This post walks through the setup of MySQL replication […]

Read more

Percona Live featured talk with Avi Kivity: Scylla, a Cassandra-compatible NoSQL database at two million requests per second

Percona Live featured talk with Avi Kivity

Welcome to the next Percona Live featured talk with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona […]

Read more

Read-write split routing in MaxScale

Read-write split routing performance in MaxScale

In this blog post, we’ll discuss read-write split routing in MaxScale.
The two previous posts have shown how to setup high availability (HA) with Maxscale using asynchronous replication and how we monitor replication.
Now let’s focus on the routing module performing read-write splits.
This is our current configuration:

Shell

[Splitter Service]
type=service
router=readwritesplit
servers=percona1, percona2
max_slave_replication_lag=30
user=maxscale
passwd=264D375EC77998F13F4D0EC739AABAD4

1234567

[Splitter Service]type=servicerouter=readwritesplitservers=percona1, percona2max_slave_replication_lag=30user=maxscalepasswd=264D375EC77998F13F4D0EC739AABAD4

This router module is designed to spread […]

Read more

MySQL 5.7 primary key lookup results: is it really faster?

database support

This blog examines MySQL 5.7’s primary key lookup results, and determines if MySQL 5.7 is really faster than its early versions.
MySQL 5.7 was released some time ago, and now that the dust has settled it’s a good time to review its performance improvements.
I’m not doing this just to satisfy my own curiosity! Many customers […]

Read more