Website/PHP App on One Server; MySQL DB on a Different Server - Feasible?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jake
    #1

    Website/PHP App on One Server; MySQL DB on a Different Server - Feasible?

    I apologize for what is probably a "stupid", uninformed question but
    here goes...

    I just inherited an ASP site project currently running off of a
    Microsoft Access DB which I'd really like to convert to MySQL/PHP.
    The only problem is that the site's host only supports Microsoft
    Access and SQL DBs. MS SQL is simply not an option for us at this
    time and the site is getting enough traffic that Access's 10
    concurrent connection limitation is going to start to become an issue
    in a hurry. This client recently renewed their annual subscription
    for hosting services from the aforementioned provider so switching
    hosts is not an option at this time.

    I'd like to convert the Access DB to MySQL and host the DB on my
    host's server while maintaining the asp/php site on the current host's
    box but am worried that it will dramatically increase the time it
    takes to process the asp/php scripts. It this sort of setup generally
    frowned upon? Is there any way of estimating script processing time
    without implementing the setup I've described and testing it
    thoroughly? I should mention that the script is a very basic "SELECT"
    query that simply pulls info from a database; it is nothing complex or
    extremely taxing resource, server or bandwidth wise. Am I completely
    off my rocker?

    Any advice or input would be greatly appreciated. TIA

    JP
    Tags: None
    • Andy Hassall
      #2
      Re: Website/PHP App on One Server; MySQL DB on a Different Server - Feasible?

      On 5 Feb 2004 09:06:57 -0800, long_jp@yahoo.c om (Jake) wrote:
      [color=blue]
      >I'd like to convert the Access DB to MySQL and host the DB on my
      >host's server while maintaining the asp/php site on the current host's
      >box but am worried that it will dramatically increase the time it
      >takes to process the asp/php scripts. It this sort of setup generally
      >frowned upon? Is there any way of estimating script processing time
      >without implementing the setup I've described and testing it
      >thoroughly? I should mention that the script is a very basic "SELECT"
      >query that simply pulls info from a database; it is nothing complex or
      >extremely taxing resource, server or bandwidth wise. Am I completely
      >off my rocker?[/color]

      Actually, separating database and web servers between two separate machines is
      one approach to speed things up, given a sufficiently fast network link. If
      it's busy enough that PHP/webserver and the database are both contending for
      resources, giving them each their own machines can improve performance.

      Just make sure the network connection doesn't become a worse bottleneck. If
      you're running the database connection over the Internet though, rather than a
      LAN between the two, that would be pretty dodgy, from both performance and
      security points of view.

      --
      Andy Hassall <andy@andyh.co. uk> / Space: disk usage analysis tool
      <http://www.andyh.co.uk > / <http://www.andyhsoftwa re.co.uk/space>

        Comment

        • David Precious
          #3
          Re: Website/PHP App on One Server; MySQL DB on a Different Server - Feasible?

          Andy Hassall wrote:
          [color=blue]
          > On 5 Feb 2004 09:06:57 -0800, long_jp@yahoo.c om (Jake) wrote:
          >[color=green]
          >>I'd like to convert the Access DB to MySQL and host the DB on my
          >>host's server while maintaining the asp/php site on the current host's
          >>box but am worried that it will dramatically increase the time it
          >>takes to process the asp/php scripts. It this sort of setup generally
          >>frowned upon? Is there any way of estimating script processing time
          >>without implementing the setup I've described and testing it
          >>thoroughly? I should mention that the script is a very basic "SELECT"
          >>query that simply pulls info from a database; it is nothing complex or
          >>extremely taxing resource, server or bandwidth wise. Am I completely
          >>off my rocker?[/color]
          >
          > Actually, separating database and web servers between two separate
          > machines is
          > one approach to speed things up, given a sufficiently fast network link.
          > If it's busy enough that PHP/webserver and the database are both
          > contending for resources, giving them each their own machines can improve
          > performance.
          >
          > Just make sure the network connection doesn't become a worse bottleneck.
          > If
          > you're running the database connection over the Internet though, rather
          > than a LAN between the two, that would be pretty dodgy, from both
          > performance and security points of view.
          >[/color]

          You could set up a secure tunnel between the two using stunnel
          (http://www.stunnel.org/), or use SSH (extra bonus being that you could
          also use compression).

          That would take care of the security. Perhaps using persistent connections
          may improve the speed.

          Cheers

          Dave P

          --
          David Precious
          PreshBlog | David Precious – professional Perl developer, motorcyclist and beer drinker
          http://www.preshweb.co.uk/


            Comment

            • Jochen Daum
              #4
              Re: Website/PHP App on One Server; MySQL DB on a Different Server - Feasible?

              Hi Jake!
              On 5 Feb 2004 09:06:57 -0800, long_jp@yahoo.c om (Jake) wrote:
              [color=blue]
              >I apologize for what is probably a "stupid", uninformed question but
              >here goes...
              >
              >I just inherited an ASP site project currently running off of a
              >Microsoft Access DB which I'd really like to convert to MySQL/PHP.
              >The only problem is that the site's host only supports Microsoft
              >Access and SQL DBs. MS SQL is simply not an option for us at this
              >time[/color]

              Can you get into more detail on that? I'm happily using this
              combination and it gives you some more options with reporting
              (subqueries) and programming structure (by using views and stored
              procedures)



              HTH, Jochen
              --
              Jochen Daum - CANS Ltd.
              PHP DB Edit Toolkit -- PHP scripts for building
              database editing interfaces.
              PHP DB Edit Toolkit
              http://sourceforge.net/projects/phpdbedittk/
              Download PHP DB Edit Toolkit for free. PHP DB Edit Toolkit is a set of PHP classes makes the generation of database edit interfaces easier and faster. The main class builds tabular and form views based on a data dictionary and takes over handling of insert/update/delete and user input.

                Comment

                • Jake
                  #5
                  Re: Website/PHP App on One Server; MySQL DB on a Different Server - Feasible?

                  Greetings...

                  "Jochen Daum" <jochen.daum@ca ns.co.nz> wrote in message
                  news:ej7d20tm3m 3vb4tde71nqs5sa 0mlh8rjuh@4ax.c om...[color=blue]
                  > Hi Jake!
                  > On 5 Feb 2004 09:06:57 -0800, long_jp@yahoo.c om (Jake) wrote:[color=green]
                  > >I just inherited an ASP site project currently running off of a
                  > >Microsoft Access DB which I'd really like to convert to MySQL/PHP.
                  > >The only problem is that the site's host only supports Microsoft
                  > >Access and SQL DBs. MS SQL is simply not an option for us at this
                  > >time[/color]
                  >
                  > Can you get into more detail on that? I'm happily using this
                  > combination and it gives you some more options with reporting
                  > (subqueries) and programming structure (by using views and stored
                  > procedures)
                  >
                  >
                  >
                  > HTH, Jochen
                  > --
                  > Jochen Daum - CANS Ltd.[/color]

                  We simply don't have the financial means necessary to implement a MS SQL
                  solution at this time. Thanks for your and everyone's comments!

                  JP


                    Comment

                    • Jochen Daum
                      #6
                      Re: Website/PHP App on One Server; MySQL DB on a Different Server - Feasible?

                      Hi!
                      [color=blue]
                      >
                      >We simply don't have the financial means necessary to implement a MS SQL
                      >solution at this time. Thanks for your and everyone's comments!
                      >[/color]
                      I read it wrong the first place. I thought you had SQL Server already.
                      Wouldn't have suggested it otherwise.

                      Jochen
                      --
                      Jochen Daum - Cabletalk Group Ltd.
                      PHP DB Edit Toolkit -- PHP scripts for building
                      database editing interfaces.
                      PHP DB Edit Toolkit
                      http://sourceforge.net/projects/phpdbedittk/
                      Download PHP DB Edit Toolkit for free. PHP DB Edit Toolkit is a set of PHP classes makes the generation of database edit interfaces easier and faster. The main class builds tabular and form views based on a data dictionary and takes over handling of insert/update/delete and user input.

                        Comment

                        Previous template Next
                        Working...