Compatibility Configuration

The Halo database supports three compatibility modes: Oracle, MySQL, and PostgreSQL. These include:

• Oracle mode: via cluster_net_services or database_compat_mode
• MySQL mode: via cluster_net_services or database_compat_mode + second_listener_on
• PostgreSQL mode: no additional configuration required; Halo natively supports the PostgreSQL protocol and syntax

Using the cluster_net_services parameter, multiple modes can run simultaneously within the same instance.

This chapter describes how to enable and configure each compatibility mode:

• Enabling Oracle mode
• Enabling MySQL mode
• Running multiple modes simultaneously