New to the community? Start here

Can number of databases be increased? Multi DB

I have a project that I hope will result in thousands of blogs.

If I install multi-db with 256 databases and the number of blogs ends up going above 100 000 can I then increase the number of db’s to 4096?

Wed, 24 Nov 2010 9:09:48
  • drmike
    • DEV MAN’s Mascot

    Not easily I;m afraid. Folks have hacked the moveblogs.php file to look at each of the 256 databases one at a time, and move them into their 4096 databases but I don;t recall anyone giving up their code.

    256 should actually support about a million blogs I thought. Too early to do the math.

  • jozwikjp
    • The Incredible Code Injector

    If you are on a ntfs partition you should be able to move all the tables into one database folder.

    Then split them again..

    if you are on a ext3 partition I think you might hit a directory structure limit..

    I am also looking at this..

    I know eventually we are going to surpass 100,000 blogs. Likely within a year.. So I am thinking of doing this before it become a nightmare.

    You could also do a mysql dump then use a text editor to go through it and update the queries to put them all in a different database..

    If you can’t take you db server down for awhile. Hot copying innodb tables can prove to be quite problematic.