Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Experiment in High Availability


Experiment in High Availability

Author
Message
C.K.Shaiju
C.K.Shaiju
SSC Veteran
SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)

Group: General Forum Members
Points: 214 Visits: 707
Hi All,

Would like to get some hands-on with the high availability options (Log-shipping, Replication, Database-Mirroring and Server Clustering).

Can I do experiment on these in my personal computer?

_____________________________________________
One ounce of practice is more important than tonnes of dreams
Dhananjay-440114
Dhananjay-440114
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 307
Yes, Why not. Create 2-3 instances of SQL Server and get started... or the other way is install Virtual machine on uor box and get started.
C.K.Shaiju
C.K.Shaiju
SSC Veteran
SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)

Group: General Forum Members
Points: 214 Visits: 707
Yes, Why not. Create 2-3 instances of SQL Server and get started... or the other way is install Virtual machine on uor box and get started.


Thanks, have read that clustering and mirroring required new addition of hardware and software, also those are costly. As I am more into development did not get chance to install and do anything in hardware and software installation unless sql installed at home.

That's why the topic posted. BTW, Thanks.

If you had already come through any good links, Please share.

_____________________________________________
One ounce of practice is more important than tonnes of dreams
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47261 Visits: 44392
C.K.Shaiju (9/21/2013)
[quote]Thanks, have read that clustering and mirroring required new addition of hardware and software


Virtual machines. No additional hardware necessary.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


C.K.Shaiju
C.K.Shaiju
SSC Veteran
SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)

Group: General Forum Members
Points: 214 Visits: 707
Virtual machines. No additional hardware necessary.


Thanks Gail

_____________________________________________
One ounce of practice is more important than tonnes of dreams
Dhananjay-440114
Dhananjay-440114
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 307
Even for clustering you can do some hands on but you need to search on goole for available VM.. Without any investment..:-)
C.K.Shaiju
C.K.Shaiju
SSC Veteran
SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)

Group: General Forum Members
Points: 214 Visits: 707
Dhananjay-440114 (9/24/2013)
Even for clustering you can do some hands on but you need to search on goole for available VM.. Without any investment..:-)


Thanks Dhananjay. Let me search. Smile

_____________________________________________
One ounce of practice is more important than tonnes of dreams
dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)

Group: General Forum Members
Points: 643 Visits: 1958
I have gotten mirroring to work between a SQL instance on a Server 2008 VM and a SQL Evaluation instance on the Host Windows 7 machine with 4GB installed, but performance was frustrating at times, especialy if IE was open. If you have more than 4GB or a second machine you can install SQL on, you'll be in better shape.

For a failover cluster, you'll need at least 3 VMs, a domain controller and 2 nodes, and a tutorial on how to set up shared drives in this kind of envronment (if anyone has a favorite link for this, please post it as I'd like to do this). For 3 VMs you'll want a PC with at least 8GB of RAM , or a second PC (you can put the DC there).

Another option might be to use Wondows 2003 SP2 VMs, which can probably run satisfactorly on less RAM.
C.K.Shaiju
C.K.Shaiju
SSC Veteran
SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)SSC Veteran (214 reputation)

Group: General Forum Members
Points: 214 Visits: 707
dan-572483 (10/2/2013)
I have gotten mirroring to work between a SQL instance on a Server 2008 VM and a SQL Evaluation instance on the Host Windows 7 machine with 4GB installed, but performance was frustrating at times, especialy if IE was open. If you have more than 4GB or a second machine you can install SQL on, you'll be in better shape.

For a failover cluster, you'll need at least 3 VMs, a domain controller and 2 nodes, and a tutorial on how to set up shared drives in this kind of envronment (if anyone has a favorite link for this, please post it as I'd like to do this). For 3 VMs you'll want a PC with at least 8GB of RAM , or a second PC (you can put the DC there).

Another option might be to use Wondows 2003 SP2 VMs, which can probably run satisfactorly on less RAM.


Thanks for sharing.
I didn't get any white papers, but got a youtube link (http://www.youtube.com/watch?v=1ZCCOcWUuOg). This link is the 1st part of a series of 27 videos.

_____________________________________________
One ounce of practice is more important than tonnes of dreams
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