Welcome to Centmin Mod Community
Become a Member

MariaDB Separate DB Server from Web

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Bubka3, Aug 8, 2014.

  1. Bubka3

    Bubka3 New Member

    17
    5
    3
    Jun 1, 2014
    New York, NY
    Ratings:
    +5
    Local Time:
    12:48 PM
    1.7.1
    5.5.37
    Hey,

    I'm looking to move my database off my centmin server, so I have a couple of questions.


    Installing MariaDB on the new server, should I:
    • Use Centmin mod to install it
    • Install it from repos on their site
    Also, what steps should I take in disabling it on the current server?
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,158
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    2:48 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Just install via Centmin Mod for both Web and DB servers. Then disable MariaDB on Web server after install with just
    Code:
    service mysql stop
    chkconfig mysql off
    
    This way if they ever need to troubleshoot or have an emergency transfer of their database server mysql databases to their webserver, then can just re-enable mysql
    Code:
    service mysql start
    chkconfig mysql on
    
    Then be sure to whitelist respective IPs for both Web and DB server's instance of CSF Firewall CSF - CSF Firewall info | Centmin Mod Community
     
  3. Bubka3

    Bubka3 New Member

    17
    5
    3
    Jun 1, 2014
    New York, NY
    Ratings:
    +5
    Local Time:
    12:48 PM
    1.7.1
    5.5.37
    If I install centmin on the db server, wouldnt that load all the other services I don't need?
     
  4. rdan

    rdan Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    12:48 AM
    Mainline
    10.2
    You can switch them off.
     
  5. eva2000

    eva2000 Administrator Staff Member

    55,158
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    2:48 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yeah just do what you did for MariaDB service on WEB server for other services on DB server

    so on DB server do

    Code:
    service nginx stop
    service nsd stop
    service php-fpm stop
    service memcached stop
    chkconfig nginx off
    chkconfig nsd off
    chkconfig php-fpm off
    chkconfig memcached off
    :)

    This way if you ever need to quickly move or change WEB or DB roles, it's just a matter of re-enabling services :)