/ Register

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.

Previous Thread Next Thread
Loading...
  1. 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. Aug 8, 2014 #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. Aug 9, 2014 #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. Aug 9, 2014 #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. Aug 9, 2014 #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 :)
     
Previous Thread Next Thread
Loading...

.