heads-up: are you using MySQL (or other DBMS)?

77 views
Skip to first unread message

Mathieu Lonjaret

unread,
Jan 4, 2018, 10:48:02 AM1/4/18
to camli...@googlegroups.com
Hi,

as of rev 7eda9fd5027fda88166d6c03b6490cffbf2de5fb
(https://github.com/camlistore/camlistore/commit/7eda9fd5027fda88166d6c03b6490cffbf2de5fb),
the default names of the various databases used by Perkeep change.
That basically means:

1) if you were using dbNames (not dbname), to set your "index"
database name, then it concerns you.
2) if you were using dbNames for the other "secondary" indexes and
queues then your are affected, but it's maybe not as important.
3) If you are running a Camli/Perkeep instance on GCE, deployed with
the launcher, you fall into case 1) (and case 2) as well).

We probably need to think about a transition patch to help users
migrate at least their index database, or at the very least warn them.

But to figure out how much effort we have to put into this, it would
help to know how many among you are affected.

So, if you are either running Perkeep in production with a DBMS
(MySQL, PostgreSQL, MongoDB), or running an instance from the GCE
launcher, could you please let us know?

Feel free to forward this to friends who are not on the mailing-list too.

Thanks.

Brad Fitzpatrick

unread,
Jan 4, 2018, 11:34:17 AM1/4/18
to camli...@googlegroups.com
We should at least fix the launcher case, which should be easy. We can special-case that, detecting we're a launcher config and changing the automatic config it builds at startup to use the old db names.



--
You received this message because you are subscribed to the Google Groups "Camlistore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to camlistore+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Mathieu Lonjaret

unread,
Jan 4, 2018, 11:37:22 AM1/4/18
to camli...@googlegroups.com
yeah, will do.
>> email to camlistore+...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Camlistore" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to camlistore+...@googlegroups.com.

Will Norris

unread,
Jan 4, 2018, 11:43:34 AM1/4/18
to camlistore
I'm using perkeep in production with MySQL, though I'm not using dbNames, just dbname.

You mentioned migrating the index database... wouldn't it be sufficient to simply rebuild the index and not worry about migrating?  Or are you specifically trying to avoid users having to do that?

yeah, will do.

>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Camlistore" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Camlistore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to camlistore+unsubscribe@googlegroups.com.

Mathieu Lonjaret

unread,
Jan 4, 2018, 11:49:29 AM1/4/18
to camli...@googlegroups.com
On 4 January 2018 at 17:42, Will Norris <wi...@willnorris.com> wrote:
> I'm using perkeep in production with MySQL, though I'm not using dbNames,
> just dbname.

Cool, thanks.

> You mentioned migrating the index database... wouldn't it be sufficient to
> simply rebuild the index and not worry about migrating? Or are you
> specifically trying to avoid users having to do that?

Yeah, migrating in a vague sense for now. i.e. in your case, making
sure the index gets rebuilt. and also probably that the old
database(s) get wiped, so as not to needlessly waste space?

I assume people running their own instance with MySQL know how to deal
with that, so the priority is to at least alert them about it.
The main priority is to make it as automatic as possible for GCE
users, who are not supposed to touch their MySQL manually.
>> >> email to camlistore+...@googlegroups.com.
>> >> For more options, visit https://groups.google.com/d/optout.
>> >
>> >
>> > --
>> > You received this message because you are subscribed to the Google
>> > Groups
>> > "Camlistore" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> > an
>> > email to camlistore+...@googlegroups.com.
>> > For more options, visit https://groups.google.com/d/optout.
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Camlistore" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to camlistore+...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Camlistore" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to camlistore+...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages