by heimdalladmin | Aug 17, 2021 | GCP, Web Scale
Background Horizontally scaling your SQL database involves separating the write-master from read-only servers. This allows the write server to perform dedicated write operations while read queries are offloaded to separate replicas. However, this architecture may...
by heimdalladmin | Aug 17, 2021 | GCP, Web Scale
Application-database inefficiency (e.g. repeated queries, network latency) is a primary cause of performance bottlenecks. Query caching is used to improve database responsiveness and scale. But caching is not without its challenges; knowing what to cache and when to...
by heimdalladmin | Jun 3, 2021 | Other
Background Horizontally scaling your SQL database involves separating the write-master from read-only servers. This allows the write server to perform dedicated write operations rather than processing redundant read queries. However, writing to one node and reading...
by heimdalladmin | May 29, 2021 | AWS, Web Scale
Background Many have implemented database caching to improve responsiveness. However, developers are still challenged to know what to cache, what to invalidate and how to ensure that data is up-to-date. For a race car, performance is highly dependent on the skills of...
by heimdalladmin | May 18, 2021 | AWS
Antony Prasad Thevaraj, AWS Solutions Architect One of the primary causes of slow application performance is the inefficient interaction with the database. This can be caused by duplicate queries or an overwhelming number of queries accessing the database resulting...