Results 1 to 7 of 7
  1. #1
    Join Date
    May 2009
    Location
    Greece
    Posts
    1,008

    Arrow Looking for secure setup mysql on second server for my forum

    Hello

    I want for a forum to move the db to another server and i need a secure setup guide to do it....

    Thank you

  2. #2
    You want to move the whole website or?
    Anyway here is a guide how to move the database: http://www.cypherhackz.net/archives/...nother-server/

  3. #3
    Join Date
    May 2009
    Location
    Greece
    Posts
    1,008
    I just need to move only the database on a second server so it can get all server resources and with the internal 1.000 Mbit connection it will load faster.

    Thanks for the link but is not what i want

  4. #4
    So you need just the requests to your database to be served by your new server?

  5. #5
    Join Date
    Jan 2002
    Location
    USA
    Posts
    4,548
    Are both your servers in the same DC? On the same network? Does your provider support private networking between servers? If so, I'd start there. I'd disable outside access to your MySQL machine by only allowing the internal IP of the WWW server to communicate with it.

    If your MySQL server is anywhere but local to your WWW server, then you will likely not gain much benefit from having to query across the country.
    vpsBoard - An active resource for all things Virtual Private Servers. Tutorials, Guides, Offers and more!
    Come join the conversation! 90,000 posts and growing daily! The fastest growing hosting forum around!

  6. #6
    Join Date
    Dec 2012
    Posts
    1,853
    I agree with everything he just said ^^

    If the server is not local (in the same DC) to your main server then this will actually degrade the performance/response times of DC quires and seek times. Get a server local to it, using an internal IP/crossover to the other server and cut out any outside connections to it. That will keep the server completely secure from any outside attacks. Make sure to use SSD drives with this mysql server too! If small enough just use RAM to load the database from, 10x faster.
    SolaDrive - Enterprise Managed Solutions
    Specializing in Managed SSD VPS & Dedicated Servers in US & UK
    Rated #1 Provider at Top 20 VPS Providers For Performance
    Visit us at SolaDrive.com

  7. #7
    Join Date
    May 2009
    Location
    Greece
    Posts
    1,008
    Yes they are on the same datacenter both servers.

    And yes i need just the requests to my database to be served by my new second (only mysql) server

Similar Threads

  1. Setup and Secure Your Windows Server @ Just $80
    By tweakservers in forum Systems Management Offers
    Replies: 0
    Last Post: 07-16-2012, 08:14 PM
  2. We Setup and Secure Your Windows Server at just $xx
    By tweakservers in forum Systems Management Offers
    Replies: 2
    Last Post: 11-12-2011, 05:16 AM
  3. Secure and setup my server...
    By Varcoe in forum Systems Management Requests
    Replies: 6
    Last Post: 03-04-2010, 04:44 PM
  4. How to setup MYSQL to run locally on your pc? (local forum setup)
    By BmXStuD in forum Programming Discussion
    Replies: 9
    Last Post: 08-02-2006, 12:24 AM
  5. Secure Server Setup
    By j_uprichard in forum Ecommerce Hosting & Discussion
    Replies: 7
    Last Post: 10-07-2004, 10:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •