I am using Magento CE 1.7. and I need it to write in multiple database.
> We will first copy the whole Magento database and paste it in the new database (in a new cpanel account).
> We need to write in the 2nd database too when there is something added in the 1st database through Magento i.e., maintain both db together.
> We do not need to read from 2nd database. Only write.
1st Database = Magento's current db
2nd Database = New database
This is a post I created related to this topic and received some replies which might help you complete the project quickly: