Results 1 to 10 of 26
Thread: Dedicated Database Server
-
March 22nd, 2008, 02:56 AM #1Super Member
- Join Date
- Mar 2006
- Location
-
Erie,
Pennsylvania
(Erie County) - Posts
- 970
- Rep Power
- 110401
Dedicated Database Server
As many of you have noticed, as the site grows it also slows..
To fix this we've offloaded the mysqld (database server) to a second server..
So far it seems much faster and snappier, we'll see how it handles primetime.
-
March 22nd, 2008, 11:46 AM #2
Re: Dedicated Database Server
Bravo. Does seem quicker.
We're lucky to have such competent folks behind the switch here
-
March 22nd, 2008, 02:18 PM #3
Re: Dedicated Database Server
Time to build that Tier 4 datacenter...
Thank you for this site/forum, I enjoy it very much.
-
May 15th, 2008, 11:46 PM #4
Re: Dedicated Database Server
could cut costs by dumping v bulletin and go to mybb *free*. =P I manage 2-3 mybb boards and it's awesome and its comparable to v bulletin.
-
May 15th, 2008, 11:48 PM #5
Re: Dedicated Database Server
I noticed the other nite it was rather BUSY.... but still workable... but this really does seem to be much faster in response...
EXCELENT JOB......................AGAIN......
This is still the best forum I have been on.... keep it going guys... GREAT STUFF
-
May 16th, 2008, 03:15 PM #6
-
May 16th, 2008, 06:57 PM #7Super Member
- Join Date
- Mar 2006
- Location
-
Erie,
Pennsylvania
(Erie County) - Posts
- 970
- Rep Power
- 110401
Re: Dedicated Database Server
vBulletin is the best forum software available, and the PAFOA already bought the lifetime license. We will not be migrating to anything else. The cost of vB was never the issue anyway.
The PAFOA forums are getting pretty big, and there are other large websites on the servers which this forum coexists with. Sometimes there isn't enough CPU for everything that particular second.
At some point in the future, we will probably have an IT Fund raiser and buy the PAFOA some bitchin servers of it's own to dedicate to the task of running these forums.
We're seeing 40-50 new registrations a day, most of which post. Eventually it's going to get crazy insane, and we need to be ready for the reality of a few hundred thousand members on these boards in a couple years. The thought of that on my personal web servers makes me cringe.
Sites like THR which have 10x the traffic we do have STRIPPED down vBulletin installations. No rep, no stats, no fancy urls, no image hosting, no flashchat... minimal.
As we continue to grow, we very well may forced into similar compromises as we balance cool features against laggy load times. We've shut a few things off temporarily to help during heavy load.
It's quite possible that we will roll out optional 'premium membership' subscriptions on the forums when we switch over to PAFOA owned dedicated servers. The boards will always remain open and free to use, but a paid membership would get you access to a VIP mini-forum area, and other cool stuff. This would help offset the bandwidth costs which PAFOA would begin to pay. Again, this would be optional and would probably come with a cool icon for your postbit. No idea on pricing, but it's won't be outrageous..
I'm glad to have helped start this board up with danp from the very beginning on my machines, and it's grown before my eyes into something that neither of us could have envisioned.
The reality is that we've created a monster, and it's going to outgrow my hosting capabilities at some point in the future. We need to be prepared BEFORE we get there.
Food for thought...Last edited by doug; May 16th, 2008 at 07:19 PM.
-
May 16th, 2008, 09:53 PM #8
Re: Dedicated Database Server
The woes of scalability planning.
I would gladly pay for a premium membership though.
-
May 16th, 2008, 10:03 PM #9Grand Member
- Join Date
- Jun 2007
- Location
-
PA,
Pennsylvania
(Delaware County) - Posts
- 3,604
- Rep Power
- 1246703
Re: Dedicated Database Server
Just curious of what kinda hosting/servers/pipe you guys are using. Its my field and maybe I can lend a hand or help out some.
Like others have mentioned, the cost of VBulletin is pretty cheap, the real cost in running this forum comes in the form of webhosting costs.
Like I mentioned before, I run my own websites and moderate other forums which have VERY heavy traffic.
Dan/Doug, you ever think about getting some sponsors? Paid memberships for sponsors to sell their products on here. This site has TONS of potential and I don't know if you ever thought about it, but there are plenty of opportunities for you to pull in some $$$ to offset costs to run the site and fill your pockets some too.
Let me know if you ever wanna chatLast edited by BimmerJon; May 16th, 2008 at 10:08 PM.
-
May 16th, 2008, 10:48 PM #10Super Member
- Join Date
- Mar 2006
- Location
-
Erie,
Pennsylvania
(Erie County) - Posts
- 970
- Rep Power
- 110401
Re: Dedicated Database Server
colocated/dell 1850 poweredge/more pipe than we could ever use..
The PAFOA currently has no bandwidth costs, as my company hosts it for free.
Care to provide some examples of the websites, and the VERY heavy traffic?
We're aware of the potential, and we very well may do ar15.com style button ads. We don't want to get too commercial, as we're a NPO. We also want to remain free from corporate influence. We will likely end up with exactly what I posted earlier, paid membership for people who choose to subscribe, and button ads for companies.
This site isn't about filling our pockets, it's about preserving the right to keep and bear arms.
Similar Threads
-
Database Error?
By KeithPA in forum GeneralReplies: 15Last Post: March 1st, 2008, 10:28 PM -
My Pic dedicated to PAFOA
By 40twist in forum GeneralReplies: 7Last Post: February 25th, 2008, 09:02 AM -
Internet Movie Firearms Database.
By ReefBlue in forum GeneralReplies: 2Last Post: January 12th, 2008, 06:03 PM -
Who has access to the Sales database?
By The Drew in forum GeneralReplies: 3Last Post: March 19th, 2007, 08:35 AM -
Firearms Prices Database
By bills in forum GeneralReplies: 1Last Post: January 5th, 2007, 10:43 PM
Bookmarks