Join the community today
Become a Member

OVH Separate DB Server on OVH

Discussion in 'Dedicated server hosting' started by Jimmy, Jul 8, 2018.

  1. Jimmy

    Jimmy Well-Known Member

    1,707
    365
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +923
    Local Time:
    11:49 AM
    1.17.x
    MariaDB 10.3.x
    I was thinking of moving my database to a separate server. Right now I have a pretty powerful 6/12 dedi server at OVH which I use for everything.

    Thought maybe if I got a cheaper web server and combined that with one of the really fast CPU gaming servers (running the database) it might be a nice package, plus I'd save some money.

    I have looked at other services, but OVH is again... the cheapest.



    Anyone ever thought about doing this?

    @eva2000 would there be a lot of changes needed since the database would be on another server (centmin mod level), not application level? Do you think the database only server would need a full install of centmin mod since it's only going to be for a database?

    Any thoughts?
     
  2. eva2000

    eva2000 Administrator Staff Member

    45,651
    10,357
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,073
    Local Time:
    2:49 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    You'd need to create all the databases on the db server and manually create all user grant permissions for remote web server to connect to remote db server. Centmin Mod addons/mysqladmin_shell.sh only creates mysql users for local mysql server and not remote.

    Yes i usually recommend centmin mod install just stop php-fpm and nginx services on db server. That way if your web server dies, you can immediate start php-fpm and nginx servers on db server and have everything moved from web server to db much quicker.

    These days you aren't going to get that much better performance splitting mysql to separate server unless you're overwhelming existing web+db server and there's contention in resource usage for nginx, php-fpm and mysql. In fact response time will be slower splitting db services up to a certain point depending on mysql user concurrency work loads you have. Unless you're constantly pushing 300-500+ concurrent mysql connections (not same as forum users, php-fpm or nginx concurrent users) and mysql query response time is negatively impacted at high mysql concurrent user loads, splitting to separate db server isn't really needed. Monitoring server resource usage statistics is key to determining when db remote server offloading is needed.
     
  3. eva2000

    eva2000 Administrator Staff Member

    45,651
    10,357
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,073
    Local Time:
    2:49 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    FYI, OVH vrack isn't supported by OVH gaming servers AFAIK
     
  4. Jimmy

    Jimmy Well-Known Member

    1,707
    365
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +923
    Local Time:
    11:49 AM
    1.17.x
    MariaDB 10.3.x
    Yea, they're not supported. Going to cost more than a full blown server anyway - since OVH charges $21 extra for the vRack 1Gbps on the servers.
     
  5. eva2000

    eva2000 Administrator Staff Member

    45,651
    10,357
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,073
    Local Time:
    2:49 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Yup gaming motherboards don't have the support.

    (test missing editor)
     
  6. Jimmy

    Jimmy Well-Known Member

    1,707
    365
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +923
    Local Time:
    11:49 AM
    1.17.x
    MariaDB 10.3.x
    It's back.