How to split single Database into multiple Databases

Hello,
I have very large size Mysql database with large number of users and content.
I want to split my single huge Database into multiple Databases.

Please let me know how can i split my database into multiple working databases which work for same single website ?

 

It's a rather complex issue, coding wise. Splitting the databases wouldn't be a problem, you can just do a msql dump and put chunks of tables into different db's. The script would need to be rewritten to connect to all databases and use the right database where appropriate. Are you sure you need to do this, I've ran some rather large databases without issue up to a point (a hundred thousand tables and 7 gigs of data in 1 database, for example). Not that I'd recommend it, but it really takes alot of data to start having problems so long as you have enough memory.

 

I don't think that this is a good idea unless you absolutely have to do it. You're going to introduce complex coding to decide which database to use and where do you stop - do you add another database each 6 months or year?

If it's a performance problem that you're getting then check to see if you've indexed the database correctly.

 

Also you may wish to investigate partitioning - a feature of mysql http://dev.mysql.com/doc/refman/5.1/en/partitioning.html

you can use it to distribute your tables onto separate drives for example, to get better performance.