Managing a Database Engine

To view a list of the currently defined engines, select the Database Engines node in the PEM Browser tree control and navigate to the Properties tab.

_images/pem_ark_manage_database_engine_properties.png

The Properties tab displays detailed information about the currently defined engines:

  • The Name field displays the user-friendly name of the database engine.
  • The Engine ID field displays the engine identifier.
  • The Enabled field displays the current state of the database engine.
  • The Database type field dislays the type of database used by the engine.
  • The Version field displays the server version used by the engine.
  • The Server type field displays type of the backing operating system.
  • If applicable, the RHEL subscription field displays the identifier of the RHEL subscription used by the engine.

You can use options on the engine’s context menu to manage the engine.

_images/pem_ark_manage_database_engine_context.png

To access the context menu, right-click on the engine name in the PEM Browser tree control. Then, to manage the engine, select from the menu options:

Option Action
Refresh Select Refresh to update the definition of the database engine.
Delete/Drop Select Delete/Drop to delete the engine. PEM will confirm that you wish to delete the engine before removing it.
Enable database engine Select Enable database engine to make the engine available for use when deploying a cluster.
Disable database engine Select Disable database engine to make the engine unavailable for use.
Properties… Select Properties… to review or modify engine properties.

Enabling or Disabling a Database Engine

Enabled engines are available for use when provisioning clusters; disabled engines are not made available. There are two ways to enable or disable a database engine - you can:

  • Right-click on the engine name in the PEM browser tree control and select Enable database engine or Disable database engine from the context menu.
  • Use the Enabled slider on the database engine Properties dialog to control the state of the engine.

To open the Properties dialog, right-click on the engine name and select Properties… from the context menu:

_images/pem_ark_enable_database_engine.png

Move the Enabled slider to the Yes position to make the engine available for cluster provisioning. To disable an engine, move the slider to the No position.

Please note that disabling an engine has no impact on any running clusters; it simple prevents users from creating new clusters with the engine. You can use this feature to phase out the use of older engines.

Deleting a Database Engine

To delete an engine definition, right-click on the engine name in the PEM browser tree control, and select Delete/Drop from the context menu. The PEM server will prompt you to confirm that you wish to delete the engine before the engine is deleted. Please note that you cannot remove an engine that is referenced by one or more clusters and/or backups.