Does “do-it-yourself” have to be so hard? Introduction The process of installing Arch Linux is quite different compared to other OS’s. In fact, installing a standard Linux ISO is more similar to installing Windows 10 than it is to installing Arch Linux. …

For when you really just don’t want to pay for vSphere Outline Introduction Requirements Part 0: Installing VirtualBox and Extension Pack on the Command Line Part 1: Creating and Deleting a VirtualBox VM using “VBoxManage” Part 2: Enabling RDP access for a VirtualBox VM Part 3: Additional Considerations Introduction When I was…

CDC-like data pipeline using MySQL binary logs Outline Introduction Creating Security Groups and EC2 Instances (~15 min) Installing MySQL and Configuring to Allow Binary Log Reading (~15 min) Installing/Configuring Kafka and Debezium Connector (~15 min) Introduction In my previous set of tutorials, I explained how to use the Debezium connector to stream…

Creating a CDC data pipeline: Part 3 Outline Introduction Creating Security Groups and EC2 Instances (~5 min) Installing Graphite Carbon, Graphite Web, and StatsD (~15 minutes) Installing Grafana (~5 min) Configuring StatsD (~5 min) Starting All Pipeline Services (~10 min) Configuring Grafana and Creating a Dashboard (~10 min) Completed Python File …

Creating a CDC data pipeline: Part 2 Outline Introduction Creating Security Groups and EC2 Instances (~5 min) Installing/Configuring Spark (~5 min) Starting All Pipeline Services (~10 min) Extracting CDC Row Insertion Data Using Pyspark (~15 min) Running Own Functions on Output Changing the Spark Job to Filter out Deletes and Updates …

Creating a CDC data pipeline: Part 1 Outline Introduction Creating Security Groups and EC2 Instances (~15 min) Configuring SQL Server for CDC (~15 min) Installing/Configuring Kafka and Debezium Connector (~15 min) Reading CDC Topic (~5 min) Addendum 1: Important Commands Used Addendum 2: Next Article in the Tutorial Introduction In this three-part…

How to install a three-node Greenplum Database cluster with segment mirroring — Overview I. Introduction II. System Requirements III. Part 1 — Create AWS Instances (~15 minutes) IV. Part 2 — Setup on Each Node (~15 minutes) V. Part 3 — Initialize Greenplum Database (~15 minutes) Introduction Greenplum Database uses an MPP (massively parallel processing) database architecture that is able to take advantage of…