Search Results

7 matches found for 'ACID'

Web Development 101

HTTP vs. HTTPS HTTP stands for Hypertext Transfer Protocol. It typically runs on TCP port 80. It is a protocol for sending data through browsers in the form of webpages and such. One major flaw with HTTP is that it is vulnerable to man in the middle attacks.

November 9, 2017

Distributed scaling with Relational Databases

... and replication can be done on just about any kind of service. The other reason is due to the ACID compliant nature of a single-server SQL database and how that becomes much more fuzzier when you transition over to SQL on distributed systems and you want to keep the same ACID guarantees such as atomicity or strong consistency.

January 19, 2022

CAP Patterns

... with each other. If either master goes down, the other master will take over. Violates ACID since data is loosely consistent now. Replication lag is higher Master-Slave Replication The master host handles writes.

December 16, 2020

RDBMS Optimization

... Sharding Due to the complexity of implementing this in practice (as well as needing to make some ACID trade-offs), this isn't a recommended optimization unless all other options have been exhausted.

June 23, 2020

Design Concepts

... a lot of relationships with the data you need to store? Relational databases have the power of ACID, which makes it a tried and true solution if you need your data to be consistent and reliable.

November 20, 2019

Sharding Techniques

... helps prevent this. Challenges include: Management of sharding, especially in RDBMS where ACID compliance is desired Can be complicated to implement In this article, I cover three sharding techniques to improve the read/write performance of databases.

July 31, 2020

Comparison Charts of File Storage Formats

... data. ORC Columnar Great Reads Good Works well with Hive. Supports ACID transactions. Human Readable Encodings These encodings are often used to structure data in a more convenient way for developers and end-users, with less importance on the data size (in memory or disk).

January 24, 2022