With the amount of stored data growing quickly, analytics work has turned into a very intensive workload that will hit our MySQL servers in very hard way.
During the last few years we have seen a bunch of new engines designed to digest big portions of data and help with analytical queries. Now there is a new contender in the arena that claims to be MySQL Compatible, High Impact and Open Source Analytics.
During the course of this session we will go through each of these topics and try to answer:
- Compatible - how hard it is to take data out of MySQL and how much lag it may suffer on real workload?
- High Impact - near real time query response, low cost of entry high ROI?
- Open Source - open source only?
Moreover, we will compare the solution against some other popular products already in the market like ColumnStore, Cassandra, Clickhouse and we'll see how TiDB behaves in comparison.
Jervin partners with Percona's customers on building reliable and highly performant MySQL and MongoDB infrastructures. He believes automation, visibility and an excellent amount of curiosity makes for a good data engineer. Jervin joined Percona in Apr 2010.
I've been a computing enthusiastic pretty much my hole life when we got a Commodore 64C computer (yeah with dataset and so). Working as MySQL DBA and Consultant for about 10 years now (and being a crappy developer before) I've worked with a variety of systems and scenarios where the challenge is to keep track of new and old technologies interacting