PostgreSQL Distributed & Secure Database Ecosystem Building

on YouTube ↗31m

" summary

Claim: ShardingSphere turns plain PostgreSQL clusters into a distributed, encrypted system by adding a pluggable kernel and middleware. It uses a ShardingSphere proxy or ShardingSphere-JDBC driver, a YAML-configured distributed SQL layer, and rules for sharding and encryption. Demo runs one proxy and two PostgreSQL storage nodes, creates a logical t_user table that maps to t_user_0 and t_user_1, stores ciphertext in storage while the proxy returns decrypted phone numbers, and the project shows ~15,000 GitHub stars and ~318 contributors.

AI-written summary · about

" chapters (12)

1. 0:00Introduction
2. 1:28Apache ShardingSphere project
3. 5:25Community and ecosystem
4. 7:30Key features
5. 9:15ShardingSphere Proxy for PostgreSQL
6. 12:33Sharding and encryption use cases
7. 17:09Distributed secure PostgreSQL cluster
8. 19:38Cluster setup process
9. 22:49Deploying ShardingSphere Proxy
10. 24:13Distributed SQL
11. 27:48Sharding and encryption rules
12. 28:53Live demo and summary

" related talks

• 42mPostgreSQL Distributed & Secure Database Ecosystem BuildingJuan Pan · Big Data Conference Europe 2022
• 53mBreakout SessionJason Petersen · PGConf Silicon Valley 2015
• 27mAutomatically shard & scale-out traditional databases on K8sTrista Pan · Conf42 Cloud Native 2023
• 38mPostgreSQL as a distributed computing platformMarco Slot · PostgresOpen Silicon Valley 2017
• 45mThe Future of Postgres ShardingBruce Momjian · HighLoad++ 2015
• 45mThe Future of Postgres ShardingBruce Momjian · HighLoad++ 2015
• 52mSharding PostgreSQL using Foreign Data WrappersKrishna Sarabu · PGConf NYC 2022
• 33mFive Sharding Data Models and Which is RightCraig Kerstiens · RailsConf 2018