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 ➜Postgres INT out of range – What to do ?
Table of Contents Introduction – What is covered here ? “ERROR: integer out of range” : This error can cause a lot of trouble in production environments . We are going to cover this scenario in detail here...
Read More ➜KloudDB Shield 1.3 – HTML Feature
Table of Contents What is klouddb_Shield ? Klouddb_Shield is an open source security tool that checks for CIS compliance . Currently we check for 8 RDS controls , 32 controls(Postgres) , 46 MySQL controls – a total...
Read More ➜Postgres User Poll Results – Part 1
Table of Contents What is included in this blog post ? In this blog post we are presenting poll results for several polls published on Linkedin by KloudDB . Poll topics included are 1) Type of replication...
Read More ➜Postgres for Oracle DBAs – Script execution and default tablespaces
Table of Contents What is included in this blog post ? We are starting “Postgres for Oracle DBAs” series with this post . In this post we compare two aspects – 1) Executing sql scripts 2) Default...
Read More ➜Aurora PostgreSQL Gotchas – Part 2
Table of Contents What is included in this blog post ? This is part 2 of the Aurora postgres series . In part 1 https://klouddb.io/aurora-postgresql-gotchas-part-1/ we covered below topics Shared_buffers config is different Pg_hba file cannot be updated...
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 ➜How TPS increased from 65k to 84k using multiple Pgbouncer instances
Table of Contents What is the multi-instance feature in Pgbouncer ? How is it beneficial ? PgBouncer supports SO_REUSEPORT socket option, which allows running multiple instances of PgBouncer on the same host(using same port).PgBouncer instances on the...
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 ➜