Welcome to Centmin Mod Community
Register Now

Installing MySQL on a separate server

Discussion in 'Install & Upgrades or Pre-Install Questions' started by Abbas Jaffar Ali, Sep 14, 2014.

  1. Mike Guista

    Mike Guista New Member

    24
    10
    3
    Sep 15, 2014
    Ratings:
    +10
    Local Time:
    2:39 PM
    1.7.6
    10.x
    • WP Super Cache exactly as outlined on @eva2000 guide on wp1.centmincache.com
    • WP Widget Cache
    • Memcached for ngx_pagespeed
    • Zend Opcache with PHP 5.6.0
    Plugins used:
    No, database size is not 1GB. The site is not open for member registration. Just around 10K posts, 3 admin members and database size is ~110MB

     
    Last edited: Sep 15, 2014
  2. eva2000

    eva2000 Administrator Staff Member

    53,209
    12,113
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,649
    Local Time:
    7:39 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    FYI, guide off centminmod.com at wp1.centmincache.com (centmincache.com) ;)

    majority of memory would be mysql, php-fpm and nginx for Xenforo. Wordpress with WP Super cache is just static file serving basically for Nginx - much less overhead :)
     
  3. rdan

    rdan Well-Known Member

    5,439
    1,397
    113
    May 25, 2014
    Ratings:
    +2,186
    Local Time:
    5:39 AM
    Mainline
    10.2
    Ah, that's why :)

    Feels like I want to convert my forum into Wordpress :D
    Less pain, less expense, less server resources.
     
  4. Mike Guista

    Mike Guista New Member

    24
    10
    3
    Sep 15, 2014
    Ratings:
    +10
    Local Time:
    2:39 PM
    1.7.6
    10.x
    RAM & SWAP usage in last 24 hours;
    [​IMG]

    Average load in last 24 hours;
    [​IMG]
    Average network usage in last 24 hours;
    [​IMG]

    Hourly visitors in last 24 hours from Google Analytics;
    [​IMG]
     
  5. Mike Guista

    Mike Guista New Member

    24
    10
    3
    Sep 15, 2014
    Ratings:
    +10
    Local Time:
    2:39 PM
    1.7.6
    10.x
    Post edited.
     
  6. Mike Guista

    Mike Guista New Member

    24
    10
    3
    Sep 15, 2014
    Ratings:
    +10
    Local Time:
    2:39 PM
    1.7.6
    10.x
    Today I got highest visitors at a time which lasted for ~20 minutes. RAM usage was below 350MB but CPU was RED. Loving centminmod :kiss:

    [​IMG]
    [​IMG]
     
  7. eva2000

    eva2000 Administrator Staff Member

    53,209
    12,113
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,649
    Local Time:
    7:39 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    very nice indeed :D