Synchronizing Data from PgSQL to Tarantool

on YouTube ↗23m

" summary

Describes synchronizing data from PostgreSQL (PgSQL) into Tarantool to build a fast cache in front of a primary database and reduce load on PostgreSQL. Explains the challenge of keeping cached data consistent with the source database, discusses which data can or cannot be safely cached, and outlines approaches to ensure cache freshness and correctness.

AI-written summary · about

" chapters (9)

1. 0:00Introduction
2. 1:26Problem and solution
3. 3:29Data sync schema
4. 6:01Implementation and modules
5. 8:15Limitations and nuances
6. 10:03Results and performance
7. 13:12Fault tolerance
8. 14:13Error handling
9. 16:04Q&A

" related talks

• 39mFrom PostgreSQL to Tarantool: Choosing When There Is No ChoiceEvgeniy Demkin, Lyubov Vaynshteyn · Joker 2022
• 56mUsing Tarantool as a Data Virtualization PlatformK.Osipov, S.Myasnikov · РИТ++ 2016
• 38mHow to Forget About Performance Problems? Tarantool as the DBMSAleksandr Kharchenko · Saint HighLoad++ 2022
• 46mTarantool: How to Save a Million Dollars on Your DBDenis Anikin · HighLoad++ 2015
• 54mArchitecture of a Reliable In-MemorDBMS: the Tarantool ExampleVladimir Perepelitsa · HighLoad++ 2022
• 51mReplication in Tarantool: Configuration and UsageGeorgiy Kirichenko · HighLoad++ Moscow 2018
• 49mPrimary Use Cases for In-Memory DBMS Illustrated by TarantoolDenis Anikin · РИТ++ 2016
• 49mTarantool 2.1 Adds SQL Support: DetailsKirill Yukhin · HighLoad++ Moscow 2018