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 […]
Read more
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Some big news out from Microsoft about their acquisition of GitHub for $7.5 billion. GitHub hosts many projects, including from the MySQL ecosystem, but maybe more interesting is that their DBA team is awesome, give […]
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 talk about […]
In this blog post, we’ll look at what MySQL does under the hood to transform NoSQL requests to SQL (and then store them in InnoDB transactional engine) when using the X Plugin.
X Plugin allows MySQL to function as a document store. We don’t need to define any schema or use SQL language while still […]
In this blog, I will provide answers to the Q & A for the “Introduction into storage engine troubleshooting” webinar.
First, I want to thank everybody for attending the July 14 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 […]
In this blog post, I’ll discuss how to use MySQL 5.7 Document Store to track data from Internet of Things (IoT) devices.
Using JSON in MySQL 5.7
In my previous blog post, I’ve looked into MySQL 5.7.12 Document Store. This is a brand new feature in MySQL 5.7, and many people are asking when do I need […]
In this blog, we’ll look at the MySQL 5.7 document store feature, and how it is implemented.
Document Store
MySQL 5.7.12 is a major new release, as it contains quite a number of new features:
Document store and “MongoDB” like NoSQL interface to JSON storage
Protocol X / X Plugin, which can be used for asynchronous queries (I will […]
This post will discuss some excellent methods of getting JSON to MySQL indexing to work smoothly.
What is JSON
JSON is an text based, human readable format for transmitting data between systems, for serializing objects and for storing document store data for documents that have different attributes/schema for each document. Popular document store databases use JSON […]
