We are working in website and integrating the Drupal Commerce in our website. We are also adding multiple product per product display to allow user to select products while adding product to cart.
The website will have large data set with more than 10 million product display (node) and more than 30 million products (drupal commerce).
We have also integrated apache solr with search api and allowing user to keyword search and filtering the search result.
Can anyone suggest that if we would stored such large data into single database, will it effect our performance or we need to stored data into 'master/slave' concept of database?
As we have large dataset, so we are preparing architecture of our database, so it would not effect performance of our website.