Lab 1 - Blueprint (MySQL)¶

Tabbed Navigation¶

For now, let’s step through each tab:

Blueprint Editor Overview¶

Welcome to the Blueprint Editor! Let’s take a look at the interface.

There are 2 more buttons that are helpful to use while making a blueprint:

Create Blueprint Workflow¶

1. Create Object in Application Overview or select existing object from the workspace or the Overview panel.
2. Configure the object in the configuration pane.
3. Repeat for each object.
4. Connect dependencies in the workspace.

Let’s get started by setting up the basics

Update the Blueprint Name to Calm_Workshop

Click on the Credentials button along the top of the Blueprint workspace. Update credentials as follows:

Setting Variables¶

In this subsection we’ll create some variables. It’s not necessary to do it at this point, however it will make things easier for the rest of the lab.

• Variables have 2 settings, Secret and Runtime. Normally variables are stored in plaintext and shown in the window here, the Secret setting changes that (perfect for passwords). Runtime specifies if this variable should be static (and only editable here) or should be able to be changed during the Launch Process.
• Variables can be referred to while configuring VMs using the @@{variable_name}@@ construct - Calm will evaluate and replace that string before sending it down to the VM.

Setup the variables as specified in the table below:

Adding A DB Service¶

We’ll now create the basic service.

• Click the + sign next to Services in the Overview pane.
• Notice that the Configuration pane has changed and there is now a box in the Workspace.
• Name your service MYSQL in the Service Name field.
• The Substrate section is the internal Calm name for this Service. Name this MYSQLAHV
• Make sure that the Cloud is set to Nutanix and the OS set to Linux
• Configure the VM as follows:

VM Name .  : MYSQL
Image .    : CentOS
Disk Type .: DISK
Device Bus : SCSI
vCPU .     : 2
Core/vCPU .: 1
Memory     : 4 GB

• Scroll to the bottom and add the NIC bootcamp to the MYSQL VM.
• Configure the Credentials to use CENTOS created earlier.

Package Configuration¶

• Scroll to the top of the Service Panel and click Package.
• Name the install package MYSQL_PACKAGE
• Set the install script to shell and select the credential CENTOS created earlier.
• Copy the following script into the script field of the install window:

#!/bin/bash
set -ex

yum install -y "http://repo.mysql.com/mysql-community-release-el7.rpm"
yum update -y
yum install -y mysql-community-server.x86_64

/bin/systemctl start mysqld

#Mysql secure installation
mysql -u root<<-EOF

#UPDATE mysql.user SET Password=PASSWORD('@@{Mysql_password}@@') WHERE User='@@{Mysql_user}@@';
DELETE FROM mysql.user WHERE User='@@{Mysql_user}@@' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
DELETE FROM mysql.user WHERE User='';
DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%';

FLUSH PRIVILEGES;
EOF

sudo yum install firewalld -y
sudo service firewalld start
sudo firewall-cmd --add-service=mysql --permanent
sudo firewall-cmd --reload

#mysql -u @@{Mysql_user}@@ -p@@{Mysql_password}@@ <<-EOF
mysql -u @@{Mysql_user}@@ <<-EOF
CREATE DATABASE @@{Database_name}@@;
GRANT ALL PRIVILEGES ON homestead.* TO '@@{Database_name}@@'@'%' identified by 'secret';

FLUSH PRIVILEGES;
EOF

• Looking at this script, we see that we’re using the variables we set before and doing basic mySQL configuration. This can be customized for whatever unique need you have.
• Since we don’t need anything special ran when uninstalling, we will just add a very basic script to the uninstall. This can be useful for cleanup (for example, releasing DNS names or cleaning up AD), but we won’t use it here.
• Set the uninstall script to shell and select the credential CENTOS created earlier.
• Add the following to the script field in the uninstall window:

#!/bin/bash
echo "Goodbye!"

• After completing the configuration, click the Save button. If any errors come up, go back and review the configuration to ensure that all fields have been filled.