What happens while I backup my database?
I perform daily database backups to my production database. Currently the database is small so the backup takes just a second or two. However, there's a potential for a sudden spike in users over the coming months and I began wondering about what happens when I'm backing up my database with a mysqldump? Are users locked out of the database during that process? Is there some some sort of "queue" that gets handled after the dump? Currently I use shared hosting which may or may not affect the response.