Application Services provides samples of database server services that a catalog administrator can use to create or update an existing application.

Many of the sample services are available in the predefined applications such as Clustered Dukes Bank, Clustered Dot Shopping Cart, Nanotrader, Radiant CMS, and jPetStore.

Use the predefined sample catalog service only in a test environment.

Table 1. Database Server Services

Sample Service

Service Description

Supported Operating Systems

Supported Application Components

Associated Service Tag

vFabric GemFire 6.6.0-vFabric51

Installs the service and makes the vFabric GemFire libraries available for use.

You can set the properties such as VERSION, REPO_RPM to set the version and name for the vFabric package.

The Hyperic Agent service does not monitor this version of the vFabric GemFire service.

  • RHEL 6.4.0 32-bit

  • RHEL 6.4.0 64-bit

  • RHEL 6.1.0 32-bit

  • RHEL 6.1.0 64-bit

SCRIPT

Database Servers

vFabric SQLFire 1.0.0

Installs the server and starts an instance of the service using the values that you defined in the client_port and multicast_port properties.

The Hyperic Agent service does not monitor the vFabric SQLFire service.

  • CentOS 6.4.0 32-bit

  • CentOS 6.4.0 64-bit

  • CentOS 6.3.0 32-bit

  • CentOS 6.3.0 64-bit

  • RHEL 6.4.0 32-bit

  • RHEL 6.4.0 64-bit

  • RHEL 6.1.0 32-bit

  • RHEL 6.1.0 64-bit

  • Ubuntu 12.04.2 32-bit

  • Ubuntu 12.04.2 64-bit

SCRIPT

Database Servers

vFabric SQLFire Server 1.0.3

Installs the server and starts an instance of the service using the values that you defined in the client_port and multicast_port properties.

The Auto-Bind feature binds the vFabric SQLFire Server and Locator services to each other when they are added to an application blueprint. The vFabric SQLFire Server service should be on a clustered node, and the vFabric SQLFire Locator service should be on a single node.

The vFabric SQLFire Server service includes the following properties to customize a service in your application:

  • username. Specifies the SQLFire user name. This property is exposed for other services such as tc Server, to use when they connect to SQLFire server.

  • password. Specifies the user password that is set in the username property.

  • multicast_port. Specifies the port used for multicast communication with other members of the distributed system. The default port value is 12333.

  • number_of_servers. Specifies the number of SQLFire servers to start. The default server value is 1.

  • client_port. Specifies the port that the network controller listens on for client connections. The default port value is 1528.

  • initial_heap. Specifies the initial heap size of the JVM in which the SQLFire Server runs. The default size value is 512MB.

  • java_home. Specifies the required directory where the JRE is installed. By default, vCloud Automation Center Application Services installs the JRE in the /opt/vmware-jre directory. You can also set this property to use a custom JRE installation.

  • max_heap. Specifies the maximum heap size of the JVM in which the SQLFire Server runs. The default size value is 1024MB.

  • dataload_file. Specifies the URL to a SQL file that contains the SQL commands for loading initial data to the schema that you set in the schema_file property. This SQL file runs only once when the vFabric SQLFire service is created.

  • schema_file. Specifies the URL to a SQL file that contains the SQL commands for creating a schema such as tables and indices. This SQL file runs only once when the vFabric SQLFire service is created.

  • CentOS 6.4.0 32-bit

  • CentOS 6.4.0 64-bit

  • CentOS 6.3.0 32-bit

  • CentOS 6.3.0 64-bit

SCRIPT

Database Servers

vFabric SQLFire Locator 1.0.3

Installs the server and starts an instance of the service using the values that you defined in the client_port and multicast_port properties

The Auto-Bind feature binds the vFabric SQLFire Server and Locator services to each other when they are added to an application blueprint. The vFabric SQLFire Server service should be on a clustered node, and the vFabric SQLFire Locator service should be on a single node.

The vFabric SQLFire Locator service includes the following properties to customize a service in your application:

  • peer_discovery_port. Specifies the port on which the locator listens for peer discovery, which includes servers and other locators. Default port value is 10101.

  • install_path. Specifies the directory where the vFabric SQLFire locator is installed. The default directory is /opt/vmware/darwin/sqlfire. You can also use this property to designate a different directory.

  • java_home. Specifies the required directory where the JRE is installed. By default,Application Services installs the JRE in the /opt/vmware-jre directory, you can also set this property to use a custom JRE installation.

  • locator_client_port. Specifies the port that the locator listens on. The default port value is 1527.

  • multicast_port. Specifies the port used for multicast communication with other members of the distributed system. The default port value is 12333.

  • CentOS 6.4.0 32-bit

  • CentOS 6.4.0 64-bit

  • CentOS 6.3.0 32-bit

  • CentOS 6.3.0 64-bit

  • RHEL 6.4.0 32-bit

  • RHEL 6.4.0 64-bit

  • RHEL 6.1.0 32-bit

  • RHEL 6.1.0 64-bit

SCRIPT

Database Servers

vFabric Postgres 9.0.4

Installs and configures the service for use.

Set the property allow_connection_ips value to All to allow any host to connect to the database.

Set the property allow_connection_ips value to None to allow only local connections. You can also set an array of IP addresses to selectively allow remote access.

  • CentOS 6.3.0 64-bit

  • CentOS 6.4.0 64-bit

  • RHEL 6.1.0 64-bit

  • RHEL 6.4.0 64-bit

SQL SCRIPT

Database Servers

MySQL 5.0.0

Installs the MySQL server software.

Set the property db_port value to the appropriate port. Application components use the database port value for configuration.

Set the property db_root_password value to the password assigned to the database administrator. The default database administrator password is root.

On Ubuntu, the default server configuration does not allow remote connections for security reasons. To remotely connect to the Ubuntu server, append sed -ie "s/^bind-address/#bind-address/g" $my_cnf_file to the configuration action script. This change to the action script causes the server to bind to all interfaces allowing remote hosts to connect.

On Ubuntu, the db_port property is not supported.

The MySQL service INSTALL scripts use the YUM package management tool and APT-GET packaging tool to install dependencies.

  • CentOS 6.4.0 32-bit

  • CentOS 6.4.0 64-bit

  • CentOS 6.3.0 32-bit

  • CentOS 6.3.0 64-bit

  • Ubuntu 12.04.2 32-bit

SQL SCRIPT

Database Servers

Microsoft SQL Server 2008 Express 1.0.0

The Microsoft SQL Server 2008 Express service installs the Microsoft SQL Server 2008 Express and creates a database instance.

The default SA_PWD property value is SQLserverdb1. If you change the property value, follow the Microsoft SQL Server strong password requirements. The default password is AqOj4V2w@whxuU!.

Windows Server 2008 R2 Enterprise SP1 64-bit

SQL SCRIPT

  • Windows Services

  • Database Servers

Microsoft SQL Server 2012 Enterprise Edition

SQL Server 2012 Enterprise Edition service supports the provision, update, and rollback operations in a Windows node. The provision operation installs SQL Server 2012 Enterprise Edition binary and creates a database instance in the database node.

This edition uses the Flexible Disk Layout feature to put different database files in different storage options to improve the database performance.

This service also lets the user configure the admin password and the basic SQL Server database parameters such as service properties in the provision, update, and rollback operations.

Windows Server 2008 R2 Enterprise SP1 64-bit

SQL SCRIPT

  • Windows Services

  • Database Servers

MongoDB 2.0.1

Installs the MongoDB server and configures the server according to all of the parameters.

By default, if this property is not set, the service binds to all network interfaces on the system. If this property is set, then the service binds only with the IP you provide.

Use the wget tool to download MongoDB installation files. You might have to configure the http_proxy property.

Note:

The Hyperic Agent service does not monitor the MongoDB service.

  • CentOS 6.4.0 32-bit

  • CentOS 6.4.0 64-bit

  • CentOS 6.3.0 32-bit

  • CentOS 6.3.0 64-bit

  • Ubuntu 12.04.2 32-bit

  • RHEL6.1 32 bit

  • RHEL 6.4.0 32-bit

SQL SCRIPT

Database Servers

Oracle11g 11.2.0

Installs and configures Oracle to start and use the server.

The default system administrator password is blank (no password).

The installer requires the installation files to be available on a NFS server. Set the server NFS path in the NFSPATH parameter and make sure the files are available.

For 32-bit installations, download the linux_11gR2_database_1of2.zip and linux_11gR2_database_2of2.zip files from the Oracle Web site.

For 64-bit installations, download the linux.x64_11gR2_database_1of2.zip and linux.x64_11gR2_database_2of2.zip files from the Oracle Web site.

The Oracle11g service INSTALL scripts use the YUM package management tool to install dependencies.

Important:

The logical template with the Oracle11g service must have at least 10GB of hard disk space to successfully deploy the application.

By default, the oracle_base and inventory_location properties values are set to the /disk2 directory.

  • RHEL 6.4.0 32-bit

  • RHEL 6.1.0 32-bit

  • RHEL 6.1.0 64-bit

SQL SCRIPT

Database Servers

Oracle12c 12.1.0

Installs and configures Oracle to start and use the server.

The default system administrator password is blank (no password).

The installer requires the installation files to be available on a NFS server. Set the server NFS path in the NFSPATH parameter and make sure the files are available.

For 64-bit installations, download the linuxamd64_12c_database_1of2.zip and linuxamd64_12c_database_2of2.zip files from the Oracle Web site.

The Oracle12c service INSTALL scripts use the YUM package management tool to install dependencies.

Important:

The logical template with the Oracle12c service must have at least 10GB of hard disk space to successfully deploy the application.

By default, the oracle_base and inventory_location properties values are set to the /disk2 directory.

  • RHEL 6.1.0 64-bit

  • RHEL 6.4.0 64-bit

SQL SCRIPT

Database Servers

Preinstalled MYSQL Server

The Preinstalled MYSQL Server sets the value of db_port to the port to be used. Application components use this value to configure the applications.

Set the db_root_password value to the password for the database administrator.

CentOS 6.3.0 32-bit

SQL SCRIPT

Database Servers

Preinstalled vFabric GemFire Server

The Preinstalled vFabric GemFire Server sets the value of db_root_username to the root user name to be used for the database.

Set the value of max_allowed_packet to the maximum allowed packet size in the server.

Ubuntu 12.4.2 64-bit

SCRIPT

Database Servers

Preinstalled SQL Server 2008 R2 Express

The Preinstalled SQL Server 2008 R2 Express configures a database instance.

Set the SAPWD value to the password for the database administrator.

Windows Server 2008 R2 Enterprise SP1 64-bit

SQL SCRIPT

Database Servers

To deploy predefined sample applications or add predefined tasks to an execution deployment plan, see the Using Application Services documentation.