How Do You Install Apache Cassandra on Linux SUSE?

Problem scenario
You are running Linux SUSE and want to install Apache Cassandra.  How do you install Apache Cassandra on Linux SUSE?

Solution
Prerequisites
i.  This solution assumes that you have Java installed.  If you need assistance, see this link.

ii.  This solution assumes your server has a total of 2.5 GB of memory (a combination of either virtual memory or RAM). 

How Do You Write a PHP Web Page That Asks for a SQL Table Name Then Returns the Contents after the User Clicks a Button?

Problem scenario
You want users to be able to enter a table name and then see the content of the table.  How do you create a webpage with a text field and a submit button that will display the content of the table if it exists?

Solution
Overview
This assumes you have the LAPP stack set up on a single server.  To set up the LAPP stack on Ubuntu,

How Do You Optimize Data Warehouse Performance?

Problem scenario
You have a data warehouse that has not been performing as well as you would like.  What are some things that you can do to optimize the performance?

Solution
1.  Schedule processes such as back ups or ETL jobs at different times from hours of peak demand.  Rebuilding indexes can be a good idea or a bad one depending on when it is performed.  Be mindful of when statistics (meta data related to database transactions) are updated. 

How Do You Troubleshoot the Puppet Error “Could not send report: SSL_connect returned=1 errno=0 state=error: certificate verify failed”?

Problem scenario
You try to connect to Puppet master from Puppet agent for the first time (to get the certificate signed).  You run this command:  puppet agent -t -d

But you get this error:  “Error: Could not send report: SSL_connect returned=1 errno=0 state=error:  certificate verify failed:”

What should you do?

Solution
Are you changing the Puppet master for the Puppet agent?  It is acceptable to configure a Puppet agent to communicate with a new Puppet master server. 

How Do You Install Puppet Master on a Debian Linux Server in GCP?

Problem scenario
In Google Cloud Platform you have a Debian Linux server.  You want to install Puppet master on it.  What should you do?

Solution

Prerequisites
We suggest having at least 4.5 GB of memory.  This can be from RAM or a combination of RAM and swap space.  To create 4 GB of /swap/space you can see this posting as a guide,

How Do You Install Apache Cassandra on Ubuntu 16.04?

Problem scenario
You are running Ubuntu 16.x Linux and want to install Apache Cassandra.  How do you install Apache Cassandra on Linux Ubuntu Linux as a single-server configuration?

Solution
These directions will work to deploy Debian 9 Linux too.  They have been tested to work in AWS and GCP.

Prerequisites
i.  This solution assumes that you have installed Apache Ant and Git. 

How Do You Run an Ansible Playbook to Configure 2 GB of Swap Space on Every Linux Server?

Problem scenario
You want every Linux server to have 2 GB of virtual memory.  You want to transfer a Bash script to each server and run it with sudoer privileges.  How do you transfer a file and execute it as a sudoer user?

Solution
1.  Install Ansible.  If you need directions on how to do this with RHEL, see this posting.  For SUSE, see this 

How Do You Write a Bash Script to Create Virtual Memory in the Size of 2 GB on a Linux Server?

Problem scenario
You want to dedicate 2 GB of your hard drive to be virtual memory (swap space for memory-intensive applications).  What should you do to script this that will work on any distribution of Linux (e.g., a RedHat derivative including CentOS/RHEL/Fedora, Debian/Ubuntu, or SUSE)?

Solution

Overview
We consider virtual memory to be a hybrid of RAM “and disk space that running processes can use.

How Do You Install Apache Cassandra on a RedHat Derivative of Linux?

Problem scenario
You want to install Apache Cassandra on CentOS, RHEL, or Fedora Linux.  What do you do?

Solution
These directions will deploy Apache Cassandra in a solo-server configuration.  This will not create a cluster.  These directions will work for a physical server, a VM, an EC-2 instance in AWS or a virtual machine in GCP.

Prerequisites

i.  This assumes that you have 3 GB of memory (in combination of either RAM or virtual memory,

How Do You Upload a Docker Image to Amazon Elastic Container Registry?

Problem scenario
You created your own Docker image.  You want to upload it to a repository so it is available to other servers.  You want to upload a Docker image from your server into ECR (in AWS).  You do not know the name of the repository.  How do you do this?

Solution
Prerequisites

a.  This assumes that ECR has been set up.  If you need assistance,