Multiple Instances on NOP on Same SQL DB
- 9
- 115
- 2/7/2011
- United States
When you setup nopCommerce click on use existing database and enter the instance name of the database you wish to use. Each site should point to the same instance name.
Note that in doing this your users will be restricted to using the same user name across each site as the database will already be populated with the users email address.
You may experience performance issues when running multiple site from a single database instance depending on the number of users across each site that is accessing the database at a single time. There are other issues that may need to be addressed before you commit yourself to using a single database instance across multiple sites.
If you are not familiar with database management I strongly suggest that you create a new instance for each site to reduce any conflicts that arise from running multiple sites from a single database. You will also need to verify that you have enough memory to run each instance. As the databases grow so will your system requirments to maintain max performance.
Note that in doing this your users will be restricted to using the same user name across each site as the database will already be populated with the users email address.
You may experience performance issues when running multiple site from a single database instance depending on the number of users across each site that is accessing the database at a single time. There are other issues that may need to be addressed before you commit yourself to using a single database instance across multiple sites.
If you are not familiar with database management I strongly suggest that you create a new instance for each site to reduce any conflicts that arise from running multiple sites from a single database. You will also need to verify that you have enough memory to run each instance. As the databases grow so will your system requirments to maintain max performance.