Results 1 to 5 of 5
  1. #1
    Join Date
    May 2007
    Posts
    139

    Unanswered: MySQL installation may shared between (locally servers localhost) Tomcat/JSP/Java and

    MySQL installation may shared between (locally servers localhost) Tomcat/JSP/Java and Apache/PHP? I mean having both server but one MySQL ...? May same time operate both servers and MySQL serves both same time?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    a MySQL server can serve data to as many clients as needed, whether they be web servers or workstations.. its immaterial.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2007
    Posts
    139
    by saying "clients" you mean Web Servers(in case locally) ? either these run same time or at differ time each?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    a, any, db server exists to serve clients requesting data
    as far as the db server is concerned, it doesn't matter if the clients requesting data are web servers, access applications on user desktops, embedded systems, bespoke software developed in Java, C, .NET. providign the server and the netwrok infrastructure is up to it a server serves data.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Sep 2009
    Posts
    64
    Quote Originally Posted by lse123
    by saying "clients" you mean Web Servers(in case locally) ? either these run same time or at differ time each?
    Clients = one connection to MySQL.

    If your Tomcat makes one connection to MySQL, it's one client.

    Then at the same time (or not at the same time), you have PHP/Apache connects to the same MySQL server, then it's the second client.

    Then you may also have other clients, like SQLyog connecting to MySQL ... it's also (you guessed it) a client.

    Also, you may have PDNS running and connecting to the same MySQL. Needless to say, it's also another client.

    As far as MySQL concerns, it doesn't care if Tomcat/Java or PHP/Apache or SQLyog or PDNS or any other software you can imagine connects to it (as long as the credentials checks). It just count how many connections are open at any given time. If something is connecting to it, it'll check the credentials and check if it can still make connections. If yes, then you're in. If not, then MySQL will throw too many connection erros.
    Last edited by mnirwan; 10-18-09 at 22:48.

Posting Permissions

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