BH Hi, What are the benefits of the new way of mirroring vs. the old way. I've been informed that the new way is recommended, but I still don't understand exactly, why? (e.g. -xp (partner... VS. -xp on)

Thank you so much Aron

asked 30 Dec '13, 17:54

arony's gravatar image

accept rate: 0%

It's a simple explanation: the old way requires you to shut down servers in order to change the high availability configuration / topography.

This is undesirable for a 24x7 operation situation - it's much better to be able to dynamically issue a SQL statement (from any client!) and have the server do 'the right thing' underneath the covers to reconfigure the mirror and copy nodes.

Note that in SQL Anywhere 16, there are a number of enhancements to dynamically 'convert' high-availability and copy nodes without taking the database servers offline - see the SQL Anywhere 16.0 new features section in the documentation for more details.

permanent link

answered 31 Dec '13, 11:35

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 24%


The other reasons that the new way was added were:

1) so that mirroring could also support read-only scale-out

2) so that the majority of the high availablitity/read-only scale-out configuration is stored in the database instead of spread over three or more command lines.

(02 Jan '14, 11:05) Ian McHardy
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 30 Dec '13, 17:54

question was seen: 466 times

last updated: 02 Jan '14, 11:05