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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Maintaining your database

 

SQL Anywhere read-only scale-out

Separately licensed component required

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.
 How scale-out works
 Connecting to a database in a scale-out system

Tutorial: Setting up a read-only scale-out system
Setting up read-only scale-out
Adding copy nodes
Handling the loss of a parent connection
Connecting to copy nodes
Dropping servers from a scale-out system
Using read-only scale-out with database mirroring
SQL Anywhere web services high availability and scale-out solutions