Posted by kdineshbe on October 29, 2010 at 11:30am
I am running two drupal sites ( 2 databases), one for data entry and another as portal.
Now the problem is whenever a content is published from data entry site, the content has to be copied to portal site.
I tried xmlrpc and servies module. i am getting not well formed error. also i read if file fileds are used, it is complex to port.
Need Guidance ...
Thanks
Comments
Redundancy of data is not recommended in Drupal
Hi
You should not keep redundant data in your websites. If you want you can use the shared tables concept(See your settings.php for instructions) and share your node, content tables so that both the websites will be able to access the content.
Siva Kumar Epari
I too planned for shared but
I too planned for shared table concepts, but, the site will be having 10 - 15 lakhs hits regularly and in some occasions it is upto 25lakhs. So i planned to have separate databases (not to disturb cms and portal part)
Enable caching
Are you having the two websites in different servers? If not and you are planning for 25 lakh hits, then you should have implemented caching techniques(memcache, varnish, increasing etc.). So no worries for using common tables.
If at all, what you can do is create a 3rd database and keep the node, content type tables in that 3rd database and prefix accordingly in the settings.php file. So you can isolate content from cms configurations.
Siva Kumar Epari
try MySQL Clustering or MySQL
try MySQL Clustering or MySQL replication if you can... that I hope will solve your problem....
Technical Lead,
TCS