I have a few blogs/websites hosted on my vps. Recently I've decided to move a db on a single central server/vps because all the blogs have the same structure in terms of code and structure of the db.
The problem is, how can I effortlessly start using "application_id" in my db? It will denote a website data belongs to.
Say, I have these tables:
-- users -- articles -- categories -- tags
and others. Now I'll have to insert one additional column in each table: "application_id"
Not a big deal. I think. But perhaps there's a simple and more smart way to archieve the same goal?
And in general, is it a good idea to move it to a central, single vps/server/db?