English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?

multiple sites with single database
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: multiple sites with single database
#12325
multiple sites with single database 9 Years, 11 Months ago Karma: 0
My requirement is:
The domain will have many sub-domains, The main domain will be the parent site with almost all the information.
the sub-domains will be using the same template and will have content from the main domain.
the sub-domain will be managed by the main domain and will be controlled by a single database,a nd single admin.
the sub-domains will not have admin rights .
Is it possible with this extn.
raunhar
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#12331
Re: multiple sites with single database 9 Years, 11 Months ago Karma: 54
Yes you can do that with JMS.

Just a remark concerning the maximum website that you may store in the same unique DB.
This is not a JMS constrain but a MySQL constrain.

Each MySQL table consume 3 files on the disk.
The maximum number of website that you can store in a same DB is mainly driven by the following formula.

Nb Sites * Nb Tables per site * 3.
This number can not exceed the maximum number of files that can be opened by MySQL simulatnously. This is important if you want to perform a backup of the DB that require to lock the tables.

If a website consume 100 tables and that your maximum open file limit is 15,000 files.
Then the maximum site is = 50 websites.

We do not recommend to setup MySQL with more than 100,000 open file limit.
This will consume memory and time consuming during the backup.
So you should find a tradeoff between the number of DBs and the number of website per DB.

Another solution is to create 1 DB per website that was not the question and that may also have limitation on the number of DB that you can create on a single MySQL server.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla