Ask the Expert

Sybase/Solaris master with Sybase/Linux replicas for production environment

Can a Sybase/Solaris master combined with a farm of Sybase/Linux read-only replicas be made a serious production-worthy environment?

Our current environment has a Sybase/Solaris master and Solaris warm backup. We use the warm backup to handle all our read-only activity, which is 90% of the traffic. When replication fails, we can switch reads to the master while a dump and load to the backup is completed. No downtime.

With a Linux cluster of replicas, a replication server failure would not appear to allow us to dump and load to the replicas while the master continues to accept writes. Is this a workable scenario? Would another model work?


Requires Free Membership to View

Before deploying Linux you have to appreciate that at this moment in time there is no heterogeneous dump and load facility from Solaris to Linux. This facility (i.e. the ability to dump a Sybase database on Solaris and load it into Linux) is expected to be available in Q1 2005.

So if you have you production running on Sybase/Solaris, you need to reverse engineer your database and populate it with the current production data. More often than not this will be a weekend work. You can obviously set this one up by selecting tables in stages and use Sybase replication server to keep databases in sync thereafter. If your replicate database on Linux gets out of sync with the production on Solaris, you have a number of options.

  1. If the failure has affected a limited number of tables, you can easily BCP out data from the production and BCP in data to the replicate database on Linux.
  2. You can use the Sybase utility autocorrect for each table to replace an update with a delete followed with an insert. This will only work if you have not used "reoplicate minimal columns" in your replication definitions.
  3. If a large number of tables affected you may have to go through the process of BCPing out all tables and BCPing them again. This is not ideal.
My suggestion is unless your replicated database is small, you should wait until the heterogeneous dump and load from Sybase becomes available and you can easily maintain your replicate databases on different platforms.

For More Information


This was first published in July 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: