RdbMysqlStrategy
MySQL RDB strategy
Overview
RdbMysqlStrategy:
MySQL RDB strategy
This is a implementation defining various basic rdb management operations for MySQL.
Design
- Super Type
- RdbStrategy
| Role | Concrete. (Objects can be created.) |
| Instance Names | Unique |
| Notification | false |
| Template Directory | |
| Data View | Children, proximity: 1 |
| Logger Name |
Constraints
Attributes
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.
assertSchemaIsDown
Checks schema is unavailable in the designated instance
- Usage
- assertSchemaIsDown [-config <>] -installroot <> [-instance <>] [-password <>] -schema <> [-strategy <>] [-username <>]
Options
| Option | Description |
|---|---|
| config | Database configuration file |
| installroot | path to database install |
| instance | Database server instance name |
| password | Schema user's password |
| schema | Database schema name |
| strategy | Database strategy name |
| username | Schema user name |
assertSchemaIsUp
Checks schema is available in the designated instance
- Usage
- assertSchemaIsUp [-config <>] -installroot <> [-instance <>] [-password <>] -schema <> [-strategy <>] [-username <>]
Options
| Option | Description |
|---|---|
| config | Database configuration file |
| installroot | path to database install |
| instance | Database server instance name |
| password | Schema user's password |
| schema | Database schema name |
| strategy | Database strategy name |
| username | Schema user name |
assertServiceIsDown
Checks that rdb instance is down
- Usage
- assertServiceIsDown [-config <>] -installroot <> [-instance <>] [-password <>] [-strategy <>] [-username <>]
Options
| Option | Description |
|---|---|
| config | Database configuration file |
| installroot | path to database install |
| instance | Database server instance name |
| password | Schema user's password |
| strategy | Database strategy name |
| username | Schema user name |
assertServiceIsUp
Checks that rdb instance is up
- Usage
- assertServiceIsUp [-config <>] -installroot <> [-instance <>] [-password <>] [-strategy <>] [-username <>]
Options
| Option | Description |
|---|---|
| config | Database configuration file |
| installroot | path to database install |
| instance | Database server instance name |
| password | Schema user's password |
| strategy | Database strategy name |
| username | Schema user name |
runSqlScript
Runs the sql script
- Usage
- runSqlScript [-buildstamp <>] [-config <>] [-failonwarnings <>] -installroot <> [-instance <>] [-password <>] -schema <> [-sqlscript <>] [-strategy <>] [-username <>]
Options
| Option | Description |
|---|---|
| buildstamp | build stamp |
| config | Database configuration file |
| failonwarnings | if arg true, fail if there are import warnings |
| installroot | path to database install |
| instance | Database server instance name |
| password | Schema user's password |
| schema | Database schema name |
| sqlscript | sql script to run |
| strategy | Database strategy name |
| username | Schema user name |
Export
Exports the schema to a file
- Usage
- Export [-buildstamp <>] [-config <>] -exportfile <> -installroot <> [-instance <>] [-password <>] -schema <> [-strategy <>] [-username <>]
Options
| Option | Description |
|---|---|
| buildstamp | build stamp |
| config | Database configuration file |
| exportfile | Output file |
| installroot | path to database install |
| instance | Rdb server instance name |
| password | Schema user's password |
| schema | Rdb schema name |
| strategy | Database strategy name |
| username | Schema user name |
runImport
runImports the schema
- Usage
- runImport [-buildstamp <>] [-config <>] [-export_user <>] -exportfile <> [-failonwarnings <>] -installroot <> [-instance <>] [-password <>] -schema <> [-sqlscript <>] [-strategy <>] [-username <>]
Options
| Option | Description |
|---|---|
| buildstamp | build stamp |
| config | Database configuration file |
| export_user | from user |
| exportfile | dump file to import |
| failonwarnings | if arg true, fail if there are import warnings |
| installroot | path to database install |
| instance | Database server instance name |
| password | Schema user's password |
| schema | Database schema name |
| sqlscript | sql script to run before import |
| strategy | Database strategy name |
| username | Schema user name |
createSchema
Creates the schema
- Usage
- createSchema -installroot <> [-instance <>] -password <> [-schema <>] -sqlscript <> -username <>
Options
| Option | Description |
|---|---|
| installroot | Database server installation root directory |
| instance | Database server instance name |
| password | Schema user's password |
| schema | Database schema name |
| sqlscript | sql script to construct schema |
| username | Schema user name |
grantSchema
Grants access to the schema
- Usage
- grantSchema -installroot <> [-instance <>] [-password <>] [-rdbclients <localhost>] -schema <> [-username <root>]
Options
| Option | Description |
|---|---|
| installroot | Database server installation root directory |
| instance | Database server instance name |
| password | Schema user's password |
| rdbclients | allowed client nodes |
| schema | Database schema name |
| username | Schema user name |