Addendum for Database Setup

In most cases, RTI® Connext™ (formerly RTI Data Distribution Service) does not use or require a database. However, if you want to use some of the durability features of Connext, or to use RTI Real-Time Connect, you need a relational database, such as MySQL. This document describes how to install and configure a database for use with Connext.

❏Durable Writer History—This feature allows a DataWriter to locally persist its history cache so that it can survive shutdowns, crashes and restarts. When an application restarts, each DataWriter that has been configured to have durable writer history automatically loads all the data in its history cache from disk and can carry on sending data as if it had never stopped executing. To the rest of the system, it will appear as if the DataWriter was tem- porarily disconnected from the network and then reappeared.

❏Durable Reader State—This feature allows a DataReader to persists its state and remem- ber which data it has already received. When an application restarts, each DataReader that has been configured to have durable reader state automatically loads its state from disk and can carry on receiving data as if it had never stopped executing. Data that was received by the DataReader before the restart will be suppressed, so it is not sent over the network.

❏RTI Persistence Service—Persistence Service provides reliable data availability. The service saves data from Connext publishing applications in memory or permanent storage, so it can be delivered to subscribing applications that join the system at a later time-even if the publishing application has already terminated. Persistence Service implements the optional Persistence Profile, defined in the OMG's Data Distribution Service for Real- time Systems specification.

In principle, you can use any database that provides an ODBC driver, since ODBC is a standard. How- ever, not all ODBC databases support the same feature set. Therefore, there is no guarantee that the persistent durability features will work with an arbitrary ODBC driver.

Note: At the time of this writing, MySQL is not yet supported on Red Hat® Enterprise Linux® 6 systems.

RTI has tested Persistence Service, Durable Writer History, and Durable Reader State with MySQL 5.1.44 with MySQL ODBC 5.1.6.

Note: The usage of MySQL requires the separate installation of the MySQL ODBC 5.1.6 (or higher) driver. For non-Windows platforms, the installation of UnixODBC 2.2.12 (or higher) is also required.

1

To use MySQL as the database, you will need all of the following:

❏ MySQL 5.1.44 or higher

The installation of MySQL is beyond the scope of this document. Please refer to the MySQL Reference Manual for the process to install and configure MySQL.

❏ MySQL ODBC 5.1.6 driver or higher

The driver is not bundled with the MySQL server and must be installed separately.

The ODBC connector can be downloaded from:

http://dev.mysql.com/downloads/connector/odbc/5.1.html

The installation guide can be found here: http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-installation.html

❏ UnixODBC 2.2.12 or higher

The MySQL ODBC driver requires an ODBC driver manager. We recommend using UnixODBC, a complete, free and open ODBC solution for Linux systems. The driver manager can be downloaded from http://www.unixodbc.org.

1 Creating a Data Source for MySQL on a Linux System

Connext uses the MySQL ODBC driver to access data sources.

The connection information for each data source is stored in an ODBC INI file. This can be a file called .odbc.ini in the user’s home directory, or it can be configured using the environment vari- able ODBCINI. The stored information describes each data source in detail, specifying the driver name, a description, and any additional information the driver needs to connect to the data source.

To create the ".odbc.ini" file with a DSN named "Example", follow these steps:

1.Create a new text file named ".odbc.ini" in your home directory.

2.Insert these lines in the file:

[ODBC Data Source]

Example=MySQL Driver [Example] DRIVER=/usr/lib/libmyodbc5.so Database=test

NOTE: Make sure that DRIVER points to the valid location of the MySQL ODBC driver on you system.

2 Creating a Data Source for MySQL on a Windows System

Connext uses the MySQL ODBC driver to access data sources.

The connection information for each data source is stored in the Windows registry. The stored information describes each data source in detail, specifying the driver name, a description, and any additional information the driver needs to connect to the data source.

To add a data source named "Example", follow these steps:

1.Open the ODBC Data Source Administrator:

•On Windows 2000 systems: choose Start, Control Panel, Performance and Main- tenance, Administrative Tools, Data Sources (ODBC).

2

Creating a Data Source for MySQL on a Windows System

•On Windows XP systems: choose Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC).

2.Select the System DSN tab.

3.Click Add; the Create New Data Source dialog appears.

4.Select the MySQL driver from the list of drivers.

5.Click Finish; the MySQL ODBC Driver Configuration dialog appears.

6.Fill out the fields in the dialog.

a.Enter "Example" as the Data Source Name (DSN).

b.Enter a valid username and password.

c.Select a database (for example, "test"). All other fields can be left empty.

d.Click OK.

3