当依赖于重读/写时，在php / mysql / ajax中要避免什么

Question

i was wondering what the main things were to avoid when creating an webapplication that relies on heavy reads and writes every second.

Think of online gaming where money is involved.

For example you have an javascript that constantly updates the browser(1), There is a cronjob running that updates the db(2), There is user input submitted via ajax or POST(3), and you have multiple users performing all these actions every second(4).

There is also money involved so all the data has to be read and written the correct way(5). And in case of crashes this the data has to be restored the right way so backups(6) are important.

So many things to keep in mind when creating such a complex application, what are the things you should definitely keep in mind.

I would like to know what your opinion on this is, Thank you!

Answer 1

If bandwidth is an issue consider gzipping your output to the browsers. Or if CPU power is an issue and gzip is enabled, disable it but risk increased bandwidth usage.

Set your static files such as css and images and javascript etc to cache on the browser and set to expire after a long time. This means repeat users wont use up your bandwidth etc to request the same version of a file they already have.

Run benchmarks on querys that you use. Optimise where ever possible. Maybe splitting up long queries into smaller ones could have a performance boost. Use a profiler like xdebug to find out your bottlenecks.

Use persistent sql connections to save resources on new connections on every load.

Create a mirror database and when ever you insert into your main database, insert the same data into the second one. Dont read from the second database as it serves as a backup. Try having the second database on a different server if you can. If a second database is not feasable, cron job backups like you mentioned should work well.

Next thing... is ajax really nessasary in your application? Will it work without it? Dont add unessasary bloat to your site with extra requests within ajax.

I cant write more as i dont know the specifics of your site / app.