Should I pay extra for a hosting the database on a separate host

Discussion in 'Troubleshooting' started by 123Marketing, Feb 10, 2017.

  1. 123Marketing

    123Marketing aMember Pro Customer

    Joined:
    Jun 4, 2005
    Messages:
    128
    This is more about speed increases rather than troubleshooting...

    I noticed my WordPress-powered blog is SIGNIFCANTLY faster in all aspects by having the mysql database hosted on a separate server.

    I use cloud hosting. Another "Linode" is $10 extra a month. Should I use the same strategy with Amember? (Or is this just throwing $10 a month out of the window?)

    If so, what files do I need to edit to point the new mysql file?
  2. caesar

    caesar aMember Pro Developer Staff Member

    Joined:
    Oct 16, 2009
    Messages:
    1,660
    I am afraid I do not sure how it improve performance (it depends on many factors) but you can test it and in case you do not like new setup then revert it back.

    You can find database connection settings in file
    amember/application/configs/config.php

    Best Regards.
  3. 123Marketing

    123Marketing aMember Pro Customer

    Joined:
    Jun 4, 2005
    Messages:
    128
    Great.

    So I would replace:

    localhost

    with my i.p., right?
  4. caesar

    caesar aMember Pro Developer Staff Member

    Joined:
    Oct 16, 2009
    Messages:
    1,660
    It depends on your server configuration. You need to fill in correct credentials for mysql server in this file. I suggest to contact your system administrator for details.

    Please take into account new server should have aMember database in place. You can copy database from current server to new one.

Share This Page