We are using EC2 and RDS( MySQL ) in AWS cloud. Planning to use Amazon CloudSearch for full text search. It looks like, we need to send the data to CloudSearch whenever we add a new row in MySQL. Its a kind of 2 operation to keep CloudSearch in sync with RDS. One to add a row to RDS and a second operation to add the same data( of course in a different format ) to CloudSearch. Please suggest me if there is any other good approach.
I am looking for good materials and working example for AWS java api to add, a doc to cloudsearch and update/delete a doc whenever there is an update to RDS.
Thanks, Baskar.S
Nikhil is halfway there. In the code where your data is CRUD'd you add the analogous calls to cloudsearch, but both of these statements need to be wrapped in a transactional context. This basically ensures that if one fails, they both fail. Without this you can never guarantee synchronization.
Frameworks such as Spring and Rails provide this functionality, but you haven't stated what you're using.