Lesson 3: Monitoring a database mirroring system

 Add a database mirroring system resource to the Monitor

  1. 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: 
      samonitor.sh launch

  2. Log in to the Monitor as the default administrator user.

    • In the User Name field, type admin, and in the Password field, type admin.

  3. Add the database mirroring system to the Monitor's Resource List.

    1. Click Tools » Administration, which is located on the left sidebar.

    2. Click Resources, and then click Add.

    3. Click SQL Anywhere Server, and then click Next.

    4. In the Name field, type mirrorsystemdemo, and then click Next.

    5. 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.

    6. In the Server field, specify the alternate server name for the primary server. That is, type mirror_demo_primary.

    7. Click Create.

  4. 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.

  5. Click Close.

  6. Click Close.

  7. Click Dashboards » Overview.

    The mirrorsystemdemo resource appears in the Resource List.

  8. Click mirrorsystemdemo to open the mirrorsystemdemo dashboard and view the collected metrics.

 Add a SQL Anywhere Scale-Out Topology widget

  1. In the top right corner of the mirrorsystemdemo dashboard, click Customize » Add Widget » SQL Anywhere Scale-Out Topology.

  2. Click Next.

  3. In the What Do You Want To Name This Widget? field, type mirrorsystemwidget.

  4. In the Which Resource Are You Interested In? field, click mirrorsystemdemo.

  5. Click Create.

The new widget appears in the dashboard:

SQL Anywhere Scale-Out Topology widget for a database mirroring system.

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.

Proceed to Lesson 4: Logging out of the Monitor and shutting down your database mirroring system.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1