Running Multiple Databases with SQL Anywhere 10 Database Mirroring

nikefever

After starting Server 2, the Server 1 Server Messages window shows that Server1 is the primary server in the mirroring system for databases one, two, and three. The messages also indicate that the mirror databases for one, two, and three (partners) are connected to Server1.

nikefever

The Arbiter messages show that both Server1 and Server2 are connected.

nikefever

Connect to database one in the mirroring system via Interactive SQL by running the following command in a command prompt:
dbisql -c “UID=DBA;PWD=sql;ENG=mirrordemo_one;LINKS=TCPIP”
Connect to database two in the mirroring system via Interactive SQL by running the following command in a command prompt:
dbisql -c “UID=DBA;PWD=sql;ENG=mirrordemo_two;LINKS=TCPIP”
Connect to database three in the mirroring system via Interactive SQL by running the following command in a command prompt:
dbisql -c “UID=DBA;PWD=sql;ENG=mirrordemo_three;LINKS=TCPIP”


Summary
Database mirroring offers several benefits, such as no data loss during failover and fast failover for committed transactions, and requires no special hardware or software. As a result, this implementation can be simple and very cost effective. There are some restrictions that apply to the database in a database mirroring system. To gain a full understanding of the benefits and technical aspects of database mirroring, see the following topic in the SQL Anywhere 10 documentation:


SQL Anywhere® Server - Database Administration
SQL Anywhere High Availability
Understanding database mirroring


This topic is also available online at
http://www.ianywhere.com/develop ... oring-overview.html .
NEWS & EVENTS
Sybase iAnywhere Brings Natural Language Interfaces To Telematics And Embedded Devices (May 22, 2007)

Sybase Presents 2007 Global Annual Partner of the Year Awards (May 17, 2007)