与PHP和mySQL的异步事务

Question

When a certain action happens on the site (built in PHP and MySQL) I would like few asynchronous things to happen on the site.

For example, when a user answers a question, uploads document, I want few asynchronous things to happen in the background such as: 1.update user's score 2. Post a message on Facebook wall 3.track users actions.

What PHP, JavaScript and MySQL technologies are best for achieving this? Please help.

I want something that MySQL triggers but wanted to happen asynchronously.

Answer 1

The only two options I can think of are a messaging queue, and async ajax.

The first option works by putting jobs into a database, then a scheduled php program will loop through every job in the database and run them.

The second is just calling a php program using ajax.

For the first option look at something like: http://alanstorm.com/simple_php_job_queue
For the second look at jquery, and its ajax options: http://api.jquery.com/jQuery.ajax/