Start the SQL Anywhere Monitor.
Start the Monitor Developer Edition (Windows) Click Start » Programs » SQL Anywhere 12 » Administration Tools » SQL Anywhere Monitor.
Start the Monitor Developer Edition (Linux) Run the samonitor.sh script from the bin32 or bin64 directory in the Monitor installation directory:
Log in to the Monitor as the default administrator user.
In the User Name field, type admin, and in the Password field, type admin.
Add the database mirroring system to the Monitor's Resource List.
Click Tools » Administration, which is located on the left sidebar.
Click Resources, and then click Add.
Click SQL Anywhere Server, and then click Next.
In the Name field, type mirrorsystemdemo, 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, in the DBA User ID field, type DBA, and in the Password field, type sql. Click OK.
When you add a database as a resource to be monitored, you must supply the DBA user ID and password for the database. These credentials are used to:
Connect to the database.
Create a new user named sa_monitor_user. The Monitor uses the sa_monitor_user to connect to the database and monitor it.
Install the database objects needed by the sa_monitor_user to monitor the database. For a list of the objects that are installed, see List of database objects installed by the Monitor.
Discard the DBA credentials from the Monitor. Because the sa_monitor_user is added to the database being monitored, it is not necessary to store the DBA credentials anywhere outside the database that is being monitored. See List of database objects installed by the Monitor.
The resource is added and monitoring of the resource starts automatically.
Click Dashboards » Overview.
The mirrorsystemdemo resource appears in the Resource List.
Click mirrorsystemdemo to open the mirrorsystemdemo dashboard and view the collected metrics.
In the top right corner of the mirrorsystemdemo dashboard, click Customize » Add Widget » SQL Anywhere Scale-Out Topology.
In the What Do You Want To Name This Widget? field, type mirrorsystemwidget.
In the Which Resource Are You Interested In? field, click mirrorsystemdemo.
The new widget appears in the dashboard:
The topology widget displays the following columns and their possible values:
Server Name Displays the names of the database servers in the mirroring system.
Type Lists the servers' roles 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 Displays the connection status of each server.
Connections Shows the number of current connections to the server.
Last Updated Displays the last time the server status was updated.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|