EmergencyEMERGENCY? Get 24/7 Help Now!

ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)

 | June 22, 2017 |  Posted In: Benchmarks, MySQL, Performance Schema

ClickHouse

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test. We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks: MariaDB ColumnStore vs. Clickhouse vs. Apache Spark), where it showed excellent results. ClickHouse by itself seems […]

Read More

Better Than Linear Scaling

 | April 22, 2017 |  Posted In: Hardware and Storage, High-availability, Insight for DBAs, Insight for Developers, MySQL

Scalability

In this blog, we’ll look at how to achieve better-than-linear scaling. Scalability is the capability of a system, network or process to handle a growing amount of work, or its potential to be enlarged to accommodate that growth. For example, we consider a system scalable if it is capable of increasing its total output under […]

Read More

Performance improvements in Percona XtraDB Cluster 5.7.17-29.20

and  | April 19, 2017 |  Posted In: MySQL, Percona XtraDB Cluster

Percona XtraDB Cluster

In our latest release of Percona XtraDB Cluster, we’ve introduced major performance improvements to the MySQLwrite-set replication layer. In this post, we want to show what these improvements look like. For the test, we used the sysbench OLTP_RW, UPDATE_KEY and UPDATE_NOKEY workloads with 100 tables, 4mln rows each, which gives about 100GB of datasize. In all […]

Read More

Run Percona Server on Bash on Windows on Ubuntu

 | April 14, 2017 |  Posted In: MySQL

Bash on Windows on Ubuntu

In this post, I’ll explain how to run Percona Server for MySQL and Percona Server for MongoDB on Bash on Windows on Ubuntu. We are getting a good number of questions about whether Percona Server (for both MySQL and MongoDB) is available for Windows for evaluation or development purposes. I want to provide a guide to how to […]

Read More

What’s Next for SQL Databases?

 | March 27, 2017 |  Posted In: MySQL

SQL Databases

In this blog, I’ll go over my thoughts on what we can expect in the world of SQL databases. After reading Baron’s prediction on databases, here: https://www.xaprb.com/blog/defining-moments-in-database-history/ I want to provide my own view on what’s coming up next for SQL databases. I think we live in interesting times, when we can see the beginning of […]

Read More

Group Replication: Shipped Too Early

 | February 15, 2017 |  Posted In: Group Replication, High-availability, MySQL, Percona XtraDB Cluster

Group Replication

This blog post is my overview of Group Replication technology. With Oracle clearly entering the “open source high availability solutions” arena with the release of their brand new Group Replication solution, I believe it is time to review the quality of the first GA (production ready) release. TL;DR: Having examined the technology, it is my […]

Read More