EmergencyEMERGENCY? Get 24/7 Help Now!

Semi-Sync replication performance in MySQL 5.7.4 DMR

 | May 27, 2014 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

I was interested to hear about semi-sync replication improvements in MySQL’s 5.7.4 DMR release and decided to check it out.  I previously blogged about poor semi-sync performance and was pretty disappointed from semi-sync’s performance across WAN distances back then, particularly with many client threads. The Test The basic environment of these tests was: AWS EC2 […]

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

Loading Air Traffic Control Data with TokuDB 4.1.1

 | August 27, 2010 |  Posted In: Tokutek, TokuView

TokuDB has a big advantage over B-trees when trickle loading data into existing tables. However, it is possible to preprocess the data when bulk loading into empty tables or when new indexes are created. TokuDB release 4 now uses a parallel algorithm to speed up these types of bulk insertions. How does the parallel loader […]

Read More