Table of Contents
Why AWS?
Cloud is becoming a vital part of Database Administration because it provides various database services & Infrastructure to run Database Ecosystems instantly. AWS (Amazon Web Services) is one of the pioneers in the Cloud according to the Gartner magic quadrant. Knowing more cloud infrastructure technologies is going to give more mileage to your Administrator career. In this article, you will find some of the AWS services which Database Administrators should know as they are basic to run Database opration.
Essential AWS Services List For Database Administrator (DBA)
Network
VPCs
Subnets
Elastic IPs
Internet Gateways
Network ACLs
Route Tables
Security Groups
Private Subnets
Public Subnets
AWS Direct Connect
Virtual Machine
EC2
AWS Work Space
Storage
EBS
EFS
S3
Database as Services (RDS)
MySQL / MariaDB
PostgreSQL
Oracle
Micrsoft SQL Server
AWS Aurora PostgreSQL/MySQL
Database Managed Services
AWS Dynamo DB
AWS Elasticsearch
Amazon DocumentDB
Messaging & Event Base Processing
Apache Kafka (Amazon MSK)
Warehousing/ OLAP /Analytics Stagging DB
AWS Redshift
Monitoring
Cloud watch
Amazon Grafana
Amazon Prometheus
Email Service
Amazon Simple Notification Service
Security
IAM
Secrets Manager
Database Task Automation
AWS Batch
AWS Lambda
Cloud Formation
Command-line interface (CLI) to Manage AWS Services
AWSCLI
Migration
Database Migration Service
Budget
AWS Cost Explorer
AWS Budgets
Some other Services & Combination worth of Exploring
Bastion Host For DBA
MongoDB running on EC2
ELK (Elastic Search , LogStach, Kibana) running on EC2
Tunnels for Non stranded ports for Database Connections for more security
pg_pool or pg_Bouncer for PostgreSQL Databases
Stay Tuned For Latest Database, Cloud & Technology Trends
Read More >>
Monitor Database Server using Prometheus & Grafana
Prometheus is an open-source monitoring system that collects metrics from different sources, stores them, and provides a query language and visualization capabilities to analyze and
How to Test Disk Throughput on Linux using shell script
Here is a shell script that you can use to test disk throughput using 1MB, 10MB, 100MB, 1000MB, and 10000MB: #!/bin/bash # Define variables for
Linux Command List most used by Database Administrator (DBA)
ls – Lists the contents of the current directory. cd – Changes the current working directory. pwd – Prints the current working
Automate Postgresql Daily Database Backup using Pgbackreast and bash
#!/bin/bash # Set the backup directory BACKUP_DIR=/backups # Set the PGBackRest configuration file path PGCONF=/etc/pgbackrest.conf # Set the date format for the backup file name
How to Take PostgGreSQL Database Backup on AWS S3 bucket using PGBackRest ?
[global] log-level-console=info repo1-path=/pgbackrest repo1-retention-full=2 repo1-retention-archive=1 repo1-s3-bucket= repo1-s3-endpoint= repo1-s3-key= repo1-s3-key-secret= repo1-s3-region= repo1-s3-uri-style=path pgbackrest backup –type=full –target=s3:
How to Take Full Database Backup using PGBackRest
pgbackrest backup –type=full –db-include= –target= PGBackRest backup for multiple Databases To take a backup of multiple databases with PGBackRest, you can use the –db-include option
What is the pgbackrest in PostGreSQL?
How to Install PgBackRest ? The installation process for PGBackRest varies depending on your operating system and the package manager you’re using. Here are the
How to Configure SSL on PostgreSQL
openssl req -new -x509 -nodes -out server.crt -keyout server.key This will generate a certificate and a private key file in the current directory. Configure PostgreSQL
RPA (Robotic Process Automation) for Database Administartor (DBA)
How to Become an Efficient, Prompt and Successful Database Administrator (DBA)
How to Start and Stop the PostgreSQL Database
AWS aws rds start-db-instance –db-instance-identifier aws rds stop-db-instance –db-instance-identifier Linux –Run as postgresql linux user pg_ctl start -D –Run as postgresql linux user pg_ctl stop
awscli Command to Find PostgreSQL rds Free and Used Space
To determine the free and used disk space of a PostgreSQL RDS instance using the AWS CLI, you can use the describe-db-instances command and filter
How to Resize PostgreSQL rds Disk Size Using awscli commands
To resize the disk size of a PostgreSQL RDS instance using the AWS CLI, you need to follow these steps but before that try to
Copy Table From one PostgreSQL RDS to Another using Python Boto3
To copy a table from one PostgreSQL RDS instance to another using Python and boto3, you will need to: Install the Python library psycopg2, which