incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Franc Carter <franc.car...@sirca.org.au>
Subject Re: schema management
Date Wed, 03 Jul 2013 13:08:23 GMT
On Wed, Jul 3, 2013 at 2:06 AM, Silas Smith <silas.smith@gmail.com> wrote:

> Franc,
> We manage our schema through the Astyanax driver. It runs in a listener at
> application startup. We read a self-defined schema version, update the
> schema if needed based on the version number, and then write the new schema
> version number. There is a chance two or more app servers will try to
> update the schema at the same time but in our testing we haven't seen any
> problems result from this even when we forced many servers to all update
> the schema with many different updates at the same time. And besides we
> typically do a rolling restart anyway.
>
> Todd,
> Mutagen Cassandra looks pretty similar to what we're doing, but is perhaps
> a bit more elegant. Will take a look at that now :)
>
> Cheers
>


Thanks all,

I'll likely stick to cassandra-cli scripts for this project and then look
in to Cassandra-Mutagen

cheers


>
>
> On Mon, Jul 1, 2013 at 5:55 PM, Franc Carter <franc.carter@sirca.org.au>wrote:
>
>> On Tue, Jul 2, 2013 at 10:33 AM, Todd Fast <todd@digitalexistence.com>wrote:
>>
>>> Franc--
>>>
>>> I think you will find Mutagen Cassandra very interesting; it is similar
>>> to schema management tools like Flyway for SQL databases:
>>>
>>
>> Oops - forgot to mention in my original email that we will be looking
>> into Mutagen Cassandra in the medium term. I'm after something with a low
>> barrier to entry initially as we are quite time constrained.
>>
>> cheers
>>
>>
>>>
>>> Mutagen Cassandra is a framework (based on Mutagen) that provides schema
>>>> versioning and mutation for Apache Cassandra.
>>>>
>>>> Mutagen is a lightweight framework for applying versioned changes
>>>> (known as mutations) to a resource, in this case a Cassandra schema.
>>>> Mutagen takes into account the resource's existing state and only applies
>>>> changes that haven't yet been applied.
>>>>
>>>> Schema mutation with Mutagen helps you make manageable changes to the
>>>> schema of live Cassandra instances as you update your software, and is
>>>> especially useful when used across development, test, staging, and
>>>> production environments to automatically keep schemas in sync.
>>>
>>>
>>>
>>> https://github.com/toddfast/mutagen-cassandra
>>>
>>> Todd
>>>
>>>
>>> On Mon, Jul 1, 2013 at 5:23 PM, sankalp kohli <kohlisankalp@gmail.com>wrote:
>>>
>>>> You can generate schema through the code. That is also one option.
>>>>
>>>>
>>>> On Mon, Jul 1, 2013 at 4:10 PM, Franc Carter <franc.carter@sirca.org.au
>>>> > wrote:
>>>>
>>>>>
>>>>> Hi,
>>>>>
>>>>> I've been giving some thought to the way we deploy schemas and am
>>>>> looking for something better than out current approach, which is to use
>>>>> cassandra-cli scripts.
>>>>>
>>>>> What do people use for this ?
>>>>>
>>>>> cheers
>>>>>
>>>>> --
>>>>>
>>>>> *Franc Carter* | Systems architect | Sirca Ltd
>>>>>  <marc.zianideferranti@sirca.org.au>
>>>>>
>>>>> franc.carter@sirca.org.au | www.sirca.org.au
>>>>>
>>>>> Tel: +61 2 8355 2514
>>>>>
>>>>> Level 4, 55 Harrington St, The Rocks NSW 2000
>>>>>
>>>>> PO Box H58, Australia Square, Sydney NSW 1215
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>>
>> --
>>
>> *Franc Carter* | Systems architect | Sirca Ltd
>>  <marc.zianideferranti@sirca.org.au>
>>
>> franc.carter@sirca.org.au | www.sirca.org.au
>>
>> Tel: +61 2 8355 2514
>>
>> Level 4, 55 Harrington St, The Rocks NSW 2000
>>
>> PO Box H58, Australia Square, Sydney NSW 1215
>>
>>
>>
>


-- 

*Franc Carter* | Systems architect | Sirca Ltd
 <marc.zianideferranti@sirca.org.au>

franc.carter@sirca.org.au | www.sirca.org.au

Tel: +61 2 8355 2514

Level 4, 55 Harrington St, The Rocks NSW 2000

PO Box H58, Australia Square, Sydney NSW 1215

Mime
View raw message