i am working on an web application that requires the page to be updated every second. You can think of a websites with stocks where the data has to be updated real time.
For this real time update i use Ajax, the jquery plugin. My database is mysql with innoDB tables, and the application itself is written in php.
The Ajax script in the browser runs every second, this does only a read. To update the database with other values there is a cronjob that executes every minute, which executes a php script that runs every second. This scripts does reads and writes.
Further more the user does reads and writes. There is a lot going on.
Now i am fairly new to this type of large applications, and some of the terms are confusing me quite a bit, and i don't know if my setup is wrong.
My setup right now is like this:
I have a dedicated server, with centos running and plesk parallel panels. The server is running apache, with php and mysql databases.
Now here is the list of things that are confusing me. I have read about these terms but i don't understand what they really do and how to benefit from them.
1) The first thing is lighttpd and ngingx. Are they http servers like apache, or are they something else. And if they are http server, are they easy to switch to from apache.
2) What is FastCGI and CGI. Are they like php, or are they something else. Are there any benefits over using PHP, and are they easy to switch to.
3) Last thing i want to know is something about static content delivery. If i want to deliver my static content from another domain do i need a separate server for that, or can i just configure that in PLESK.
Sorry for all the noob question guys, but i would really appreciate some help on these topics.