Скачать или смотреть Consolidate your read & write databases into one db that does it all | Architectural Simplification

Ready to simplify your software stack? With less infrastructure, there's less to manage, and less to go wrong. If you're currently running numerous databases with each performing a different task, you may run into issues including:
Increased architectural complexity
Increased operational complexity
Higher software and hardware costs
Out-of-sync databases
The lack of a true view of data

But with CockroachDB, you can consolidate multiple databases into one and reduce architectural complexity and operational complexity, lower your software your hardware costs, and get truly consistent data.

In this installment of our Architectural Simplification series by Cockroach Labs Technical Evangelist Rob Reid, we take a look at the hyper-specialized DB use case of read/write segregation: Or the separation of read concerns and write concerns based on the specializations of each database being used in the stack.

Rob's demo involves
Ingesting data into a database that's specialized for writes, but not necessarily reads
Using Debezium to get data out of Cassandra and into a queue
Loading data into Postgres to index data

...And comparing this setup to distributed SQL database CockroachDB, which can seamlessly scale up for reads and writes. Because each node in CockroachDB is the same, you can scale as easily for writes as you can for reads. Just add more nodes to the clusters. No third party tools or configuration parameters required to get data from CockroachDB into downstream systems.

And with fewer moving parts, you can lower latency, manage less, and not worry about things going wrong.

00:00 What is Read/Write Segregation?
00:27 What is Rob testing? And what does this big data architecture look like?
00:59 CockroachDB vs Cassandra and Postgres
01:38 Behind Rob's setup
02:42 Spinning up the infrastructure
03:23 Running the load generator and seeing the benchmarks
03:58 Limitations of Cassandra and Debezium
04:10 How CockroachDB can replace a Cassandra, Debezium, and Postgres stack

Subscribe to CockroachDB on YouTube for more technical videos:    / cockroachdb  

********************************
Further reading:
✔️ What is CockroachDB? https://cockroa.ch/42uaZ9G
✔️ CockroachDB architecture overview: https://cockroa.ch/3RzIvrh
✔️ Understanding Reads & Writes in CockroachDB: https://cockroa.ch/3urRdz7
✔️ Change Data Capture overview in CockroachDB: https://cockroa.ch/3UwCrla

********************************
Follow Cockroach Labs
✔️ Website: https://cockroachlabs.com/
✔️ Twitter (X):   / cockroachdb  
✔️ Linkedin:   / cockroach-labs  
✔️ Facebook:   / cockroachlabs  
✔️ Instagram:   / cockroachdb  
✔️ Threads: https://www.threads.net/@cockroachdb

********************************
#distributedsql #data #database #distributedsystems