Install the Domain Orchestrator › Prerequisites to Installing the Domain Orchestrator › Database Prerequisites › Prepare a MySQL Database for CA Process Automation

Prepare a MySQL Database for CA Process Automation

During installation of the Domain Orchestrator or an additional Orchestrator, the installer creates one or more databases. The databases are created in the specified MySQL database instances to house the CA Process Automation data stores. The installer requires the following prerequisites:

• The availability of MySQL JDBC driver version 5.1.7 or above.

  Note: This driver is not included in the CA Process Automation installation media.

• User credentials with Administrative privileges to create one or more databases for the Library, Reporting, and Runtime data stores.
• Two MySQL variables that are customized for CA Process Automation.

Before you install an Orchestrator that uses a MySQL database for CA Process Automation data stores, prepare the MySQL database.

Follow these steps:

1. Download the JDBC driver from the MySQL website. For example, get the MySQL Connector/J 5.1.7.
2. Save the driver to a location that you can browse to during installation.
3. Open the MySQL Workbench and select the Options File under Configuration.
4. Set the variable for the time a transaction waits for a lock before being rolled back:
   1. Select the InnoDB tab.
   2. Scroll to the Various group.
   3. Select innodb_lock_wait_timeout.
   4. Change the value from the default, 50, to a value greater than 60.

      innodb_lock_wait_timeout = 90 
      

5. Set the maximum packet length to 33554432 Bytes (32 MB) to send to the server and receive from the server. The default is 1048576.
   1. Select the Networking tab.
   2. Locate the Data / Memory size group.
   3. Select max_allowed_packet.
   4. Enter the required value.
6. Click Apply.

   A confirmation of the changes to apply to the MySQL Configuration File appears.