Create multiple databases to a one system

There is a one system that required to implement which has number of large users and number of queries for second.

What will be the best approach creating tables开发者_运维百科 on a multiple databases or in a single database ? and Why?.

I would recommend one database with multiple instances. You can set up Master / Slave replication between those database instances.

Some useful links: http://dev.mysql.com/doc/refman/5.0/en/replication.html http://members.cox.net/midian/howto/mysqlReplication.htm