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 in a self-managed environment—which is a common practice—or through enterprise Database as a Service (DBaaS) offerings like […]
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 initial years of my career, I predominantly worked with commercial relational database management systems (RDBMS) such as […]
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 only uses shared_buffers). We discuss the internals of caching and various methods to measure cache usage in […]
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 starting “Dynamodb for DBAs” series with this post. This blog post helps you in calculating RCUs and […]
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 approaches to achieve this viz. COPY (create shadow table, copy, swap), INPLACE (online DDL that allow parallel […]
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 Make sure you have all the prerequisites addressed . For example psycopg2 and python3 are needed to […]
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 your lambda function . Writing function is one thing but getting it to work optimally can be […]
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 the log ? Lets say you are running a performance test and you want to generate a […]
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 if you have not done that already 1) Synchronous_standby_names and its significance We have seen cases where […]
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 the cloud era . The cloud does not negate the need of DBAs ; They are very […]