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 […]
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 What is the error ? How to react ? What are sequence gaps ? How to reduce […]
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 of 86 checks as of today and we plan to add more checks soon Please see previous […]
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 people are using 2) Backup tool – Pgbackrest Vs WAL-G Vs pgbasebackup Vs BART/Barman/Pgprobackup etc.. 3) Postgres […]
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 tablespaces Multiple script execution methods are compared with Postgres in this blog post . We also discuss […]
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 in Aurora Max_connection defaults are different in Aurora Pg_stat_statements reset issue In this part we cover 4 […]
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 […]
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 same host can solve the single-core bottleneck issue and sometimes improve the TPS In this blog we […]
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 […]