ControlTier > controltier-elements
 

MysqlRdb

A MySQL database instance

Overview

Open in Workbench MysqlRdb: A MySQL database instance

Design

Super Type
Rdb
Role Concrete. (Objects can be created.)
Instance Names Unique
Notification false
Template Directory
Data View Children, proximity: 1
Logger Name MysqlRdb

Constraints

Allowed Child Dependencies

1: These types have a Singleton constraint. Only one instance may be added as a resource.

Allowed Parent Dependencies

  • Deployment
  • Node
  • Site

Attributes

Defaults for Imported Attributes

Name Default
mysqlPort 3306

Commands

Note
Commandline options displayed in square brackets "[]" are optional. If an option expects arguments, then angle brackets are shown after the option "<>". Any default value is shown within the brackets.

Docs-Generate

generates all defined docs

Usage
Docs-Generate [-archivedir <${entity.instance.dir}/var>] [-pass <ctierpass>] [-port <3316>] [-user <ctier>]

Options

Option Description
archivedir dir to store current output docs
pass db pass
port listen port
user dbuser

assertServiceIsDown

checks if the service is down

Usage
assertServiceIsDown

assertServiceIsUp

checks if the service is running

Usage
assertServiceIsUp

installDb

installs the database

Usage
installDb

startService

starts the service

Usage
startService

stopService

stops the service

Usage
stopService

Prepare

creates the db and prepares it for use

Usage
Prepare

Workflow

  1. Install
  2. Stop
  3. Configure
  4. installDb
  5. Start
  6. Schemas-Prepare

Related Types

The following types are defined for use with MysqlRdb.

MysqlSetting

Overview

Open in Workbench MysqlSetting: A MySQL configuration setting

Design

Super Type
Setting
Role Abstract. (Objects cannot be created.)
Instance Names Unique

Constraints

Allowed Parent Dependencies

MysqlBasedir

Overview

Open in Workbench MysqlBasedir: The MySQL installation directory

Design

Super Type
MysqlSetting
Role Concrete. (Objects can be created.)
Instance Names Unique

Attributes

Exported Attributes
Name Property
mysqlBasedir settingValue

MysqlDatadir

Overview

Open in Workbench MysqlDatadir: The MySQL data directory

Design

Super Type
MysqlSetting
Role Concrete. (Objects can be created.)
Instance Names Unique

Attributes

Exported Attributes
Name Property
mysqlDatadir settingValue

MysqlNode

Overview

Open in Workbench MysqlNode: The node hosting the MySQL instance

Design

Super Type
MysqlSetting
Role Concrete. (Objects can be created.)
Instance Names Unique

Attributes

Exported Attributes
Name Property
mysqlNode settingValue

MysqlPort

Overview

Open in Workbench MysqlPort: Port used by MySQL

Design

Super Type
Port
Role Concrete. (Objects can be created.)
Instance Names Unique

Attributes

Exported Attributes
Name Property
mysqlPort settingValue

MysqlLoadScript

Overview

Open in Workbench MysqlLoadScript: Schema load script used by MySQL

Design

Super Type
MysqlSetting
Role Concrete. (Objects can be created.)
Instance Names Unique

Attributes

Exported Attributes
Name Property
mysqlLoadScript settingValue

MysqlPassword

Overview

Open in Workbench MysqlPassword: A MySQL schema username and password

Design

Super Type
MysqlSetting
Role Concrete. (Objects can be created.)
Instance Names Unique

Attributes

Exported Attributes
Name Property
pass settingValue
user settingType