Results 1 to 3 of 3
  1. #1

    mysql server - where to place???

    Hello,

    I am a web reseller and I also use osCommerce for a lot of my clients. I was wondering if anyone had any thoughhts on the following:

    I was thnking that if I hosted all of my clients mysql databases in one server it would be easier for to manage (instead of hosting in their own plan)...


    But then I started to wonder if this was good or bad -

    Will it be faster or slower?
    How about security issues? Less or More?
    And what about when the client uses a SSL?

    I know how to accept % hosts for the database, so is this less secure than using localhost within the site?

    Does anyone have any thoughts on this - any pros or cons?

  2. #2
    Join Date
    Apr 2003
    Posts
    454

    Re: mysql server - where to place???

    [QUOTE]Originally posted by clarocque

    Will it be faster or slower?
    How about security issues? Less or More?
    And what about when the client uses a SSL?
    QUOTE]

    Are you talking about having the MySQL files on a different server than the static/php files?

  3. #3
    That's what I'm getting from it too ReadyRick, and if that's the case, the answer is....it would be slower.

    It's almost always slower to load data remotely than if it was local.

    However, you wouldn't be the first to do this. For some, the slightly slower speed is un-noticable, for other on crappy networks, can find themselves collecting social security before the data loads.
    Mark - Owner/Lead Designer
    avidInteractive
    Lead vocalist for Circle7: Circle7 on MTV

Posting Permissions

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