Back To Schedule
Wednesday, October 21 • 08:30 - 09:00
Building Data Lake with MariaDB ColumnStore

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

VirtualHealth empowers healthcare organizations to achieve enhanced outcomes while maximizing efficiency and lowering costs.

Among approaches providing customers with continuous access to their OLTP data, we evaluated a relational data lake approach that retains master data in its original form and format. Data scientists can access the data lake with many analytics tools supporting data consumption via MySQL clients such as ODBC and JDBC.
To reduce costs, we chose MariaDB ColumnStore taking advantage of its inherent data compression and S3 storage support. We present real-world analytics use cases and share lessons learned, such as:
  • Why the OLAP queries are slow in the OLTP environment?
  • What type of queries benefits most from the MariaDB ColumnStore architecture?
  • How to transfer OLTP data to the MariaDB ColumnStore?

avatar for Sasha Vaniachine

Sasha Vaniachine

MySQL Database Administrator, VirtualHealth
Sasha is a MySQL enthusiast experienced in troubleshooting and resolving scalability issues across the full software stack. In industry and academia, he scaled up data processing from terabytes to petabytes, while minimizing data losses below an acceptable level. Earlier in his career... Read More →

avatar for Marcos Albe

Marcos Albe

Principal Support Engineer, Percona
After 12 years working as a developer for local and remote firms, Marcos decided to pursuit true love and become full time DBA, so he has been doing MySQL Support at Percona for the past 11+ years, providing lead web properties with advise on anything-MySQL and in-depth system performance... Read More →

Wednesday October 21, 2020 08:30 - 09:00 EDT