The typical content creation process in for a Drupal site is to have the content creators do so on the production system, because databases are copied down, not up.
I'm working on a module that will be used, as an example, to allow the content creators to work on a staging server, and upon performing any CRUD on content, a transaction will be sent (REST for starters) to the production server, having it perform the same operation.
This is, in part, a response to clients who want to be able to create content on an internal server completely visible to all within the firewall (WITHOUT needing to login, so NOT dependent on publishing status), and when approved, have the content automatically moved to production.
Comments
There are a number of modules
There are a number of modules in this space already that are worth taking a look at if you haven't already:
Thanks for the reply. Well,
Thanks for the reply. Well, the Services module could work, depending on being able to make the trigger a workflow event, but it says 'under heavy development' and hasn't been touched in over a year.
Your module also seems to be close to what is needed, if there is some relationship maintained between the source and destination nodes (not a nid, but a uuid or custom unique id) so that CRUD events can be transmitted and might need a tweaking of the supported workflow. Yours, however, depends on Deploy, and it seems to be undergoing a complete revamping.
Mine approaches it a bit differently. Content CRUD is captured in an intelligent FIFO queue (intelligent in that an update for a node not yet processed as an add removes the add from the queue, or a delete removes an add or update from the queue, etc.), and the queue is processed with thresholds during a cron run much like a mailing list would be.
UUIDs
Yup, it uses UUIDs to track the relationship. (Anything based on Deploy will use UUIDs for this, I think, since the Deploy module depends on the UUID module and relies pretty heavily on it under the hood.)
Deploy works great
I used the deploy module on a recent project to push content from a central content library site out to multiples (10's or 100's) of sites and it worked well.