Use the Monitor to monitor a database mirroring system.
This tutorial assumes that you have a running read-only scale-out system as described in Tutorial: Creating a database mirroring 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.
Add a database mirroring system to the Monitor's Resource List.
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 mirror_demo, and then click Next.
In the Host field, specify the host names and port numbers of the computers running the primary and mirror servers in a comma separated list. That is, type localhost:6871, localhost:6872.
In the Server field, specify the alternate server name for the primary server. That is, type mirror_demo_primary.
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 mirror_demo.
In the top right corner of the mirrorsystemdemo 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 mirror_demowidget.
In the Which Resource Are You Interested In? field, select mirror_demo.
The new widget appears in the dashboard:
Server Name Displays the names of the database servers in the mirroring system.
Type Lists the server type and displays one of the following values:
Partner - Primary This value identifies the server that is currently acting as the primary.
Partner - Mirror This value identifies the server that is currently acting as the mirror.
Arbiter This value identifies the arbiter server.
State This value displays the connection status of each server.
Connections This value shows the number of current connections to the server.
Last Updated This value displays the last time the server status was updated.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|