regiemon,
MySQL is a multi user database, it will handle the connection requests and transactions for you so there is really not much for you to worry about in that respect... as your site grows you will be more concerned with the type and volume of transactions that may occur on your database server and this will influence how you setup your MySQL server.
Here is some info on MySQL:
http://en.wikipedia.org/wiki/MySQL#P...ming_languages http://www.mysql.com/