Author |
Topic |
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-03 : 05:37:14
|
resolved |
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-04-03 : 09:31:51
|
What is the size of database(s)? What transaction /sec or batch request/sec are expected? Both technologies have their own ups and downs so weigh both options and see which one outperforms other. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-03 : 10:15:49
|
resolved |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-03 : 11:22:22
|
Active/Active clusters require shared storage of sometype. You may be able to use replication or possibly Log shipping. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-06 : 04:32:52
|
resolved |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-06 : 12:38:55
|
Not to discourage you,http://msdn.microsoft.com/en-us/library/ms190202.aspxis pretty thorough for SQL.Active / Active is specifically a Cluster term. I know for a fact you cannot use a cluster w/o shared storage. You may be able to emulate shared storage with software or in a virtual environment, but performance would decrease in that case.There are several othe ways to have 2 active sql nodes with identical data. I looked into using database mirroring. But as we generate dozens of new applications and databases a week it would be unrealisitic in terms of recoding old work.Is the active / active requirement based on performance or reliability. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-07 : 04:35:42
|
resolved |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-07 : 14:17:38
|
I use NTLBS for my IIS, I really like the way it works.It will provided HARDWARE failover (is crashed server)I really only see DB Mirroring as an option w/o the shared storage. If you need the CPU resources of both machines, you could setup two instances, A Principal / Mirror B Mirror / PrincipalSomeone who has implimented mirroring would have to confirm if there would be any performance advantage to that. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-08 : 04:15:52
|
resolved |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-21 : 05:26:53
|
Thanks for not letting other users benefits from same help as you got.quote: 04/03/2009 : 05:37:14 I've been asked to set up a new configuration which is far from ideal. Two new fairly high spec servers with windows server 2008 and SQL Server 2008. Here is requirement:1. high availability / redundancy without purchasing a SAN. 2. utilise one of the servers as a test machine - so Active/Active needed if clustering used.3.SQL Server and IIS on same machine so webpages connect to DB's using (local). - this requirement I hope to get dropped but I throw it in for now.Is clustering an option or is mirroring a preferred route?
quote: 04/03/2009 : 10:15:49 mdf file sizes: largest 10GB and growing by about 2GB every month, and another 8 db's fairly constant under 250MB. All have fairly low transaction /sec with a maximum of about 3000 per sec per db, but usually much lower.My main question - is it veasable to have Active / Active clustering without a SAN?
quote: 04/06/2009 : 04:32:52 Tripodal - thanks for the reply. I know it's normal practice but I've found a few references to Active/Active being possible without shared storage in sql server 2008. But I really need a little more details as to how it's done and what are the pros and cons.http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_24083832.html
quote: 04/07/2009 : 04:35:42 Tripodal - cheers for that. The main reason for Active/Active is to give access to the second node's resources - it's harddisk space and it's processor power. Eg. as a test machine, or to have one node as main IIS / application server and one node as main db server, also - possibility of running reporting services from a seperate node - but with the possibility of either node carrying out all duties if a single node goes down.Can you confirm these are my options?1. Active/Active Cluster with additional shared storage - second node's resources become available2. Active/Passive Cluster with no additional shared storage - second node's resources not available3. Mirroring with no additional shared storage - each server is standalone so it's resources available but no automatic failover
E 12°55'05.63"N 56°04'39.26" |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-21 : 11:28:00
|
Peso - I deleted my comments not Tripodal's help. I have a reason why I wanted to remove my question which I would rather not have to justify. I would appreciate it if you can delete the post you got from google cache. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-21 : 11:33:21
|
Other users can't benefit from Tripodals answers if they don't know the questions.If you want private help, pay a consultant.This forum has help provided for free, from people sharing their knowledge and time for nothing.Also, there is nothing specific in your questions revealing anything about you or your company. E 12°55'05.63"N 56°04'39.26" |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-21 : 11:45:10
|
I know I haven't contributed to the same extent to this forum as yourself and others but I also give time to try to help users of the site. I don't think its fair to imply that I only want to help myself. The is the only time I have deleted a question. Tripodal helped me and I thanked him - I don't see what it has to do with you. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-21 : 11:54:44
|
You can have a chat with moderators or site operator.If they decide to, they can edit my post. E 12°55'05.63"N 56°04'39.26" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-04-21 : 12:03:39
|
no the post won't be removed. there's no point to it anyway since it's already stored in google cache.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-21 : 12:10:54
|
I agree with keeping it. How would you feel if someone with your exact same problem posted it earlier, but removed all the details that would have helped you solve it immediately?If you really can't let this information be on a public forum, don't post it in the first place. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-22 : 04:38:12
|
Firstly Google cache is temporary - google says it is refreshed usually around every 3 days, secondly not every user knows about Google cache. Most importantly - according to this site's FAQ"Editing Your Posts You may edit or delete your own posts at any time. Just go to the topic where the post to be edited or deleted is located and you will see a edit or delete icon .... No one else can edit your post, except for the forum Moderator or the forum Administrator."One rule for average user another for "Super-user" Peso?Who has ownership of my words, Peso or me? For instance if one user of this site decides to copy all of Peso's answers and make a book of them - would Peso object? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-22 : 04:40:12
|
Only if they don't atttribute the code to me.For those who want to read more about my code and algorithms, here is my bloghttp://weblogs.sqlteam.com/peterl/ E 12°55'05.63"N 56°04'39.26" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-22 : 04:42:17
|
quote: Originally posted by darkdusky Firstly Google cache is temporary - google says it is refreshed usually around every 3 days, secondly not every user knows about Google cache.
Well, I found your text 18 days after original post.I think Google caches text for 6 months. E 12°55'05.63"N 56°04'39.26" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-04-22 : 04:44:34
|
acctually the words are public domain. if a user decides to reply quoting your post then it's considered his post.if it were a book that would be sold that would be questionable. if it were free he'd have no basis for objection.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
Previous Page&nsp;
Next Page
|