Start a SQL Anywhere database that is the root node in a read-only scale-out system and then add this database as a resource to be monitored from SQL Anywhere Monitor.
This tutorial assumes that you have a running read-only scale-out system as described in Tutorial: Creating a read-only scale-out system.
This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Monitoring resources with the Monitor.
Start the SQL Anywhere Monitor. Click Start » Programs » SQL Anywhere 16 » Administration Tools » SQL Anywhere Monitor.
Log in to the Monitor as the default administrator user:
In the User Name field, type admin.
In the Password field, type admin.
Add scaleoutdemo.db as a resource to the Monitor:
In the Tools sidebar, click Administration.
Click Resources, and then click Add.
Click SQL Anywhere Server, and then click Next.
In the Name field, type scaleoutdemo, and then click Next.
In the Host field, type localhost.
In the Server field, type scaleout_root_demo.
When you are prompted for the required authorization, type DBA in the User ID field and sql in the Password field. Click OK.
The resource is added and monitoring of the resource starts automatically.
Click Close twice.
Add a widget to monitor scaleoutdemo.db:
In the Dashboard sidebar click scaleoutdemo.
In the top right corner of the scaleoutdemo dashboard, click Customize » Add Widget.
Select SQL Anywhere Scale-Out Topology and click Next.
In the What do you want to name this widget field, type scaleoutwidget.
In the Which resource are you interested in field, click scaleoutdemo.
The new widget appears in the dashboard:
The topology widget displays the following columns and their possible values:
Server Name The name of the node in the scale-out system.
Type The database server's role. The type is either Partner - Primary or Copy, depending on how the server was defined when the read-only scale-out system was created.
State The connection status of the node. Can be either Connected or Disconnected.
Connections The current number of connections to this node.
Last Updated The last time the database server updated its status.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|