That should read "Without more information"
A
On 11 Feb, 2011,at 10:15 AM, Aaron Morton <aa...@thelastpickle.com> wrote:
On 11 Feb, 2011,at 10:15 AM, Aaron Morton <aa...@thelastpickle.com> wrote:
With more information I'd say this is not a good idea.
I would suggest looking at why you do the table switch in the MySql version and consider if it's still necessary in the Cassandra version.
Could you use prefixes in your keys that the app knows about and switch those?
Aaron
On 11/02/2011, at 9:56 AM, Karl Hiramoto <k...@hiramoto.org> wrote:
> Hi,
>
> In Mysql I do this pattern and wonder if I could do something similar
> with cassandra.
>
> 1. Live/Production queries always coming into LiveTable
> 2. Build new data with BuildTable
> 3. RENAME TABLE LiveTable TO OldTable, BuildTable To LiveTable
> 4. DROP TABLE OldTable, Goto step #2 building new data set.
>
> Since the RENAME TABLE is an atomic operation and takes only a few ms
> on a 20GB table, The queries on LiveTable are never interrupted. The
> only way i see to so this, with cassandra would be to use ColumnFamily1
> and ColumnFamily2 and switch reads between ColumnFamily1 and
> ColumnFamily2 depending on which is building, and which is live.
> Before i start building a new dataset I would have to delete all the data.
>
> I use cassandra TTLs for a different project, but it wouldn't really
> suit this usage model.
>
> Any good way to do this in cassandra?
>
> Thanks.
>
> Karl
