Skip to Content
0

Sybase database migration from one datacenter to another datacenter

Mar 01 at 04:43 PM

68

avatar image
Former Member

Hi All,

i am planning to migrate database from one datacenter to another datacenter.

In the current envirnoment we have few few sybase ASE 15.7 Sp 138 mostly, currently we dont have any MSA replication setup in the current environment only warm standby and table level replication is there,

Since migration plan is like to setup MSA replication from old datacenter to new datacenter than failover it to new datacenter.

i will really appreciate if somebody can write up bullet points about.

amount of complexity to configure it in a running production environment, issues and risks including any additional licensing challenges.

thanks in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Mar 01 at 09:09 PM
0

Not sure that I understand your question correctly:

Do you mean to say that you have one datacenter (let's call it datacenterA) and another datacenter (datacenterB) and you want to migrate all the ASE instances from datacenterA to datacenterB?

You mention that you currently have warmstandby and table replication. Is that warmstandby replication between ASE servers located entirely in datacenterA only? or between datacenterA and datacenterB?

If you are going to migrate, my first recommendation would be warmstandby because it offers the possibility of creating replication paths from A to B, but if something goes wrong during or after your migration to B and you need to go back to A, you just switch the logical connection and this changes the direction of the replication. MSA cannot do that, it is a one-way replication mechanism.

If you set up MSA replication from A to B and switch your users to B, only to find out that there are problems that require you to go back to A, then with MSA you would need to re-create the paths all over again in the opposite direction.

Additionally, If you already use warmstandby replication, say from ASE sever 1 to ASE server 2, and want to migrate that data to ASE server 3, you can set up MSA replication to ASE Server 3 that will work from the logical warmstandby connection between ASE server1 and ASE sever2.

Regards,

Share
10 |10000 characters needed characters left characters exceeded
Ben Slade Apr 10 at 07:46 PM
0

I don't think MSA replication (aka whole database replication via subscription) will do what you want here.

It's *not* warm standby replication. There's no logical connection and no concept of "switch active" (switch replication direction).

I'm guessing you want to keep warm standby replication active in the old data center while you migrate to the new. If so, you could try setting up MSA replication to the new datacenter, disabling user access to the databases at the primary/standby/MSA replicate (so you can guarantee no data changes) then dropping replication and re-setting it up without materialization for the replicates.

Share
10 |10000 characters needed characters left characters exceeded