If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > MySQL installation may shared between (locally servers localhost) Tomcat/JSP/Java and

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-18-09, 09:26
lse123 lse123 is offline
Registered User
 
Join Date: May 2007
Posts: 139
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?
Reply With Quote
  #2 (permalink)  
Old 10-18-09, 13:38
healdem healdem is online now
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,258
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 my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old 10-18-09, 15:30
lse123 lse123 is offline
Registered User
 
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?
Reply With Quote
  #4 (permalink)  
Old 10-18-09, 16:56
healdem healdem is online now
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,258
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 my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #5 (permalink)  
Old 10-18-09, 21:42
mnirwan mnirwan is offline
Registered User
 
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 21:48.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On