 
      
    | You are here | www.bailis.org | ||
| | | | | brooker.co.za | |
| | | | | ||
| | | | | timilearning.com | |
| | | | | Distributed databases typically divide their tables into partitions spread across different servers which get accessed by many clients. In these databases, client transactions often span the different servers, as the transactions may need to read from various partitions. A distributed transaction is a database transaction which spans multiple servers. This post will detail how databases guarantee some ACID properties when executing distributed transactions. | |
| | | | | blog.thislongrun.com | |
| | | | | Definitions of Eventual Consistency, ACID and Dynamo. Looks at datacenters, partitions and dataloss. | |
| | | | | explainextended.com | |
| | | A late row lookup requires that the engine looks up a row in a table only if it had not been filtered by the index. MySQL is not capable of doing this but this can be emulated. It improves the LIMIT performance and filtering efficiency on the indexed fields | ||