EmergencyEMERGENCY? Get 24/7 Help Now!

Advanced JSON to MySQL indexing

 | March 10, 2015 |  Posted In: MySQL

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 […]

Read More

Parallel Query for MySQL with Shard-Query

 | May 1, 2014 |  Posted In: Insight for DBAs, MySQL

While Shard-Query can work over multiple nodes, this blog post focuses on using Shard-Query with a single node.  Shard-Query can add parallelism to queries which use partitioned tables.  Very large tables can often be partitioned fairly easily. Shard-Query can leverage partitioning to add paralellism, because each partition can be queried independently. Because MySQL 5.6 supports the […]

Read More