Oracle Cloud Infrastructure Documentation

DB System Endpoints

A DB system endpoint allows client applications to connect to the database to access the data. There are different types of endpoints: primary endpoint, read endpoint, read replica endpoint, and read replica load balancer endpoint.

An endpoint has an IP address, a database port, an X protocol port, and optionally a hostname label.

Primary Endpoint

Each standalone or high availability DB system has a primary endpoint. The primary endpoint allows client applications to connect to the DB system to perform read and write operations on the data stored in the DB system.

Read Endpoint

A read endpoint is optional and can be created on a standalone or high availability DB system with or without read replica. The DB system must have at least 4 OCPUs or 8 ECPUs. When a client application connects to the read endpoint, the connection is forwarded to:
  • An active read replica of the DB system that has not been excluded, if any, or
    Note

    You can provide a list of IP addresses of current or future read replicas to be excluded as backends.
  • The MySQL instance for standalone DB system or the primary instance for high availability DB system if it has no active read replica.
    Note

    This connection allows write operation without error, it does not enforce all operations are read-only.
The read endpoint and read replica load balancer share the same network load balancer, they have the same hostname and IP address values. The read endpoint has the following limitations:
  • Currently the read endpoint supports up to 8 Gbps bandwidth only.
  • When you connect to the read endpoint, you cannot use the client host name or host based access control rules. In this case, the account name must consist of the user name only. See Connection Verification.
  • You cannot configure the read endpoint as a backend server of an Oracle Cloud Infrastructure Network Load Balancer.
  • During outbound replication, you cannot configure the read endpoint as the source; you can configure only the primary endpoint as the source.
  • You cannot create read endpoint on an IPv6 enabled subnet. The DB system and read endpoint must be created on an IPv4-only subnet.

Read Replica Endpoint

Each read replica of a DB system has a read replica endpoint. The read replica endpoint allows client applications to connect to the read replica and read the data stored in the read replica.

Read Replica Load Balancer Endpoint

A read replica load balancer endpoint is created automatically on a DB system when the first read replica is created on the DB system. When a client application connects to the read replica load balancer endpoint, the connection is forwarded to one of the active read replica endpoint of the DB system. If the read endpoint is enabled, the read replica load balancer shares the same network load balancer as the read endpoint and it functions similar to the read endpoint.