EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live Featured Tutorial with Derek Downey, David Turner and René Cannaò — ProxySQL Tutorial

 | February 3, 2017 |  Posted In: MySQL

Percona Live Featured Tutorial

Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona […]

Read More

MySQL Sharding Models for SaaS Applications

 | January 30, 2017 |  Posted In: Insight for DBAs, MySQL

MySQL Sharding Models

In this blog post, I’ll discuss MySQL sharding models, and how they apply to SaaS application environments. MySQL is one of the most popular database technologies used to build many modern SaaS applications, ranging from simple productivity tools to business-critical applications for the financial and healthcare industries. Pretty much any large scale SaaS application powered […]

Read More

MongoDB PIT Backups: Part 2

 | January 9, 2017 |  Posted In: Cloud and NoSQL, High-availability, MongoDB, open source databases, Solutions Engineering

MongoDB PIT Backups

This blog post is the second in a series covering MongoDB PIT backups. You can find the first part here. Sharding Makes Everything Fun(ner) The first blog post in this series looked at MongoDB backups in a simple single-replica set environment. In this post, we’ll look at the scale-out use case. When sharding, we have exactly […]

Read More

MongoDB 3.4: Sharding Improvements

 | January 4, 2017 |  Posted In: MongoDB

Sharding Improvements

In this blog post, we will discuss some of the Sharding improvements in the recent MongoDB 3.4 GA release. Sharding? Let’s go over what MongoDB Sharding “is” at a simplified, high level. The concept of “sharding” exists to allow MongoDB to scale to very large data sets that may exceed the available resources of a single node or […]

Read More

Percona Live Europe featured talk with Anthony Yeh — Launching Vitess: How to run YouTube’s MySQL sharding engine

 | September 22, 2016 |  Posted In: MySQL

Percona Live Europe featured talk

Welcome to another Percona Live Europe featured talk with Percona Live Europe 2016: Amsterdam speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference. We’ll also discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona Live Europe […]

Read More

MySQL Sharding with ProxySQL

 | August 30, 2016 |  Posted In: MySQL

MySQL Sharding with ProxySQL

This article demonstrates how MySQL sharding with ProxySQL works. Recently a colleague of mine asked me to provide a simple example on how ProxySQL performs sharding. In response, I’m writing this short tutorial in the hope it will illustrate ProxySQL’s sharding functionalities, and help people out there better understand how to use it. ProxySQL is […]

Read More

Webinar Tuesday, May 24: Understanding how your MongoDB schema affects scaling, and when to consider sharding for help

 | May 19, 2016 |  Posted In: MongoDB, Performance Schema

Please join David Murphy on Tuesday, May 24 at 10 am PDT (UTC-7) as he presents “Understanding how your MongoDB schema affects scaling, and when to consider sharding for help.” David will discuss the pros and cons of a few MongoDB schema design patterns on a stand-alone machine, and then will look at how sharding […]

Read More

Setup a MongoDB replica/sharding set in seconds

 | January 28, 2016 |  Posted In: MongoDB, MySQL

In the MySQL world, we’re used to playing in the MySQL Sandbox. It allows us to deploy a testing replication environment in seconds, without a great deal of effort or navigating multiple virtual machines. It is a tool that we couldn’t live without in Support. In this post I am going to walk through the different ways we […]

Read More

Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!

 | April 21, 2015 |  Posted In: Insight for DBAs, MySQL, Technical Webinars

MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, “To Shard, or Not to Shard,” proved there is indeed quite an interest in this topic. As such, I’m hosting a live webinar tomorrow (April 22) that will shed light on questions about sharding with […]

Read More