The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

I'm looking for options to prevent downtime of SQL Anywhere server, in case of failure of machine server. Is there solution, that will allow us in real time, to switch to different server? I mean, real time databases replication between two machines.

I want two separate environments, so if machine A crash, then we can use machine B with the same state of data which were on machine A. The two machines A and B, will be both running at the same time, both need to have the same databases, real time mirror copies. Users on the desktop will have two shortcuts, one to our application that uses databases on machine A, second that uses databases on machine B. In case of machine A failure, our application will close, and users will be not able to use it anymore. Then they will use second shortcut. In meantime we will recover machine A, and when it's recovered it need to synchronize data to the same state which is actually on machine B.

Please, tell me what are available solutions for SQL Anywhere 9 and 12, databases size between 700MB to 6GB, 40 users connected at the same time.

asked 22 Nov '14, 11:17

BlueMark's gravatar image

BlueMark
24671323
accept rate: 50%


The best that SQL Anywhere 9 has to offer is called "live backup" where a full backup copy of the database file sits on a separate backup machine, and dbbackup.exe runs 24x7 on the backup machine but connected to the running database on the primary machine, to continuously pull transaction log records from the primary machine over to the backup machine where they are appended to the log file sitting on the backup machine. When a failure occurs, dbbackup stops running and you fire up SQL Anywhere 9 on the backup machine, start the full backup copy and apply the backup transaction log. This is called "warm failover" because the startup process can take a while to apply the log. It works quite well, and you can even have two copies; e.g., one in a nearby co-location site and another in a completely different timezone.

SQL Anywhere 12 offers High Availability (see this article) which works like live backup except there is a secondary SQL Anywhere 12 server already running on the backup machine, and the log records are continuously applied to the secondary database so startup is much much faster... "hot failover".

The most important step in the implementation of High Availability is testing. If you are not willing to regularly test failover in the production environment then do not bother to implement it... it will not work when you need it, and the effort will be wasted.

Implementing failover moves SQL Anywhere from the "zero effort" category of database administration into the world of enterprise server setup and administration... in theory it's easy, in practice it's not.

permanent link

answered 23 Nov '14, 07:36

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%

edited 23 Nov '14, 07:45

Where I could find some example, how to configure "live backup" with SQL Anywhere 9? And for what purposes it is Sybase Replication Server?

(23 Nov '14, 15:14) BlueMark
Replies hidden
1

I'd recommend to search within this forum for "live backup" - that will list some questions with discussions on the pros and cons of live backup and the necessary steps to do the "warm failover"...

AFAIK, Sybase Replication Server is a system focussed on the replication of several active (and usually heterogeneous and "big") databases, not primarily used with SQL Anywhere. - Of course a replication system can also be used for "failover" but that's not its main goal, and IMHO it would take much more effort to set up replication than to use a live backup.

(24 Nov '14, 03:55) Volker Barth

It is what Database Mirroring is for.

permanent link

answered 23 Nov '14, 02:55

Dmitri's gravatar image

Dmitri
1.5k41132
accept rate: 11%

For Sybase 12 I absolutely would recommend this solution

(24 Nov '14, 03:45) Martin

Agreed that this is exactly what database mirror is for.

Note that SQLA 10 and up support database mirroring. SQLA 10 and 11 don't have as rich support as SQLA 12 and up, and that a number of improvements and fixes have been made to SQLA 16 and SQLA 12 compared to SQLA 10 and 11. There are also a handful of improvements and fixes that have been made to SQLA 16 that are not available in SQLA 12.

Also note that SQLA 11 and below have no engineering support.

(24 Nov '14, 09:10) 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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×404
×95
×37
×26
×4

question asked: 22 Nov '14, 11:17

question was seen: 911 times

last updated: 24 Nov '14, 09:10