multi-site hosting with phpWCMS

Charlie · Post by **Charlie** » Mon 9. Feb 2004, 00:14

Hi,

before i start working with phpWCMS there is a big question:
is phpWCMS able to hold more than 1 site on a webserver?

Apache with "virtual host" is probably NOT the problem, but what about the database?

Best regards,

Charlie

frold · Post by **frold** » Mon 9. Feb 2004, 01:31

well you can change the database prefix so you can have unlimted numbers of phpwcms installed

Charlie · Post by **Charlie** » Mon 9. Feb 2004, 13:07

frold wrote:well you can change the database prefix so you can have unlimted numbers of phpwcms installed

Is 1 mysql-database enough for this? (limitation of my hoster...)
Or 1 mysql-db per phpwcms?

Thanks!

pSouper · Post by **pSouper** » Mon 9. Feb 2004, 13:25

you could do it the same way that is offered for multilingual sites...
http://www.phpwcms.de/forum/viewtopic.php?t=287

basically you make each site have it's own structure and use 'alias' to redirect people.

please note that any login can edit any structure so allowing clients login in would NOT be recomended - it's not recomened for any phpwcms at the moment.

frold · Post by **frold** » Mon 9. Feb 2004, 14:38

Charlie wrote:
frold wrote:well you can change the database prefix so you can have unlimted numbers of phpwcms installed
Is 1 mysql-database enough for this? (limitation of my hoster...)
Or 1 mysql-db per phpwcms?

Thanks!

1 database is enough....

pSouper · Post by **pSouper** » Mon 9. Feb 2004, 17:04

i see what frold means now and concur

Post by **Oliver Georgi** » Fri 13. Feb 2004, 08:47

It's not really multi-domain based - so for every SITE you need an own installation - or good shared installation of phpwcms. But every site needs its own set of db tables - but can be stored in only 1 database. I tried to find information about the max tables per database in MySQL - seems that there is no limitation. Maybe your provider is able to set a limit. It's no real waste to have more tables: the smaller the table the faster the application. Use the db prefix to handle multiple installations.

Regards
Oliver