Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Setting up remote MySQL Server

Discussion in 'General Discussion' started by PlanetHosted, Feb 23, 2006.

  1. PlanetHosted

    PlanetHosted Member

    Joined:
    Apr 2, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    Hi,

    We run a Free Web Hosting company. We are starting to get busy and would like to put all of the mysql on a separate server. We are a little confused as to how we would do this and get our control panel (iPanel) which uses cpanel to create the databases on our mysql server. iPanel interfaces with cPanel to create the account so I have a feeling it has nothing to do with iPanel and everything to do with cPanel. If anyone can suggest a tutorial or give us some ideas it would be GREATLY appreciated.

    Cheers!
    Jeff
     
    #1 PlanetHosted, Feb 23, 2006
  2. djmerlyn

    djmerlyn Well-Known Member

    Joined:
    Aug 31, 2004
    Messages:
    201
    Likes Received:
    1
    Trophy Points:
    168
    Setup the remote SQL server in WHM, thats pretty much all you need to do from the cpanel side as far as I know...

    New accounts and whatever will use the remote server if thats what you're using instead of the local one.
     
    #2 djmerlyn, Feb 23, 2006
  3. PlanetHosted

    PlanetHosted Member

    Joined:
    Apr 2, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    We have roughly 500 database's currently in use by free customers. Can they still use "localhost" or will every script become botched?

    Thanks man!

    Jeff
     
    #3 PlanetHosted, Feb 23, 2006
    Last edited: Feb 23, 2006
  4. djmerlyn

    djmerlyn Well-Known Member

    Joined:
    Aug 31, 2004
    Messages:
    201
    Likes Received:
    1
    Trophy Points:
    168
    Well, the SQL server will obviously be on a "remote host" which would indicate "localhost" will no longer be a valid SQL server host for the database.

    You will need to change everything.
     
    #4 djmerlyn, Feb 24, 2006
  5. PlanetHosted

    PlanetHosted Member

    Joined:
    Apr 2, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    Is there any possible way to make it stay on localhost? Also if I do have to change anything, will the default on the server be the remote host (aka on scripts in cpanel and such) or will it still be localhost.

    Thanks
    Jeff
     
    #5 PlanetHosted, Feb 24, 2006
  6. djmerlyn

    djmerlyn Well-Known Member

    Joined:
    Aug 31, 2004
    Messages:
    201
    Likes Received:
    1
    Trophy Points:
    168
    Let me see if I can make this clear...

    localhost = the service is on the local server
    remote host = the service is not on the local server

    To my knowledge, you can't (shouldn't) try to run something "remote" as a "localhost".

    If you think about it for 2 seconds, you can realize why something remote should not be seen as local...

    To solve your issue...leave everything the way it is...
     
    #6 djmerlyn, Feb 24, 2006
  7. PlanetHosted

    PlanetHosted Member

    Joined:
    Apr 2, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    Well that would only be making the issue worse. I will just have to find a way to change everyones scripts. We have nearly 9000 accounts on one server and its taking is toll so we are trying to move the MySQL off to lighten the load. However since we have just switched control panels only 600 accounts need moving so we should be ok.

    Thanks
    Jeff
     
    #7 PlanetHosted, Feb 24, 2006
  8. LucasVanzin

    LucasVanzin Well-Known Member

    Joined:
    Jan 21, 2004
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    Brazil
    Rinetd

    It is possible to forward the conections from localhost:3306 to remotehost:3306 with rinetd, that'd solve your problem in a better way :cool:
     
    #8 LucasVanzin, Mar 14, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - Setting remote MySQL
  1. FM Kappungal

    Understanding cPHulk configuration settings

    FM Kappungal, Mar 18, 2019, in forum: Security
    Replies:
    3
    Views:
    166
    cPanelMichael
    Mar 20, 2019 at 11:54 AM
  2. carolainn

    Setting SPF uses private IP instead of public

    carolainn, Mar 14, 2019, in forum: Bind/DNS/Nameserver
    Replies:
    10
    Views:
    151
    carolainn
    Mar 15, 2019
  3. Legin76

    Restore all DNS settings from backup

    Legin76, Mar 12, 2019, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    152
    cPanelLauren
    Mar 13, 2019
  4. Dragono Santika

    Redirection settings issue

    Dragono Santika, Feb 20, 2019, in forum: Security
    Replies:
    6
    Views:
    88
    cPanelLauren
    Feb 22, 2019
  5. Amin Hashemi

    Setting short_open_tag to off in php.ini

    Amin Hashemi, Feb 15, 2019, in forum: EasyApache
    Replies:
    1
    Views:
    106
    cPanelMichael
    Feb 15, 2019

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice