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 >>
Elevate Your PostgreSQL Skills: The Ultimate Guide to Database Administration Certification
Introduction PostgreSQL is a robust, open-source database management system renowned
Monitor Database Server using Prometheus & Grafana
Prometheus is an open-source monitoring system that collects metrics from
How to Test Disk Throughput on Linux using shell script
Here is a shell script that you can use to
Linux Command List most used by Database Administrator (DBA)
ls – Lists the contents of the current directory.
Automate Postgresql Daily Database Backup using Pgbackreast and bash
#!/bin/bash # Set the backup directory BACKUP_DIR=/backups # Set the
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=
How to Take Full Database Backup using PGBackRest
pgbackrest backup –type=full –db-include= –target= PGBackRest backup for multiple Databases
What is the pgbackrest in PostGreSQL?
How to Install PgBackRest ? The installation process for PGBackRest
How to Configure SSL on PostgreSQL
openssl req -new -x509 -nodes -out server.crt -keyout server.key This
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
awscli Command to Find PostgreSQL rds Free and Used Space
To determine the free and used disk space of a
How to Resize PostgreSQL rds Disk Size Using awscli commands
To resize the disk size of a PostgreSQL RDS instance