Tag - ClickHouse

Beyond Relational Databases: A Focus on Redis, MongoDB, and ClickHouse

Beyond Relational Databases

Many of us use and love relational databases… until we try and use them for purposes that aren’t their strong point. Queues, caches, catalogs, unstructured data, counters, and many other use cases, can be solved with relational databases, but are better served by alternative options.
Recently, Marcos Albe, Support Engineer at Percona, examined the goals, […]

Read more

Advanced Query Analysis in Percona Monitoring and Management with Direct ClickHouse Access

query analysis clickhouse PMM

In my Webinar on Using Percona Monitoring and Management (PMM) for MySQL Troubleshooting, I showed how to use direct queries to ClickHouse for advanced query analysis tasks. In the followup Webinar Q&A, I promised to describe it in more detail and share some queries, so here it goes.
PMM uses ClickHouse to store query performance […]

Read more

ClickHouse Versus MySQL Handling of Double Quotes

ClickHouse MySQL Double Quotes

If you’re a MySQL user trying ClickHouse, one thing which is likely to surprise – and annoy you – is the handling of Double Quotes. In MySQL, you can use both double quotes and single quotes to quote strings, and as an example, these two queries are equivalent:

Shell

mysql> select * from performance_schema.global_variables where variable_name=’max_connections’;
+—————–+—————-+
| […]

Read more

ClickHouse and MySQL – Better Together

clickhouse and mysql

It’s been a while since I wrote about ClickHouse, there are a lot of new features that are worth mentioning, and for this, I recommend to follow the Altinity Blog but today I want to look at the improved integration of ClickHouse and MySQL.
There are two features:

Using MySQL protocol and MySQL client to connect […]

Read more

MariaDB Track at Percona Live

MariaDB track at Percona Live 2019

Less than one month left until Percona Live. This time the Committee work was a bit unusual. Instead of having one big committee for the whole conference we had a few mini-committees, each responsible for a track. Each independent mini-committee, in turn, had a leader who was responsible for the whole process. I led […]

Read more