Skip to content

Why you should use schemata instead of multiple databases

Just a week ago i had a discussion with a Mysql fellow about pro and contra for schemata (schema.table as example in PostgreSQL) or use of multiple databases (database.table in Mysql).

Today i found this article: http://mysqlmusings.blogspot.com/2006/09/replication-and-disappearing.html

and of course this is another big argument against the possibility of accessing two or more databases in one query statement.