You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Is it possible to run more than one site from the same product database - i.e. what happens if more than one process tries to access the database?
Offline
Yes, it is possible. I am setting this up now for a customer. Also remember, that for each store you have that is another CCP license you need. So if you have 3 stores linked to one DB, it will still cost you 3 CCP licenses.
Offline
Yeah I understand that, no problems there. Thanks for the reply.
Offline
Sorry just had another thought..
When you configure the database settings in CCP51, and set a section to, for example, mySQL rather than CSV, doesn't it overwrite what's in that table with what was in the CSV file?
How would I avoid that? Would it be a case of copying a CSV version from the master site, putting it on the new site and THEN setting them both to use mySQL?
Hope that makes sense..
Offline
What you want is one master DB, that each site connects to. Then you use mysql for only those tables you want shared across all the sites, like the products, categories etc.. Then you update those tables from the one site, and it will automatically be reflected in all the other sites.
Does that make sense?
Offline
Yeah but my point is, when you set something to use mySQL in the admin section, it'll overwrite everything currently in that table, will it not?
Offline
If you have multiple carts, using 1 DB, and you only use the DB for thing that each cart shared, like products, categories, etc. And you move the "main" cart from mysql to csv so you can download it, and work on the csv, then convert back to mysql, the other carts will continue to use mysql, when you convert from mysql to csv, it does not wipe out the DB, it only dumps the data into csv files. When you convert back fron csv to mysql, it does not wipe out the csv, but it does overwrite what is in the DB table. And in doing so all the other carts will show the new data.
Does that make sense?
Now, you certainly do not want multiple people trying to manage the DB, from different carts at the same time.
Offline
Yeah I've got ya. So basically to set up the carts for the first time I want to have a CSV dump of the master DB (products/cats), copy them to all the carts and then set them all to use mySQL.
This will cause them to overwrite what was in the DB each time I set CSV -> mySQL, but that doesn't matter as what's being overwritten should be exactly what's already in there.... correct?
Offline
What I have done (in further testing and set up of my carts) is done a smylink (symbolic link) from the additional carts to the main carts table.csv so that they are all controlled from that one table.csv file. In that file it tells the carts whether to use mysql or csv.
I only have product specific tables enabled though mysql. And then when update and convert the product table back and forth between mysql and csv to work on it, once it is back in mysql all the carts will have the updated information.
So far this is working well for us on our multi-cart site.
Offline
Sounds like a cool idea, I'm not too confident with symlinks though, how do you go about setting those up?
Also, if you edit that file individually on each site, CCP won't go through the process of writing to the DB when you click CSV->MySQL in the admin section - is that right? If that's the case, then that would make things a lot simpler.
To do this though, I guess you'd need to set up the mySQL settings using a similar method - is this possible?
Offline
You need SSH access to set up smylinks, so if you do not have that, or are unsure you might want to ask your host to set those up.
A smylinks is like a shortcut, you do not have the file on the other sites, it is just a shortcut to the main sites file.
Offline
One last thing...
To run multiple copies, you mentioned you need multiple licences too. Are these stored as a file in the CCP folder somewhere - or can I literally copy an already configured ccp51 folder from one site to another?
Offline
you need to buy multiple CCP license if you plan to run multiple stores.
Offline
I know that, but when you buy a CCP51, you get given a secure link download the file. Does this need to be downloaded for each store, or can you just pay and then copy the files from the other sites across. Hope that makes sense.
Offline
Thanks dude..
Offline