CockroachDB 20.1

#1

Post by dilloc » Tue, May 12, 2020, 12:43 PM UTC

Re: CockroachDB 20.1

#2

Post by tyingq » Tue, May 12, 2020, 2:20 PM UTC

Looking at the product comparison chart[1], there's quite a lot of features that aren't in the open source "core" CockroachDB. That's fine of course, but the one that seems concerning is the backup/restore. Is there a reasonable and reliable way to do backups and restores with just the "core" open source product?

[1] https://www.cockroachlabs.com/compare/

Re: CockroachDB 20.1

#3

Post by ithkuil » Tue, May 12, 2020, 2:21 PM UTC

I see an untrusted cert: "Issued by: allot.com/emailAddress=info@allot.com". Am I the only one?

EDIT: https://www.allot.com/service-providers/url-traffic-filterin...; still not sure if it's on my side, or if the CDN (netlify in this case) is applying this to some regions (I'm in EU)

Re: CockroachDB 20.1

#4

Post by kkirsche » Tue, May 12, 2020, 2:29 PM UTC

ithkuil wrote: post #3

I see an untrusted cert: "Issued by: allot.com/emailAddress=info@allot.com". Am I the only one? EDIT: https://www.allot.com/service-providers/url-traffic-filterin... ; still not sure if it's on my side, or if the CDN (netlify in this case) is applying this to some regions (I'm in EU)

Yes, I see a trusted let’s encrypt cert

Re: CockroachDB 20.1

#5

Post by tyingq » Tue, May 12, 2020, 2:30 PM UTC

ithkuil wrote: post #3

I see an untrusted cert: "Issued by: allot.com/emailAddress=info@allot.com". Am I the only one? EDIT: https://www.allot.com/service-providers/url-traffic-filterin... ; still not sure if it's on my side, or if the CDN (netlify in this case) is applying this to some regions (I'm in EU)

Looks okay on ssllabs: https://www.ssllabs.com/ssltest/analyze.html?d=www.cockroach...

Re: CockroachDB 20.1

#6

Post by shawabawa3 » Tue, May 12, 2020, 2:32 PM UTC

tyingq wrote: post #2

Looking at the product comparison chart[1], there's quite a lot of features that aren't in the open source "core" CockroachDB. That's fine of course, but the one that seems concerning is the backup/restore. Is there a reasonable and reliable way to do backups and restores with just the "core" open source product? [1] https://www.cockroachlabs.com/compare/

I may be misremembering but I'm pretty sure you can backup like any postgres database with e.g. pg_dump

I think the premium distributed backup/restore thing is for backing up separate regional clusters individually

edit: looks like the premium option is a nice "BACKUP" command that handles uploading or downloading from cloud storage (e.g. s3) automatically. but for free you get "cockroach dump" which is similar to pg_dump

Re: CockroachDB 20.1

#7

Post by gigatexal » Tue, May 12, 2020, 2:33 PM UTC

Online primary key migrations is some interesting voodoo.

We ran it in production from the v2.x days before they moved to a new versioning schema and the support was really good. The paid support is worth the enterprise license.

It's also good to see the added work on supporting ORMs for shops that use it. We used SQLAlchemy heavily and had to do a lot of work to fix our app to work around the transaction retry errors which CRDB has been working on lessening in recent releases.

Re: CockroachDB 20.1

#8

Post by pritambaral » Tue, May 12, 2020, 2:35 PM UTC

tyingq wrote: post #2

Looking at the product comparison chart[1], there's quite a lot of features that aren't in the open source "core" CockroachDB. That's fine of course, but the one that seems concerning is the backup/restore. Is there a reasonable and reliable way to do backups and restores with just the "core" open source product? [1] https://www.cockroachlabs.com/compare/

Is that still open source? Didn't they change to the BSL?

Re: CockroachDB 20.1

#9

Post by corobo » Tue, May 12, 2020, 2:43 PM UTC

ithkuil wrote: post #3

I see an untrusted cert: "Issued by: allot.com/emailAddress=info@allot.com". Am I the only one? EDIT: https://www.allot.com/service-providers/url-traffic-filterin... ; still not sure if it's on my side, or if the CDN (netlify in this case) is applying this to some regions (I'm in EU)

Sounds like something's intercepting your connection.

I would imagine, but don't necessarily recommend, if you allowed the connection anyway you'd get a blocked page from your firewall service

Re: CockroachDB 20.1

#10

Post by cpach » Tue, May 12, 2020, 3:14 PM UTC

ithkuil wrote: post #3

I see an untrusted cert: "Issued by: allot.com/emailAddress=info@allot.com". Am I the only one? EDIT: https://www.allot.com/service-providers/url-traffic-filterin... ; still not sure if it's on my side, or if the CDN (netlify in this case) is applying this to some regions (I'm in EU)

I don’t see that. If your on your work network, it could be your employer’s security system that is intercepting your connection.

A possible explanation could be that the domain cockroachlabs.com is not yet categorized in the security system.