huge site, multiple databases?

[Paul E]

Hi everybody.

I'm planning to put online a huge site ( or at least, I hope it will behuge someday  , and I was wondering if it was possible to separate the  categories on different databases. That way, in case I need , ie, to migrate a category to another server because of heavy load on the first one, I just export my db and I'm done (more or less).

thank you in advance for your ansewrs,
regards,
Paul

[Nibbler]

Not possible.

[Joachim Müller]

If the servers are yours to operate, there are clustering solutions available for mySQL afaik, which means that you can distribute the database load over different servers, even though this happens without the app (Coppermine) needing modifications. However, if you are on a performant server, your gallery can become pretty huge without the need for a database cluster. There are Coppermine galleries with many thousand users, ten thousands of pics and a high level of activity of users. The file-based part of the gallery usually needs to be performant as well for large sites with a lot of activity.

As Nibbler suggest, there are no mechanisms built into coppermine that allow distributing the database load over various databases.

Joachim

[Paul E]

Thank you very much for your answers.

I'm actually not sure I'll can afford, in a first place, clustering mysql on my own servers :-( .
Anyway, in that kind of figure, could a single instance of coppermine do the trick and deal with huge database (and  loads of requests from users), or is it wise to also divide the load on coppermine creating other instances ?

Another question relative to spliting big dbs:
Are categories tables clearly recognisable in a database so , in case the db gets huge, I could export let's say, one category and import it on antoher database?
That is,  is splitting a big coppermine database easy?
And is it easy to redirecion coppermien to the new db once it's been separated from the original one?

You also speak about sites using coppermine with heavy traffic . Do you have the adresses? I'd like to check live, if possible, the reactivity of the ap.

Many thanks in advance,
regards,
Paul

[Nibbler]

You can't remove a category in that way, that's not how the database works. You can move individual tables to a new database (eg. the comments table) but not a section of the gallery since the information about the category is spread over many tables (albums, pictures, comments, votes, stats, etc.)  You would need a very large and active gallery before you need to start thinking about things like this.

[Joachim Müller]

Why don't you tell us the figures (pics/users/hits) you expect. It's easier to tell for sure. Check the "Share your gallery" thread for existing coppermine sites.