MySQL Forums
Forum List  »  Performance

Are there any pitfalls with having multiple MySQL databases on 1 server node?
Posted by: John Smith
Date: August 27, 2010 02:44AM

I want to prepare my database for sharding in the future. But right now I only need 1 node.

What I'd like to do is to shard the database into virtual shards, say 12 shards, and put all of them onto the same server node for now.

And when I need to scale out, I could just then get a 2nd server and move 6 of the 12 virtual shard onto the new machines.

Are there any pitfalls with having 12 different databases on 1 machine?

* Can I still run only 1 MySQL instance to support those 12 databases?
* Does having 12 databases result in higher memory usage? How much higher?
* Does this require having 12X as many database connections?
* Any other pitfalls?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Are there any pitfalls with having multiple MySQL databases on 1 server node?
2994
August 27, 2010 02:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.