| Author |
 Topic  |
|
|
Jotts
New Member
77 Posts |
 Posted - 19 September 2004 : 20:20:30
|
| I have to machines in to different places running windows server 2003... I use load balancing.. Like when There are 40 active users it mirrors to another server. How do i make it so that the mirror 2 gets the newest infor from my databes at server 1 |
Edited by - ruirib on 20 September 2004 05:10:48 |
|
|
Gargoyle
Junior Member
USA
280 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 19 September 2004 : 22:58:09
|
| Are you using Access? You'll probably want to use MS SQL or mySQL instead. |
Kiwihosting.Net - The Forum Hosting Specialists
|
 |
|
|
Jotts
New Member
77 Posts |
Posted - 20 September 2004 : 10:30:15
|
| I want to use access UNLESS i can copy all info to a sql database and if i do that how would i go about setting it up? |
|
|
|
Tiggerz
Starting Member
45 Posts |
Posted - 20 September 2004 : 18:49:04
|
| I've not tried it yet, but i'm told that sqlserver has a pretty good replication feature. You should be able to replicate changes from one db to another pretty quickly. However, dont know if it will also do it back the other way. |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 20 September 2004 : 20:12:52
|
I'd say stay away from replication probably, the cost of 2 SQL Server licenses aint exactly cheap. What you want is a DBMS that you can simply run on one of the servers, then point both config files to the one DBMS. MySQL or MS SQL will let you do this. If you want to have some degree of redundancy then perhaps consider replication via MS SQL but a sensible backup strategy will mitigate a lot of the risk regarding data loss anyway.
I'd recommend mySQL personally for this, it's cheap, it works well with Snitz and can be easily backed up to another machine for disaster recovery. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 20 September 2004 : 21:31:15
|
| MSSQL replication would not work well in a forum enviroment where changes are made every few seconds I'm afraid (at least that I know of). I think if you were going to go all out, dual SQL servers with a very fast shared disk array. Proper locking and a little work and you'd have one fast and redundant system. |
Erick
Snowmobile Fanatics
|
|
|
|
Tiggerz
Starting Member
45 Posts |
Posted - 20 September 2004 : 21:42:25
|
quote:
Originally posted by sr_erick
MSSQL replication would not work well in a forum enviroment where changes are made every few seconds I'm afraid (at least that I know of).
Last time I used sql server in development I was processing 80 million transactions per day. So I think it could easily handle a forum with 40 concurrent users :)
I understand that the sql server replication process is designed for what the original poster intended in a scaleable environment. I dont think its as sucky as people seem to think.
The other thing - just taking the problem from the other direction. Why would a database need to be load balanced for 40 users anyhow. Only the IIS servers (or whatever websever is being used) need to have the balancing done. The db server can sit on another box somewhere and serve both. I doubt 40 users would be capable of generating more that 1-2% loading at best (unless your running it on a really old pc). |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 21 September 2004 : 00:37:06
|
The need for load balancing is also determined by the availability requirements of the application, not necessarily the number of users who use the application, granted MS SQL on an appropriately specced server can handle a tremendous throughput of data, but as I mentioned above is the cost/benefit worth it? Two SQL Servers per CPU License = $$$$$.
quote:
I want to use access UNLESS i can copy all info to a sql database and if i do that how would i go about setting it up?
There's actually a sticky topic in the HELP Database - mySQL forum detailing precisely how to go about converting your forum from Access to mySQL. |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 21 September 2004 01:02:24 |
|
|
|
Jotts
New Member
77 Posts |
Posted - 21 September 2004 : 10:46:39
|
I have 10 licenses for SQL with my server edition it was alot of moneys... I just need to know how to set it up... If i could i want the other server's path in config.asp to be www.purerc.com/mydatabase.mdb is that possible? I have become very familar with access and i don't really like change... BTW if anyone can help me setup alittle demo mod so i can learn how to work with the database that would be great |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 21 September 2004 : 14:50:12
|
A 10 CAL licence for SQL server isn't the licence you should be using for an internet app. as far as I know. You need a 1 cpu licence.
If you are using an Access database you will find that over a certain amount of concurrent users it will slow down the forum. SQL Server can handle quite a lot of concurrent users depending on the setup. On Sep 11, 2001 I had over 1000 concurrent connections on a PIII 550 box with 512MB ram & SQL Server 2000 and that was running a less efficient version of the forum software. |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 21 September 2004 : 15:10:27
|
As far as I know in my little head, there is no way to access an Access file through any other means than physical disk access. You really wouldn't want two different processes accesing an mdb with write ability anyway given that Access isn't an RDBMS. You would need to use SQL Server, but be sure and lock down port 1433 to only your trusted server if you try. If you wanted to replicate the database for some kind of true load balancing, I'd make one node a designated poster and only replicate one way. Much easier, and most of your processing time is spent reading anyway.
But, like others have said, there is no need to even bother with it at your level. If you're still using Access as a back-end, then you haven't even started to see what a real load is yet. |
KawiForums.com
 |
|
|
| |
Topic |
|
Topic Locked
