Domain 1: Workload-Specific Database Design 26%Domain 2: Deployment and Migration 20%Domain 3: Management and Operations 18%Domain 4: Monitoring and Troubleshooting 18%Domain 5: Database Security 18%TOTAL 100%
alter pluggable database orclpdb open; Of course you will want to connect as sys “sqlplus / as sysdba” or equivalent to issue this command. Here is a link to Oracle’s views on pluggable DBs: https://docs.oracle.com/database/121/ADMIN/cdb_mon.htm#ADMIN13933 SELECT * FROM DBA_PDBS;
psql \–host=dbid.xxx.us-east-1.rds.amazonaws.com \–port=5432 \–username=postgres \–password \–dbname=postgres
This because using the primary key will usually result in a much lower cost query and how do you do that? Avoid the “table.scan” function at all cost, as it will scan all rows in your table, even if you eventually don’t need 99.9999% of them, and the count against your consumed RCUs. import boto3 …
DynamoDB is all about knowing your data access patterns Read More »
All of these are commonly refered to as SQL Injection Faults Fault Injection – Reader or Writer Crash ALTER SYSTEM CRASH [ INSTANCE I DISPATCHER | NODE ]; Instance = DB instance (default crash type) Dispatcher = writes updates to the cluster volume Node = Instance + Dispatcher Fault Injection – Replica Failure ALTER SYSTEM …
Normally this is used to pre-warm postgresql memory caches on cross-region or same region read replicas. If there is an outage of the primary the lowest tier read replica will be automatically be promoted to primary (largest instance rule also applies if there is a tie at tier level). To enable CCM, set apg_ccm_enabled= 1in …
• Create IAM role with a policy that allows Aurora to write to the given S3 bucket • Attach the role to the Aurora cluster • add the role ARN to a cluster parameter group and attach the …
Spooling or exporting RDS / Postgresql data to S3 – here is one way Read More »
Certain SQL operations like group by, sort, joins may use Aurora temporary storage. This local storage within the cluster. The amount of temporary storage allocated and available to use is dependent on the class and size of the cluster you spin up. Smallish clusters will exhaust and cause errors like ERROR: XXX temporary file NO …
Using pg_ctl will work for almost all on-prem postgresql installs on my Mac OS a startup looks like this: Clearly (maybe 😉 my installed postgresql is version 15 and it. is installed here: /Library/PostgreSQL/15