Skip to content
Friday, May 09, 2025

DBA Notes

DBA Notes
  • AWS
  • Oracle
  • Postgres
  • Linux
  • Docker
  • MySQL
  • mongodb
DBA Notes

Categories

  • AWS (9)
  • Docker (7)
  • General (4)
  • Linux (14)
  • mongodb (1)
  • MySQL (10)
  • notepad++ (2)
  • Oracle (90)
  • performance (44)
  • Postgres (92)
  • postgresql (8)
  • SQL (16)
  • Windows (7)

Month: September 2023

AWS MySQL

Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime

Bulent Soylu September 30, 2023 auroraawsmysqlserverlessupgrade

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…

View More Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime
Oracle

Oracle RAC interview Questions

Bulent Soylu September 26, 2023 oraclerac

What is RAC?RAC stands for Real Application cluster. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance…

View More Oracle RAC interview Questions
Oracle

What is the difference between RPO and RTO ?

Bulent Soylu September 26, 2023 drHAoraclerporto

Predicting a future disaster is nearly impossible, but fortunately, preparing for one and deciding your organizationโ€™s aftermath is getting easier. Their abbreviated names are very…

View More What is the difference between RPO and RTO ?
Oracle

Oracle Database Architecture

Bulent Soylu September 26, 2023 architectureclient-serverinstanceoracle

Oracle Database employs a client-server architecture, with the database server and client connections running in separate processes. The server process manages data and resources, and…

View More Oracle Database Architecture
MySQL Windows

Run multiple instances of MySQL Server on Windows 10

Bulent Soylu September 19, 2023 mysqlwindows

You can download it from here. Now, run the MySQL community installer. In MySQL Installed, you can view the list of installed products. To add…

View More Run multiple instances of MySQL Server on Windows 10
MySQL

MySQL InnoDB Cluster 8.0 setup

Bulent Soylu September 19, 2023 failoverHAhigh availabilityinnodbreplication

MySQL InnoDB Cluster has proven with the first GA release its potential as the native out-of-the-box HA solution for MySQL. With the second GA release,…

View More MySQL InnoDB Cluster 8.0 setup
Log in

oracle (86)postgres (51)performance (37)postgresql (32)index (11)upgrade (9)linux (9)multitenant (7)pdb (6)partitioning (6)docker (6)windows (5)memory (5)mysql (5)replication (5)execution plan (5)aws (5)sql profiles (4)tuples (4)SQL (4)

Recent Posts

  • ๐—ฆ๐—ค๐—Ÿ ๐—ค๐˜‚๐—ฒ๐—ฟ๐˜† ๐—˜๐˜…๐—ฒ๐—ฐ๐˜‚๐˜๐—ถ๐—ผ๐—ป ๐—ข๐—ฟ๐—ฑ๐—ฒ๐—ฟ!
  • TABLE FRAGMENTATION IN ORACLEย DATABASE
  • Configuring Huge Pages for MySQL Server on Red Hat Linux
  • HUGE PAGES AND POSTGRESQL
  • How to configure HugePages for Oracle Database Server

Archives

  • October 2024 (1)
  • August 2024 (1)
  • March 2024 (3)
  • January 2024 (3)
  • December 2023 (7)
  • October 2023 (17)
  • September 2023 (6)
  • August 2023 (23)
  • July 2023 (10)
  • June 2023 (4)
  • May 2023 (11)
  • April 2023 (15)
  • March 2023 (6)
  • February 2023 (2)
  • January 2023 (11)
  • December 2022 (1)
  • August 2022 (3)
  • March 2022 (10)
  • February 2022 (2)
  • January 2022 (6)
  • December 2021 (3)
  • November 2021 (7)
  • October 2021 (51)
  • September 2021 (4)

DBA Notes | Designed by: Theme Freesia | WordPress | © Copyright All right reserved