Forum Moderators: open
I am planning to run a website with xoops cms, with forums, multi-tiered membership, ecommerce, news and archives.
Can anyone be kind enough to let me know:
- how many mysql databases I will need for such a website?
- approx how much space is needed for the databases alone?
- are forums, membership and ecommerce stores and news run on individual tables within a database?
- what are the advatanges of having separate databases?
- is it necessary for all the tables in the database to be linked?
I know that's a lot of questions to unload... typical of a n00b huh LOL
Thank you very much!
You can run everything from one database providing you have the option to make all database table names unique as part of each package you intent to install,
- approx how much space is needed for the databases alone?
The database will grow as your site does. 100MB is a good starting point to expand on. Any more than that means you spending money for space your not using. If your site grows a good host will give you more space.
- are forums, membership and ecommerce stores and news run on individual tables within a database?
yes. most packages all you the option of choosing your table prefix (with phpbb it is phpbb_ by default but you can change it to make sure the package gets unique table names)
If you are sharing a user table between packages you will have to make changes to the packages code.
- what are the advatanges of having separate databases?
it is easier to find things manually.
it is tidier.
if they get large they will query faster.
- is it necessary for all the tables in the database to be linked?
not sure what you mean by linked. you can have two tables in a database that never interact with each other. They are completely seperate.
