[DanTzi]

Hello,

Is it possible to make kind of a "central MySQL database" for multiple servers, and can they be connected in same time to the database?

Thanks,
DanTzi

[Mandrakke]

of course you can, MySQL accept multiple connections.

[Eony]

Sure you can, multiple programs can be connected to a single MySQL database at once, simply make sure that your MySQL server allows remote connections.

Allow remove connections to your MySQL server

[VOXrr]

Yup, just be careful about simultaneous writes if they're connecting to the same database.

If possible, use InnoDB instead of MyISAM.

When MyISAM performs a write, it'll lock the entire database whilst it performs it's action. Everything else will form a cue. If it's one write per minute, you should be just fine - But if you're doing multiple writes per second, it's going to be a huge performance hit.
When InnoDB performs a write, it'll only lock a single row, leaving everything else open to writing. Success.

InnoDB can be a tad more of a resource grabber at times, but it's totally worth it in these kinds of situations.


tl;dr version: Yes, but you might want to optimise it.