active / active servers with databases - pros and cons

hi

BACKGROUND
==========
I have a production environment for a service running oracle on a sun
server and this has a backup server in standby mode using oracle 10g
dataguad. This standby server can also be used for read only reporting
at the same time.

MOVING FORWARD
==============
I have a development, test and training environment consisting of
separate database instances on a separate machine.

I'm trying to work out the pro's and con's of having the production /
standby environment in an active/active set up and moving the
dev/test/training database onto the standby server as well. At failover
time the dev/test/training environment would failover onto the old
primary.

PROS
====
1. cost - less servers to manage and buy / have support for
2. more manageable - one server to manage

CONS
====
1. possibility of developers accidentally connecting to the production
environment
2. cant tune the production environment 100% for the live app as server
will have to be tuned for the other dev/test/training instances as well
e.g. with memory allocation etc.
3. at failover time old primary server may be unavailable for
dev/test/training to failover onto - production performance could be
affected with the dev/test/training use. developers experience
performance probs, cant do what they want to then ask why
dev/test/training doesn't have its own environment/server.

Question
========
Does anyone have any experience of this and can they recommend some
pro's and con's?

Many thanks.

Thiko!

.

Relevant Pages

  • Re: active / active servers with databases - pros and cons
    ... I have a production environment for a service running oracle on a sun ... server and this has a backup server in standby mode using oracle 10g ... dev/test/training database onto the standby server as well. ...
    (comp.databases.oracle.server)
  • Re: active / active servers with databases - pros and cons
    ... I have a production environment for a service running oracle on a sun ... server and this has a backup server in standby mode using oracle 10g ... dev/test/training database onto the standby server as well. ...
    (comp.databases.oracle.server)
  • Re: Isolated member server wont authenicate with Isolated DC
    ... A GC is really only needed in a Native Mode AD environment. ... production DC out of production and put it in an isolated test environment ... >> FSMO roles on it and is not a global catalog server. ... >> back into a test lab to duplicate. ...
    (microsoft.public.win2000.active_directory)
  • Re: SetNet32 information updated when using connection string.
    ... connection is made setnet32 has been changed to use that hostname ... Our environment is such our production and test servers have the same ... You should NEVER have two server instances ...
    (comp.databases.informix)
  • Re: Two Sharepoint phsical servers synced using SQL log shhipping
    ... I have used log shipping successfully to implement a hot standby ... This could be a medium server farm (2 Web Servers in an NLB ... customer needed to have a standby environment up in running within ... replicating data from the standby database server to the production ...
    (microsoft.public.sharepoint.portalserver)
Loading