How to Manage Operational & Analytical Data at Massive Scale

Presented by

Rob Hedgpeth, Developer Evangelist, MariaDB

About this talk

It's probably not news to you, but handling the problem of data scalability – really handling it – hasn't been a trivial feat. You may have tried everything from buying more powerful hardware to creating overly complex and brittle data partitioning methods to using entirely new data storage and access models. These approaches may have helped in some regards, but they also came with some pretty big trade-offs. Enter distributed SQL. Over the years a lot of things have been deemed a “game-changer” – but distributed SQL actually deserves the moniker. Distributed SQL databases are relational databases engineered with a distributed architecture to scale out without any trade-offs. These databases retain standard SQL, ACID transactions and strong consistency while adding unprecedented levels of scalability. But that's only the tip of the iceberg. In this session, you'll: • Gain an understanding of the fundamental concepts of distributed SQL • Learn how MariaDB's distributed SQL implementation, Xpand, takes database elasticity, scale and high availability to the next level • Discover how you can use columnar indexing with distributed SQL to dramatically improve the execution speed of analytical queries on massive datasets
Related topics:

More from this channel

Upcoming talks (0)
On-demand talks (12)
Subscribers (1918)
MariaDB frees companies from the costs, constraints and complexity of proprietary databases, enabling them to reinvest in what matters most – rapidly developing innovative, customer-facing applications. Deployed in minutes, MariaDB uses pluggable, purpose-built storage engines for transactional, analytical or hybrid use cases that previously required specialized databases. Enterprises can now depend on a single complete database for all their needs, whether on commodity hardware or their cloud of choice. MariaDB is trusted by organizations such as Deutsche Bank, DBS Bank, Nasdaq, Red Hat, ServiceNow, Verizon and Walgreens. Real business relies on MariaDB™