Tuanh.nettuanhnet.hashnode.dev·Nov 15, 2024Secrets to Overcoming the Challenges of Horizontal Scaling in SQL DatabasesSource: Secrets to Overcoming the Challenges of Horizontal Scaling in SQL Databases 1. Understanding Horizontal Scaling in SQL Databases Scaling horizontally involves adding more servers to distribute the load, as opposed to vertical scaling, ...Discussdatabase
Tuanh.nettuanhnet.hashnode.dev·Nov 12, 202410 Tips for Mastering T-SQL that Every Developer Should KnowSource: 10 Tips for Mastering T-SQL that Every Developer Should Know 1. What is T-SQL? T-SQL stands for Transact-SQL, an extension of SQL that includes procedural programming, local variables, and error handling. It enables developers to...Discussdatabase
Hansraj Deghunpythondevop.hashnode.dev·Oct 30, 2024How MongoDB Loses Availability for Consistency and Partition ToleranceIn the world of distributed databases, every system design must account for trade-offs between Consistency, Availability, and Partition Tolerance, as outlined by the CAP theorem. This foundational principle dictates that a distributed system can only...Discuss·6 likes·64 readsMongoDB
OBULIPURUSOTHAMAN Kobulipurusothaman.hashnode.dev·Oct 30, 2024Cap Theorom & Db ShardingCAP THEOROM : C – Consistency A – Availability P – Partitioning The CAP Theorem is a fundamental concept in distributed system design, helping engineers understand the trade-offs between Consistency, Availability, and Partition Tolerance in any dist...DiscussDB SHARDING
Tuanh.nettuanhnet.hashnode.dev·Oct 20, 2024How the Saga Pattern Resolves Distributed Transaction Issues: Methods and Real-World ExampleSource: How the Saga Pattern Resolves Distributed Transaction Issues: Methods and Real-World Example 1. Understanding the Problem: The Complexity of Distributed Transactions Distributed transactions involve multiple microservices, where ...Discusstransaction
Tuanh.nettuanhnet.hashnode.dev·Oct 10, 2024Methods of Transaction Propagation: Understanding the Types and Their UsesSource: Methods of Transaction Propagation: Understanding the Types and Their Uses 1. What is Transaction Propagation? Transaction propagation determines how transactions are handled across different method calls or services. It defines whethe...DiscussSpring
Jyotiprakash Mishrablog.jyotiprakash.org·Oct 7, 2024A Primer on Cache Coherence ProtocolsIn modern multi-core processors, multiple cores operate in parallel, each with its own cache to store frequently accessed data. These caches are designed to reduce the time it takes for a processor to retrieve data from memory, speeding up overall pe...Discuss·211 readsweak consistency
Ritik Singhritiksingh.hashnode.dev·Oct 4, 2024Consistency In Distributed SystemsSo the question arises: what does consistency refer to? Well, it’s about getting the latest data from the server. Let me give an example: you have a LinkedIn account, and you created a post. If someone likes that post, you should see the like count i...Discuss·34 readsSystem Design Simplified: A Journey to Building Scalable Applicationsconsistency
Tuanh.nettuanhnet.hashnode.dev·Oct 3, 2024What is a Race Condition? Causes, Examples, and SolutionsSource: What is a Race Condition? Causes, Examples, and Solutions 1. Understanding Race Conditions A race condition occurs when two or more threads or processes access shared resources concurrently, and the final outcome depends on the timing ...Discussthread
Kunal Arorakrishanblogs.hashnode.dev·Oct 2, 2024How to Manage Data Consistency with Multiple Worker Instances?Problem Statement Let’s consider a scenario where we have a single service instance running a cron job. This job checks the database for any entries with a status of COMPLETED. When it finds such entries, it performs the necessary application code c...Discuss·1 like·110 readsdisturbted locking
