Minimum hardware for a 125 site setup?

  • Mark Ratledge

    (@songdogtech)


    15 years, 6 months ago

    hey all,

    Anyone have *general* ideas on what would be the minimum hardware needed for a multisite setup with 125 blogs? Not looking for names of hosts, only minimum hardware.

    Right now, admin takes several minutes to load. Each site has the same very minimal theme.

    How much Ram? Definitely a 64bit box? How much ram does WordPress get in wp-config? And what does php get in php.ini?

    And I realize there are all kinds of MySql considerations, but I can sort those out over time with mysltuner.

    Thanks

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    15 years, 6 months ago

    I wouldn’t want to run that on anything less than a VPS with 384MB RAM, and give WP at least 64megs.

    Put in some caching, definitely, and turn off things you don’t need.

    I used this to get me started on optimization: http://www.earnersblog.com/vps-optimization-guide/

    Thread Starter Mark Ratledge

    (@songdogtech)

    15 years, 6 months ago

    That link looks good. Have had luck with people at Server Fault on general server stuff.

    We have 8 gigs total and WP has 512megs. The OS is only 32 bit, but that’s being changed now to 64.

    But the DB has almost 2 million records and 1000 tables, so I think that’s mostly where the bottleneck is. Think I need to look into multiple instances of mysql.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    15 years, 6 months ago

    Ouch. Yeah, splitting the DB may be the thing.

    32/64 shouldn’t matter. I’ve run bigger sites (not WP but others) on 32.

    I should add, it’s not the number of sites that’s the issue, most times, it’s the traffic. If you get a lot of posts and comments every day, then that’ll bog down your database on a SINGLE WP install, let alone a MultiSite.

    Andrea Rennick

    (@andrea_r)

    15 years, 6 months ago

    Yep, y’all need to split the db. 🙂

    http://ww.wp.xz.cn/extend/plugins/hyperdb/
    http://ww.wp.xz.cn/extend/plugins/shardb/

    And yes, to add to what Ipstenu said, the number of blogs usually isn’t the issue. It;s almost alwyas the traffic.

    I’ve had 600 blogs on a 768megs of RAM vps tick by nicely with a million server hits a month.

    And I’ve seen a ten blog instance of multsite (when it was wpmu) absolutely kill a 1 gig account on game day (They had a Yankees blog. ;P )

    you know, just for point of reference. 😀

    Thread Starter Mark Ratledge

    (@songdogtech)

    15 years, 6 months ago

    There’s no traffic to the blogs now; they’re still private. And not sports related 🙂 But on a subject probably just as contentious at times. Good to know that WP3 can handle that kind of traffic.

    Did stumble on those two plugins earlier and looks like maybe hyperdb is maybe the best to try, as all the databases already exist. And with shardb, it looks like I would need to rename tables.

    But do these make their own extra mysql instances on the box? As in configuring mysqld_multi? Or is that something I can also do? Or not if I choose?

    Andrea Rennick

    (@andrea_r)

    15 years, 6 months ago

    And with shardb, it looks like I would need to rename tables.

    Uh, no. No you do not need to rename tables. not sure where you got that idea. Shardb also works with an exisiting db. (I mean,it has to exist first, right?)

    Good to know that WP3 can handle that kind of traffic.

    So could wp 2.5…. the version has little to do with it.

    But do these make their own extra mysql instances on the box? As in configuring mysqld_multi? Or is that something I can also do? Or not if I choose?

    I think you’re trying to make it more complicated than it actually is….

    Ron Rennick

    (@wpmuguru)

    15 years, 6 months ago

    If you decide to use SharDB get the development version. It has a tool for migrating your database tables from a single database to the shards.

    Thread Starter Mark Ratledge

    (@songdogtech)

    15 years, 6 months ago

    It has a tool for migrating your database tables from a single database to the shards.

    That’s what I was wondering about…. Trying to understand this. So are the “shards” separate databases? In a virtual sense? Or actually separate databases that can be seen via say phpmyadmin? And how does SharDB differ from mysqld_multi?

    Not looking for a Ph.D. dissertation, but just a way to learn this. It’s a step up from the httpd and mysqld tuning I’ve dabbled in on other VPSs.

    Andrea Rennick

    (@andrea_r)

    15 years, 6 months ago

    I believe mysql_multi would be under separate web accounts. this lets you just have more than one db, under one web account, each db can have the same user/pass for access or different.

    under one web account means yes you can see them all in phpmyadmin too.

    It;s not near as hard as it may look. 😉

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Minimum hardware for a 125 site setup?’ is closed to new replies.