Multi-user PHP App with mySQL database - Different Users Same Tables?

Question

Just a quick question - I am writing a PHP app that relies heavily on SQL databases. I am slightly worried that many users all accessing the same database will cause errors. If so, how can I overcome this, what can be done?

I am not sure how many users at the end of the day will be using it, not hundreds, but maybe 5 or 10 or even 20. And even then its unlikely that they will be updating at the EXACT same time, but still. Any thoughts?

Well I just wonder what exactly happens if say two people update the SAME table at exactly the SAME time, surely that would produce an error? — Chud37
– Chud37, Commented Jun 30, 2012 at 14:27
stackoverflow.com/questions/5524182/… - stackoverflow.com/questions/4399191/… - stackoverflow.com/questions/11099890/… — Mike B
– Mike B, Commented Jun 30, 2012 at 14:29
Database servers handle concurrency access, reading/writing lock. Don't worry :) — Francois
– Francois, Commented Jun 30, 2012 at 14:30
so the solution.. is locking the tables? it seems to say that mySql is very good at preventing deadlocks? — Chud37
– Chud37, Commented Jun 30, 2012 at 14:33

TazGPL · Accepted Answer · 2012-06-30 14:37:25Z

1

MySQL Transactions is what you're looking for.
Then PHP PDO extension with its transactions management.

answered Jun 30, 2012 at 14:37

TazGPL

3,7442 gold badges41 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chud37 Over a year ago

Thanks. Yeah but i'm saying, there seems to be two thoughts: one is, with mySql its not needed, it handles concurrency in its own way, and two, start locking your tables. So which is it?

TazGPL Over a year ago

Oh yes, it's needed with MySQL. By default it does not handle the concurrency the safe way. This is why transactions are provided where there's a need. There's another question on SO that may answer your question: mySQL Transactions vs Locking Table.

Collectives™ on Stack Overflow

Multi-user PHP App with mySQL database - Different Users Same Tables?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related