Cost savings by migrating from MongoDB on Atlas to Self-Managed
Table of Contents In this article, we will delve into an intriguing aspect of identifying the optimal and cost-effective solution for hosting a MongoDB deployment. MongoDB clusters can be set up in a myriad of ways, whether...
Read More ➜
Is it possible for a DBA/DBE to earn 1 million USD annual compensation ?
Table of Contents My journey from Traditional RDBMS DBA to Opensource DBE/DBA My journey in the field of database administration (DBA) commenced in 2006 when I took on the role of an IBM DB2 DBA. During the...
Read More ➜
Pgfincore and Pg_buffercache to troubleshoot performance issues
Table of Contents What is included in this blog post ? In this blog post we discuss about the importance of pg_buffercache and pgfincore extensions . Postgres uses shared_buffers and OS cache to cache data,indexes,.. (In Aurora it...
Read More ➜
Dynamodb for DBAs – Calculating RCUs and WCUs
Table of Contents What is included in this blog post? Dynamodb is a widely used db service and as a cloud DBA/DBE you may need to support Dynamodb tables in addition to RDS , Aurora etc.. We are...
Read More ➜
Understanding How ONLINE DDL (INPLACE) works in MySQL
Introduction A database undergoes series of Schema/DDL changes during its tenure. Frequency of these changes might be less compared to normal DML workload but they are crucial and complex part of any DB workload. MySQL provides 3 inherent...
Read More ➜
Db utility to create 4 sample dbs
Table of Contents Postgres sample dbs – What is covered here ? We are releasing a free utility to deploy postgres sample database- You can deploy pagila , pgbench, dvdrental and postgres_air databases using this utility https://github.com/klouddb/klouddb_tools/tree/main/postgres_sampledb Prerequisites...
Read More ➜
Lambda tuning for DBAs – 130X improvement
Table of Contents Problem description – Initial latency numbers With the advent of cloud, people are using lambda functions to automate repetitive tasks . You can use python , node js etc .. as a programming language for...
Read More ➜
PostgreSQL Tips and Tricks – Part 2
This is part 2 of the series . Please read Part1 by clicking this URL https://klouddb.io/postgresql-tips-and-tricks-part-1/ 1. Log rotation Postgres log is automatically rotated depending on config like log_rotation_age, log_rotation_size, etc… What if you want to manually rotate...
Read More ➜
PostgreSQL Tips and Tricks – Part 1
We are starting a new blog series from today where we plan to present interesting tips and tricks that can help you in managing postgres servers. We recommend you to go through our PgPool series and RDS series...
Read More ➜
Managing RDS MySQL logs – RDS needs DBA -1
RDS is popularly known as AWS managed service but we would like to call it as CloudDBA managed service . We are starting this series “RDS – Managed by CloudDBA” to focus on the need for DBA in...
Read More ➜