DDS for database replication PreviousNext
Data Distribution Service (DDS) Forum > DDS FAQ >
Message/Author
Next message Nicolas Estrada  posted on Tuesday, June 09, 2009 - 11:19 am
Hello I'm sort of new to the world of DDS but I am curious on to what would be the best approach in attempting to replicate a relational database using DDS.

From what I understand it is best to limit topics to specific data types and avoid the use of variable sized byte[] yet if I wanted to replicate a database in its entirety does that imply:

- The one topic should be created for each and every table?

- How does one guarantee that the subscriber receive only events when all others present within the database transaction are received as well (In order to avoid referential integrity problems)?

- If the latter isn't possible and it is the transactions which are the samples, does that seem like a good approach?

Any light on this situation and potentially useful QoS patterns would be greatly appreciated ;)

Nicolas
Next message Nicolas Estrada  posted on Thursday, June 11, 2009 - 02:29 pm
Forget my question, I understand more now ;) ("coherent_access")
Back to top
Add Your Message Here
Post:
Username: Posting Information:
This is a private posting area. Only registered users and moderators may post messages here.
Password:
Options: Post as "Anonymous"
Enable HTML code in message
Automatically activate URLs in message
Action: