davethemaker

Category: DB

  • Exploring EBS

    In this exercise, I want to gain additional experience working with Elastic Block Storage – one of three types of storage that AWS offers (the othes include Block and EFS/FSx file storage). I’m going to be creating an EBS volume and then then working with it. Let’s take a look: I have a t3.micro EC2…

  • Migrating to RDS

    In this post, I’m going to reference a lab that I am working on- the scenario is we have a single EC2 instance running Linux OS, an Apache server, and an app with PHP (LAMP stack). The instance is doubling as a database server, which is not ideal because then we are responsible on patching,…

  • AWS Architecting MySQL and Workbench

    In this exercise, I’m going to pull together a number of different threads – namely, the design and implementation of the infrastructure to spin up an EC2 instance (hosting Workbench, which will allow me to interact with a database) and an RDS MySQL instance. My objective is to be able to create a database and…

  • Not cookies..Baking an AMI!

    In a previous post I manually spun up an EC2 instance and then installed and configured an Apache server and MariaDB to run a WP instance. It was useful for learning purposes, and as a reference of the benefits of automation! In this post, I’m going to be baking an AMI image, that is, creating…

  • How *not* to use AWS services: monolithic WP installation on single EC2

    I’ve been working with Terraform in creating an EC2 instance and provisioning it within a single AZ and subnet. I haven’t instantiated any scaling groups yet, though that’s on the near horizon, which is, along with an ELB, important for failover reasons and minimizing risks. In this post, I’m going to get some hands-on experience…

  • Working with SQL : ER > Tables

    In this post, I want to dive a bit deeper into SQL – I wrote about this in a few other posts, but lately I’ve been working with Flask (a framework for building back-end python apps) and realize that I want to make sure I’m solid in this foundation. It’s going to be important going…

  • Back-End Dev’t With Flask

    LIke other posts I’ve made recently, this one will detail my efforts to learn the Flask framework hand-in-hand with what I’ve been learning recently: Python, SQL, databases, and more. There’s a lot of information, both conceptual and technical, and it’s really helpful to have these kinds of notes to be able to reference down the…

  • Postgres: ER diagram > DB tables

    In this posting, I’m going to detail the steps that I took to successfully complete an exercise, where a ficticious company has given requirements for its operations, reflected by an ER diagram. My mission is to translate that into a technical solution, creating a Postgres database, complete with tables, to meet those requirements. Let’s get…

  • DBs +Data Modeling

    I’m learning to work with databases so will save some of my learning in these posts. There are four main types of DBs: flat file (like AWS S3 bucket), Relational (SQL), schemaless (NoSQL) and key-value store. I recently created a python application that used a key-value approach to store data, but it was rudimentary in…