Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » High availability and read-only scale-out systems

 

SQL Anywhere read-only scale-out

Note

Read-only scale-out requires a separate license. See Separately licensed components.

Read-only scale-out is a configuration that allows you to offload reporting or other operations that require read-only access to the database.

A scale-out tree consists of the root node and copy nodes.

  • The root node of a scale-out system has the only copy of the database that is writable. The root node can be either a single database, or a database mirroring system. Below the root node, there can be one or many branches of copy nodes.

  • A copy node is a database server that runs a copy of a database for read-only access, and a copy node can be the parent of other copy nodes.

Diagram of a read-only scale-out architecture when used with database mirroring.
 See also

How scale-out works
Read-only scale-out in a database mirroring system
SQL Anywhere web services high availability and scale-out solutions
Connecting to a database in a read-only scale-out system
Read-only scale-out set-up
Maintaining a read-only scale-out system
Tutorial: Creating a read-only scale-out system
Tutorial: Using one server as both a copy node and an arbiter
Tutorial: Converting a partner server to a copy node
Tutorial: Adding a mirroring system to a read-only scale-out system