| Author |
Topic |
|
fredong
Yak Posting Veteran
80 Posts |
 Posted - 2005-02-15 : 10:23:13
|
| I am new to Data warehousing and I planned to cluster my data from my production server to the new Datawarehouse server and have the users run their web crystal reports pointing to new Datawarehouse server. The reason I am doing this is because users need to get a real-time data and I do not want to bog down the production server. Does this plan sounds feasible? If not please advise. Thanks.k |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-02-15 : 11:36:41
|
| I'm not sure what you mean?Datawarehouses are not typically realtime because the ETL and Cube processing is pretty resource intensive. What did you mean by "Cluster" I would suggest something like replication, or logshipping to create your reporting server.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
fredong
Yak Posting Veteran
80 Posts |
Posted - 2005-02-15 : 13:29:45
|
| You heard of the clustering server for fail over? what I meant is to cluster the production in Active/pasive mode and on the clustered server act as a Data warehouse for real time reporting.I hope you understand what I meant. If replication how would I know which tables to replicate? If is log shipping how would I start.Please advise. THanks.k |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-02-15 : 14:16:28
|
| You probably want an Active / Passive cluster that get's it's data from the production system using Log Shipping.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-02-15 : 14:23:08
|
| Yeah, I have heard of Clustering for Failover, it just didn't make sense in the context of your question. So are you proposing to have both the Production OLTP data and the Reporting OLAP server on the Active node of a cluster? I would advise against that if you are thinking of that.Replication - I don't know how you would know, I guess you would have to do some analysis on what needs to be reported on, or you could just replicate the entire DB.Log Shipping - Look it up in Books Online.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
fredong
Yak Posting Veteran
80 Posts |
Posted - 2005-02-15 : 14:31:05
|
| How about Active/Passive mode on OLTP and OLAP? Also does Log shipping needs to be a Clustered server in Active/Passive mode?If is a replication what mode(snap shot, merge ..) should I use if I know which tables to replicate.What would you all recommend if I need a real time Datawarehouse without hurting the production server. Any ideas.Thanks.k |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-02-15 : 15:08:08
|
| Two seperate clusters? That would be ideal. Log Shipping doesn't require clustering. If you need close to realtime, then Transactional replication would probably be the best choice.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
fredong
Yak Posting Veteran
80 Posts |
Posted - 2005-02-16 : 12:01:23
|
| Do you a step by step procedures how to set up a Transactional replication server? Thanksk |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-02-16 : 12:42:39
|
| it sounds like a reporting database is all that is needed. You don't necesarily need to setup clustering to accomplish this. Just use log shipping and you can setup a read only copy of your produciton database that x number of minutes behind the primary database. the number of minutes behind is determined by the frequency of your log backups.-ec |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-02-16 : 12:45:01
|
quote:
Originally posted by fredong
Do you a step by step procedures how to set up a Transactional replication server? Thanksk
no. That is what books online is for.-ec |
|
|
|
|
Clustered server for DataWarehousing?