Welcome to Centmin Mod Community
Register Now

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:
    10:22 AM
    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

    30,856
    6,905
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,396
    Local Time:
    1:22 AM
    Nginx 1.13.x
    MariaDB 5.5
    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:
    10:22 AM
    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. RoldanLT

    RoldanLT Well-Known Member

    3,975
    965
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,329
    Local Time:
    11:22 PM
    1.11
    10.2
    You can switch them off.
     
    • Like Like x 1
  5. eva2000

    eva2000 Administrator Staff Member

    30,856
    6,905
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,396
    Local Time:
    1:22 AM
    Nginx 1.13.x
    MariaDB 5.5
    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 :)
     
    • Like Like x 3