Re: restoring from snapshot - missing data
On Mon, May 21, 2012 at 12:01 AM, Tamar Fraenkel ta...@tok-media.comwrote: If I am putting the snapshots on a clean ring, I need to first create the data model? Yes. -- Tyler Hobbs DataStax http://datastax.com/
Re: restoring from snapshot - missing data
Thanks. After creating the data model and matching the correct snapshot with the correct new node (same token) all worked fine! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, May 21, 2012 at 9:06 PM, Tyler Hobbs ty...@datastax.com wrote: On Mon, May 21, 2012 at 12:01 AM, Tamar Fraenkel ta...@tok-media.comwrote: If I am putting the snapshots on a clean ring, I need to first create the data model? Yes. -- Tyler Hobbs DataStax http://datastax.com/ tokLogo.png
restoring from snapshot - missing data
Hi! I am testing backup and restore. I created the restore using parallel ssh on all 3 nodes. I created a new 3 ring setup and used the snapshot to test recover. Snapshot from every original node went to one of the new nodes. When I compare the content of the data dir it seems that all files from the original cluster exist on the backup cluster. *But* when I do some cqlsh queries it seems as though about 1/3 of my data is missing. Any idea what could be the issue? I thought that snapshot flushes all in-memory writes to disk, so it can't be that some data was not on the original snapshot. Help is much appreciated, Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 tokLogo.png
Re: restoring from snapshot - missing data
Did you use the same tokens for the nodes in both clusters? On Sun, May 20, 2012 at 1:25 PM, Tamar Fraenkel ta...@tok-media.com wrote: Hi! I am testing backup and restore. I created the restore using parallel ssh on all 3 nodes. I created a new 3 ring setup and used the snapshot to test recover. Snapshot from every original node went to one of the new nodes. When I compare the content of the data dir it seems that all files from the original cluster exist on the backup cluster. *But* when I do some cqlsh queries it seems as though about 1/3 of my data is missing. Any idea what could be the issue? I thought that snapshot flushes all in-memory writes to disk, so it can't be that some data was not on the original snapshot. Help is much appreciated, Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 -- Tyler Hobbs DataStax http://datastax.com/ tokLogo.png
Re: restoring from snapshot - missing data
Thanks. Just figured out yesterday that I switched the snapshots mixing the tokens. Will try again today. And another question. If I am putting the snapshots on a clean ring, I need to first create the data model? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, May 21, 2012 at 1:44 AM, Tyler Hobbs ty...@datastax.com wrote: Did you use the same tokens for the nodes in both clusters? On Sun, May 20, 2012 at 1:25 PM, Tamar Fraenkel ta...@tok-media.comwrote: Hi! I am testing backup and restore. I created the restore using parallel ssh on all 3 nodes. I created a new 3 ring setup and used the snapshot to test recover. Snapshot from every original node went to one of the new nodes. When I compare the content of the data dir it seems that all files from the original cluster exist on the backup cluster. *But* when I do some cqlsh queries it seems as though about 1/3 of my data is missing. Any idea what could be the issue? I thought that snapshot flushes all in-memory writes to disk, so it can't be that some data was not on the original snapshot. Help is much appreciated, Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 -- Tyler Hobbs DataStax http://datastax.com/ tokLogo.pngtokLogo.png