upgrade – DBA Notes

AWS MySQL

Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime

When Amazon Aurora Serverless v1 came out, it was one of the most exciting new features of 2018. The ability to have a relational database without having…

AWS Postgres postgresql

Upgrade Amazon RDS to major and minor versions of PostgreSQL

Bulent Soylu August 19, 2023 aws-rds postgresql upgrade

Open-source PostgreSQL occasionally releases new minor and major versions that include fixes for frequently encountered bugs, security issues, and data corruption problems. Generally, Amazon RDS aims to support new…

Postgres

Amazon AWS upgrades to Postgres with Bucardo

Bulent Soylu August 13, 2023 aws rds bucardo migration postgresql upgrade

Amazon Relational Database Service (RDS), allows for quick setup and use of a database system. Despite minimizing many database administration tasks, some issues still exist, one…

Postgres

Upgrade PostgreSQL RDS from version 9.x to 12.x using Bucardo

Bulent Soylu August 13, 2023 aws-rds bucardo postgresql upgrade

We are using Aurora PostgreSQL RDS clusters as our Database for our Applications. We were using a 9.x version of Aurora PostgreSQL RDS clusters for…

Oracle

How to upgrade ORACLE 11G to 19C

Bulent Soylu July 2, 2023 oracle upgrade

My Environment for this practice Prerequisites: Before starting the upgrade make sure you have done the below checklist: Stop the Listener Take full database backup…

Oracle

Upgrade Database From 11g To 12c Manually

Bulent Soylu July 2, 2023 oracle upgrade

A database can be upgraded either using DBUA or manual method. But for major production databases, it is better to do it manually, so that…

Oracle

Step by Step Oracle Database Upgrade from 11g (11.2.0.4) to 12c (12.2.0.1) using DBUA

Bulent Soylu July 2, 2023 oracle upgrade

Here we are going to demonstrate step-by-step Oracle database upgrades from 11g (11.2.0.4) to 12c (12.2.0.1), same steps can be followed to upgrade to 12.1.0.2 as well.…