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
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.
answered 31 Dec '13, 11:35