Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
From: Anubhav Kale <Anubhav.Kale@microsoft.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Subject: SS Table File Names not containing GUIDs
Thread-Topic: SS Table File Names not containing GUIDs
Thread-Index: AdGkktktCfQ9tWo0Siu3dRy4KRP91Q==
Date: Mon, 2 May 2016 16:55:37 +0000
Message-ID: <CO2PR00MB0101902997AD4188A2120DE38B790@CO2PR00MB0101.namprd00.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
spamdiagnosticoutput: 1:23
spamdiagnosticmetadata: NSPM
Content-Type: multipart/alternative;
	boundary="_000_CO2PR00MB0101902997AD4188A2120DE38B790CO2PR00MB0101namp_"
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-originalarrivaltime: 02 May 2016 16:55:37.3698
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 72f988bf-86f1-41af-91ab-2d7cd011db47
X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO2PR00MB0101
archived-at: Mon, 02 May 2016 16:55:48 -0000

--_000_CO2PR00MB0101902997AD4188A2120DE38B790CO2PR00MB0101namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

I am wondering if there is any reason as to why the SS Table format doesn't=
 have a GUID. As far as I can tell, the incrementing number isn't really us=
ed for any special purpose in code, and having a unique name for the file s=
eems to be a better thing, in general.

Specifically, this causes some inconvenience when restoring snapshots. Idea=
lly, I would like to restore just the system* keyspaces and boot the node. =
Then, once the node is taking live traffic copy the SS Tables over and do a=
 DSE restart at the end to load old data.

The problem is it is possible to overwrite new data with old files if the f=
ile names match. I can't change the file names of snapshot-ed file to a hug=
e number, because as soon as that file is copied over, C* will use that num=
ber in its get-next-number-gen logic potentially causing the same problem f=
or the next snapshot-ed file.

How do people usually tackle this ? Is there some easy solution that I am n=
ot seeing ?

Thanks !

--_000_CO2PR00MB0101902997AD4188A2120DE38B790CO2PR00MB0101namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I am wondering if there is any reason as to why the =
SS Table format doesn&#8217;t have a GUID. As far as I can tell, the increm=
enting number isn&#8217;t really used for any special purpose in code, and =
having a unique name for the file seems to be
 a better thing, in general.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Specifically, this causes some inconvenience when re=
storing snapshots. Ideally, I would like to restore just the system* keyspa=
ces and boot the node. Then, once the node is taking live traffic copy the =
SS Tables over and do a DSE restart
 at the end to load old data.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">The problem is it is possible to overwrite new data =
with old files if the file names match. I can&#8217;t change the file names=
 of snapshot-ed file to a huge number, because as soon as that file is copi=
ed over, C* will use that number in its
 get-next-number-gen logic potentially causing the same problem for the nex=
t snapshot-ed file.
<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">How do people usually tackle this ? Is there some ea=
sy solution that I am not seeing ?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks !<o:p></o:p></p>
</div>
</body>
</html>

--_000_CO2PR00MB0101902997AD4188A2120DE38B790CO2PR00MB0101namp_--