OSSInsightforossinsight.hashnode.net·Nov 22, 2022How We Reduced Online Serving Latency from 1.11s to 123.6ms on a Distributed SQL DatabaseTL;DR: This post tells how a website on a distributed database reduced online serving latency from 1.11 s to 417.7 ms, and then to 123.6 ms. We found that some lessons learned on MySQL could be applied throughout the optimization process. But when we...Discuss·2 likes·35 readsOpen Source
Abhishek MishraforAbhishek Mishrastalwartcoder.hashnode.net·Jul 15, 2022Moving a Python Application to a Distributed Database in Three Easy Steps.I have been writing APIs and small services in Python (mostly with SQL-based databases) for quite some time now. As developers, we don’t pay too much attention to database performance and scalability unless our application faces real performance issu...Discuss·1 like·77 readsPython
Abhishek MishraforAbhishek Mishrastalwartcoder.hashnode.net·Oct 11, 2022How to Avoid Cloud Outages with YugabyteDB for Python AppsCloud environments provide benefits in terms of scalability and ease of use. They are easy to scale because you can add more resources when necessary. They’re easy to use and quick to build thanks to the ecosystem of cloud services and frameworks. Ho...Discuss·1 like·49 readsPython
Marco BambiniforSQLite Cloudsqlitecloud.hashnode.net·Mar 21, 2023Strong Consistency with Raft and SQLiteIn the recent past, a typical client/server environment consisted of multiple clients connected to a central database server. A central database architecture is a system where all data is stored in a single centralized location. When client A from Si...Discuss·8.4K readsSQLite
M B A R Kformbarkt3sto.hashnode.net·Jan 25, 2023What is a Distributed System?Definition A distributed system is a collection of independently running computer systems that are connected through a network, with the goal of achieving a common goal or providing a common service. These systems work together as a single, unified s...Discuss·39 readsdistributed system
Sofwan A. LawalforBackend Engineering w/Sofwansofwancoder.hashnode.net·Jan 3, 2023Distributed Transactions: OverviewA distributed transaction is one that involves numerous database systems or other resources in a single transaction. Changes made to one system or resource must be reflected in all other systems or resources involved in the transaction in such instan...Discuss·88 readsdistributed system
Adegbenga Agoroforadegbengaagoroadegbengaagoro.hashnode.net·Dec 15, 2022Understanding Distributed DatabasesWhat is a Database A database can be considered an organized collection of data, typically stored and accessed electronically from a computer system or server. Databases are used to store and manage large amounts of structured data, such as financial...DiscussDatabases
OSSInsightforossinsight.hashnode.net·Nov 22, 2022How We Reduced Online Serving Latency from 1.11s to 123.6ms on a Distributed SQL DatabaseTL;DR: This post tells how a website on a distributed database reduced online serving latency from 1.11 s to 417.7 ms, and then to 123.6 ms. We found that some lessons learned on MySQL could be applied throughout the optimization process. But when we...Discuss·2 likes·35 readsOpen Source
Denis MagdaforJava, Databases, Distributed Systemsdmagda.hashnode.net·Nov 7, 2022Geo-Distributed Microservices and Their Database: Fighting the High LatencyAhoy, mateys! My development journey of the first version of the geo-distributed messenger has ended. So in this last article of the series, I’d like to talk about multi-region database deployment options that were validated for the messenger. The h...Discuss·29 readsThe Beauty (and Beast) of Building Geo-Distributed Appsdistributed system
Abhishek MishraforAbhishek Mishrastalwartcoder.hashnode.net·Oct 11, 2022How to Avoid Cloud Outages with YugabyteDB for Python AppsCloud environments provide benefits in terms of scalability and ease of use. They are easy to scale because you can add more resources when necessary. They’re easy to use and quick to build thanks to the ecosystem of cloud services and frameworks. Ho...Discuss·1 like·49 readsPython
Sofwan A. LawalforBackend Engineering w/Sofwansofwancoder.hashnode.net·Oct 11, 2022Try-Confirm-Cancel (TCC) ProtocolIntro In the world of distributed transactions, there are many ways to get transactions working. What is important is that we find a way to make sure they can succeed or fail as a unit. If multiple transactions are going to execute on different datab...Discuss·447 readsbackend
Abhishek MishraforAbhishek Mishrastalwartcoder.hashnode.net·Jul 15, 2022Moving a Python Application to a Distributed Database in Three Easy Steps.I have been writing APIs and small services in Python (mostly with SQL-based databases) for quite some time now. As developers, we don’t pay too much attention to database performance and scalability unless our application faces real performance issu...Discuss·1 like·77 readsPython