Previous Thread
Next Thread
Print Thread
Rate Thread
Database on Multiple Servers #282847
01/03/2005 2:35 PM
01/03/2005 2:35 PM
Joined: Aug 2002
Posts: 6
W
weinstoc Offline OP
Lurker
weinstoc  Offline OP
Lurker
W

Joined: Aug 2002
Posts: 6
My forums at http://forumserver.twoplustwo.com regularly hosts
upwards of 600 people (heading towards 700) during peak hours. I
find that if I don't prune inactive threads back beyond about
2.5 months that the database server moves as fast as molasses.
I'd like to be able to keep more threads active but I can't
under the current configuration.

At the moment I have a database server and a separate web server
(which also serves up advertisements). MySQL has been tuned for
the loads the forum puts on it.

I'm considering adding a second database server and slaving it
to the first server. The idea would be that all inserts and
updates would be done to the main server which would then mirror
them to the slave server. Selects would be done on either server
on a more or less random basis.'

This is a non-trivial change and I'm wondering if anyone here
has been down this (or an alternate viable path) already?

Chuck Weinstock

Sponsored Links
Re: Database on Multiple Servers [Re: Thor] #282848
01/03/2005 3:22 PM
01/03/2005 3:22 PM
Joined: Mar 2002
Posts: 207
C
Conrad Offline
Member
Conrad  Offline
Member
C

Joined: Mar 2002
Posts: 207
Forgive me asking, but wouldn't it be easier to just get a big mutha Dual Xeon with 2 gigs ram and a scsi drive? That should still do fine at 600-700. I'm peaking close to 500 and running a 1 gig system (dual xeon of course).

Also, if threaded/expanded mode isn't that important to your users then cutting this out will surely solve all your problems.

Re: Database on Multiple Servers [Re: CHOELIN] #282849
01/03/2005 4:26 PM
01/03/2005 4:26 PM
Joined: Aug 2002
Posts: 6
W
weinstoc Offline OP
Lurker
weinstoc  Offline OP
Lurker
W

Joined: Aug 2002
Posts: 6
Conrad,

Thanks for the note. I am currently running Dual Athlon
2.33mhz with 2 gigs of Ram and a SCSI Raid array.
I believe the Athlon is equivalent to the Xeon.

Regarding threaded/expanded mode, I'm not sure exactly
what you are saying. Are you suggesting requiring the
threads to be shown in "flat" only or are you suggesting
the opposite?

My real problem is the number of posts that I want to
keep active. Currently we're at about 300,000 and things
work well, but if it gets to as high as 500,000 active
posts things slow to a crawl.

Chuck

Re: Database on Multiple Servers [Re: Thor] #282850
01/03/2005 5:41 PM
01/03/2005 5:41 PM
Joined: Mar 2002
Posts: 207
C
Conrad Offline
Member
Conrad  Offline
Member
C

Joined: Mar 2002
Posts: 207
Not sure how the Athlons work (definitely getting an Athlon 64 for my next home setup though...), but the Xeons seem to operate as 2 processors (each), probably like the Hyper-threading feature found in upper-tier Pentium processors. So a Dual Xeon actually shows up in WHM as having 4 processors.

To be honest my board was flying at 471 users, and I haven't even tuned MySQL yet (still waiting for help on this both here and at ubbcentral.com).

The only problems I've had were actually caused by threaded mode, and they even happened at off-peak times (4am, 1/10 of max number of users type of thing...). I'm currently trying to remove the threaded option as well as expanded mode completely from the system: I need to "surgically" remove threaded/expand options... help...!

In my case threaded-mode & expanded-view pose too much of a strain on server resources to warrant their use. I'm actually looking forward to seeing the option to switch off threaded mode in the CP when the new software is released in Spring.

As for the # of topics, feel free to give my forums a look to see if the numbers are anywhere close to what you're getting: http://www.mecz.org/ubbthreads/ubbthreads.php . With the exception of 1-2 of the forums I don't prune anything at all.

Re: Database on Multiple Servers [Re: CHOELIN] #282851
01/03/2005 6:53 PM
01/03/2005 6:53 PM
Joined: Dec 2000
Posts: 1,545
Germany
A
Astaran Offline
Addict
Astaran  Offline
Addict
A

Joined: Dec 2000
Posts: 1,545
Germany
I have several clients who use a mysql replication to load balance the load on several database servers. This is done by a small extension for ubb.threads and a replication of the ubb.threads database.

You can contact me if you want some more details about it.

Sponsored Links

Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
badfrog
badfrog
somewhere on the coast of Maine
Posts: 94
Joined: March 2007
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,456
Posts293,497
Members13,800
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,941
Greg Hard 5,533
Top Posters(30 Days)
isaac 8
Gizmo 3
driv 1
Today's Statistics
Currently Online 908
Topics Created 2
Posts Made 6
Users Online 3
Birthdays 24
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.3
(Snapshot build 20180924.dev)
PHP: 5.4.45 DB: MySQLi Page Time: 0.296s Queries: 15 (0.090s) Memory: 3.2653 MB (Peak: 3.4829 MB) Zlib enabled. Server Time: 2018-09-24 15:17:02 UTC