SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Should development environment be close or exact to production?


Should development environment be close or exact to production?

Author
Message
greg.celentano
greg.celentano
SSC-Enthusiastic
SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)

Group: General Forum Members
Points: 110 Visits: 371
If you have production environment that is a fail over cluster is it a best practice to have your development environment be the same configuration for testing reasons? I would think so, but can't really find many definite answers on the the web.
SQLSACT
SQLSACT
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5160 Visits: 2969
It depends on how available you need your dev system to be. What is your SLA for dev systems?
Failover clustering provides instance level availability, not database availability
greg.celentano
greg.celentano
SSC-Enthusiastic
SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)

Group: General Forum Members
Points: 110 Visits: 371
What if the DB mirroring is involved on the production box?
SQLSACT
SQLSACT
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5160 Visits: 2969
Then your production database has high availability. It depends on business requirements. There is no best practice for how close Dev needs to be to Production.
greg.celentano
greg.celentano
SSC-Enthusiastic
SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)

Group: General Forum Members
Points: 110 Visits: 371
Sounds good, thanks for the help
Steve Jones
Steve Jones
SSC Guru
SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)

Group: Administrators
Points: 150045 Visits: 19449
i'd say that you should definitely have a clustered environment in dev for the admins, so they can test changes or deployments and understand the impacts to production. It doesn't have to be an environment that's used all the time, but you should have one available.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Voide
Voide
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 280
Assuming you have a DR (damage recovery) site and some sort of backup that runs nightly (RedGate for instance) then it's not 100% required to have your Devl environment equal to Prod.

Delving deeper into your question-- How large is your infrastructure ? Do you ONLY have a Devl and Prod environment ?

I run the following instances: Prod, Devl, Test, DR.


Application testing is done in test.
Devl is equal to Prod and has development done on it before moving it to Prod.
Prod is self explanatory.
DR matches Prod nightly.
sql-lover
sql-lover
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4665 Visits: 1930
Not a requirement, but ideal.

In terms of permissions and schema changes, any non Clustered environment should do the trick, as long as you exactly recreate the same permissions you have on Pro on Dev (database and instance level).

Having said that, a Clustered environment is clearly different than a regular SQL instance. Patching, for example, is different. And taking the SQL instance down to test DR scenarios and coordinate with developer(s) will also be different.

I personally have a small VMware Cluster (running on an SSD external drive) where I test simple things. It is virtually impossible for me to accommodate all my user databases there but I can test simple things like adding or removing disks prior implementing on Pro. Same goes for patches.
PretendDBA
PretendDBA
SSC-Addicted
SSC-Addicted (496 reputation)SSC-Addicted (496 reputation)SSC-Addicted (496 reputation)SSC-Addicted (496 reputation)SSC-Addicted (496 reputation)SSC-Addicted (496 reputation)SSC-Addicted (496 reputation)SSC-Addicted (496 reputation)

Group: General Forum Members
Points: 496 Visits: 503
I find with clusters it's nice to have a cluster to play around in so you can test and understand changes better.

We run a Active/Passive 2 node Windows 2008 R2 with SQL 2008 R2 cluster.

Recently i purchased a "cheap" HP DL160G8 with just 2 x 6 core CPUs 32gb of ram and 6 x 600GB 10k 2.5inch drives. I installed Windows 2012 Std installed the hyper-v and windows storage server roles into the host OS. Then i just created 2 Windows 2008 R2 guests, Created some ISCSI LUNS on the host OS created a private network between the host and the guests and presented these disks as the "SAN". Created a private network between the two Guests for cluster traffic and then gave them access to the real network.

Built the cluster and installed SQL 2008 R2, seems to work great for testing and learning. The performance actually isn't toooooooo bad either. All 6 disks are just in one large raid 5 LUN but it's only used for testing how the cluster responds to changes etc so yeah.
durai nagarajan
durai nagarajan
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3591 Visits: 2784
greg.celentano (7/3/2013)
If you have production environment that is a fail over cluster is it a best practice to have your development environment be the same configuration for testing reasons? I would think so, but can't really find many definite answers on the the web.


Some DBA team doesnt support development or QA(test) environments , in case DBA team supports these environments as well then all prod checklist will have to be followed. hope people will agree to it.

Regards
Durai Nagarajan
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search