MySQL-S3 ServerTemplates
Table of contents
Before jumping into the runbook situations we want to briefly introduce the 2 existing templates used
by Manager for MySQL. Understanding their main differences will clarify the sequence of steps described
for each of the situations below.
NOTE: Before version 2 of the Manager for MySQL, the templates below were named "Master MySQL
v1" and "Slave MySQL v1," instead of "Bootstrap MySQL" and "Additional MySQL." Therefore substitute
the names if you're working on a version earlier than 2.
MySQL Bootstrap
This ServerTemplate is ONLY launched when there is no other MySQL instance running. This is the
template is only used to bootstrap a new Manager for MySQL system. Therefore, unless a catastrophic
failure killing all MySQL instances occurs, this template will only be launched once in the lifetime of that
application. Any life-cycle operations on the system are done by launching an "Additional MySQL"
template (see below) and performing operational tasks such as promoting instances to master,
initializing as slaves etc.
The sequence of boot scripts executed by this template roughly consists of:
- Preparing the instance disks (installing lvm tools, partitioning and formatting)
- Registering the master's DNS
- Installing and initializing the necessary MySQL software
- Setting up permissions used by Manager for MySQL
- Restoring the latest DB backup
- Preparing the instance for the continuous backups to S3
MySQL Additional
This is the the server template that is used when there is at least one other MySQL instance running in
the system (i.e., all situations except the bootstrap process). Launching this template can be seen as
launching a wildcard MySQL template, that can be molded and 'configured' after it completes the
initialization. For example, to launch a new slave MySQL server, we can boot this template, and once
it's operational, we can click on the "initialize as slave" button.
The sequence of boot scripts executed by this template is basically the same as the bootstrap one,
except that it doesn't register the master DNS and it doesn't restore any previous backup:
- Preparing the instance disks (installing lvm tools, partitioning and formatting)
- Installing and initializing the necessary MySQL software
- Setting up permissions used by Manager for MySQL
- Preparing the instance for the continuous backups to S3
- Tag page
-
- What links here
