TiDB - From Data to Discovery: Exploring the Intersection of Distributed Databases and AI

Speaker: Sreedharma Vijayan, India Director at PingCAP, at Mydbops Open Source Meetup 16.

Topic: From Data to Discovery: Exploring the Intersection of Distributed Databases and AI
Date & Time: 8th June | 10 AM - 1 PM IST

In this session, Sreedharma Vijayan delves into the exciting intersection of distributed databases and AI.

You'll discover how TiDB empowers digital industries to:
* Handle explosive data growth that challenges traditional databases.
* Optimize data distribution and access logic within your applications.
* Unlock valuable insights to fuel AI-powered workflows.

1. Sreedharma Vijayan
India Director - PingCAP

2. If you are a database administrator

3. Or a technology decision maker

4. You may wrestle with questions like

5. How can my database scale out?

6. How can my database scale elastically?

7. To accommodate marketing campaigns ?

8. Data Growth: A challenge
MYSQL
DB1
MySQL 1
DB 1
DB2
MySQL 2
DB3
MySQL 3
DB4
MySQL 4
Data distribution
logic in application
Data access logic in
application
Manual Sharding
DB 2
DB 3
DB 4

9. Intent to grow creates Complexity
Master
Hot
Standby
Read
Replica
Master
Hot
Standby
Read
Replica
Master
Hot
Standby
Read
Replica
Master
Hot
Standby
Read
Replica
Master
Hot
Standby
Read
Replica
Read
Replica
Hot
Standby
Read
Replica
Hot
Standby
Read
Replica
Hot
Standby
Read
Replica
Hot
Standby
Read
Replica
Hot
Standby
Application
Reads
Writes
Shard 1 Shard 2 Shard 3 Shard 4 Shard 5
Region 1 - Active Application Region 2 - Passive
Shard 1 Shard 2 Shard 3 Shard 4 Shard 5
25 DB Nodes
20 Replication
Channels
Operational
complexity
Failover
complexity
Resharding
complexity
Reads

10. If you are a business analyst

11. You may wonder

12. How can I get real-time insights into my business without an expensive ETL process?

13. Single Node Database Limitations
Scalability High Availability Real-Time
Analytics
Handle Modern
applications
Unstable performance when
scaling write-intensive
applications.
Setting up HA requires careful
planning & configuration. The
replication can result in lag,
potential data
inconsistencies
Analytical queries can
impact transactional
processing
Adapting to cloud native
architecture poses
challenges to traditional,
monolithic systems like
MySQL

14. Can one solution meet all these requirements?

15. Introducing
The most advanced, open
source, distributed SQL
database for modern
applications.
Scalable. Versatile. Titanium (Ti) Reliable.
34K+ GitHub Stars 3K+ Adopters 800+ Contributors 5K+ Slack Users

16. With TiDB Cloud - Your Business won’t outgrow your database

17. What Makes TiDB So Advanced?

18. The Advantages of TiDB
Horizontal Scaling
Grants total transparency into
data workloads without
manualsharding.
High Availability
Guarantees auto-failover and
self-healing for continuous
access to data.
Mixed Workloads
Streamlined tech stack makes it
easier to produce real-time
analytics.
MySQL Compatibility
Enjoy the most MySQL
compatible distributed SQL
database on the planet.
Multi-Cloud
Deploy database clusters
anywhere in the world.
Open Source
Unlock business innovation
with a database that’s 100%
open source.
Robust Security
Protect data with enterprise-
grade encryption both in-flight
and at-rest.

19. If data volume increases over time – You can handle it easily!

20. Scale-Out easily by adding nodes – Performance increases linearly based on your cluster size

21. But what about short-term surges and drops?

22. TiDB Cloud scales up for the surge

24. And Scales in when the traffic slows with zero downtime

25. Case Study - Flipkart

26. TiDB Cloud is highly available

27. TiDB’s RAFT-based distribution mechanism – Replicate each segment of data to at least three AZs

28. Even if one zone fails – Your data is safe! and the Service stays on

29. TiDB creatively combines row-based storage and column-based storage in the same database

30. Data is replicated between the two storage engines in real time to get fresh analytics from transnational data

31. TiDB is a one-stop solution for hybrid workloads

33. Deploy TiDB clusters in your favourite cloud in just a few clicks!

36. Demo
https://play.tidbcloud.com