You are not just on your own when using RDS, there are security offerings in place. First off you have your at-rest encryption similar to an EC2 instance when you first create you RDS DB you have the option to enable encryption, AWS KMS. Similar to EC2 if you want to enable encryption on a…
Author: admin
Post #104 (AWS) – Aurora, advanced concepts
Yes, you read that right there’s even more to Aurora. First off you’ve got custom endpoints, as I mentioned in my last post you have your write endpoint and your read endpoint well you can set a custom endpoint and add your Aurora instances to it, this is useful if you perhaps have a set…
Post #103 (AWS) – Aurora, AWS’ DB service
Aurora is proprietary and only available on AWS. Any drivers you use for MySQL and PostgreSQL will work for it. It has 5x the performance of MySQL and and 3x the performance of PostgreSQL. Aurora supports up to 15 read replicas and 128 TB of storage, the storage and read replicas scale with size with…
Post #102 (AWS) – Custom RDS (Only usable with Oracle DB and Microsoft SQL)
When you use RDS normally it is 100% managed by AWS, you do not have access to the underlying instance running your database. Well with custom RDS if you are using Oracle DB or Microsoft SQL then you have the ability to access the underlying OS and make patches and edit the DB directly! It…
Post #101 (AWS) – Multi-AZ RDS
Multi-AZ RDS, not to be confused with read replicas, allows you to create a standby instances for your RDS, this has neither read nor write capabilities. It is synchronized atomically with the primary DB in fact the original RDS must be able to forward the information to the standby RDS before it will save it…
Post #100 (AWS) – Relational Database Service and a little information on read replicas
First allow me to start with how excited I am to have made it to the 100th post on this site! It’s been over a year since I’ve started and I’ve felt I learned a lot and this site has been a big part of it. Now onto the information! The Relational Database Service, or…
Post #99 (AWS) – ASG Scaling Policies
The ASG scaling policy you select determines how your ASG will automatically scale in or scale out your EC2 instances. To start off you have dynamic scaling, this includes target tracking, simple scaling and step scaling. Target tracking is the simplest you simply decide a specific function say CPU utilization and specify your desired capacity…
Post #98 (AWS) – Auto Scaling Groups
Auto Scaling Groups, or ASGs, are a way to automate the expansion or shrinking of your number of EC2 instances based on usage. You set a minimum number of instances, a maximum number of instances, and your desired number and the ASG does the scaling as needed. You are only charged for the instances you…
Post #97 (AWS) – De-registration Delay
A de-registration delay refers to a period of time from 1 to 3600 seconds where your LB will allow in-flight, on going, requests to complete before the machine is deregistered, most likely for being in an unhealthy state. During this period new requests are not accepted but requests that have already gone through will have…
Post #96 (AWS) – Server Name Indication
I will not get into the exact usage of SSL certificates, but I would like to talk about Server Name Indication. With your ALB and NLB load balancer you can enable SNI. This setting allows you to have a client specify the hostname of the EC2 instance they are connecting to. Allow me to explain…