#metabrainz

On the opposite, we should have a common “artwork” entity.

we can't backup the DB without dropping them. not enough disk space.

hmm, I seem to remember one

we just need to ensure that none of the tables are still in use.

gcilou: Also, the event icon should probably be simpler.

MBS-384

Sorry, MBH-384.

(That one has at least three different grays + the orange.)

thanks

it was mentioned in the postgres upgrade doc too, sans ticket #

where are the old icons stored?

In the musicbrainz-server repository.

...

I'll add MBH-384 to the schema fix version too

the url

Freso, yes I will find another for events

I don't have the URL handy.

static/images somewhere, probably.

^ CatQuest

cheer gcilou

ruaok: what day do we typically do the schema changes on?

the closest monday to the 15th.

"static/images" somewhere indeed. :)

so, in this case the 16th, IIRC. I mentioned it in the blog post about postgres

bitmap ruaok: The 16th.

ok :)

https://raw.githubusercontent.com/metabrainz/mu... this is annoying

Leftmost: Re: schema change ticket, ruaok may decide that we only do one 2016 schema change again, so unless you think it should be pushed back one more year, getting it done for this round is the safe bet. :)

CatQuest: http://musicbrainz.org/static/images/entity/lab... and the like should work

hmm. can't assign MBS versions to MBH tickets

bitmap: move the ticket to MBS.

it really should be there anyway.

and still http://musicbrainz.org/static/images/entity/ is forbidden

k

trying to be able to wget it maybe

Freso: if we don't spend months and months cleaning up after the schema change, then there will be a second one.

nope

ruaok: I didn't say it would be so, I just said it might be so. We'll see. :)

CatQuest: There's a magic flag you can give to wget to make it disregard robots.txt.

yea.. I don't remember that tho :/

You could also "just" git clone musicbrainz-server and copy the entire directory from there.

Sure, it might take a while to clone mb-s, but you'd be sure to get all of the images and not forgetting a random one.

Freso, okay. I should be able to do it for this round.

bitmap: ^

CatQuest: http://reosarevok.mbsandbox.org/static/images/i...

hm?

wow, thanks reo!

CatQuest: But also, even when new icons get pushed to musicbrainz-server, the old icons will still be available in the history of the Git repository, so you can always access them in the future too.

CatQuest: let me know if you got them and it worked so I can remove the file again :)

reosarevok: sure:)

reosarevok: about InfluxDB, i was looking for an alternative to the whisperdb used by graphite. We currently have issues because this database requires a lot of write access, and this resource is limited on any server, so we can't increase too much for number of stored points (each point being something like value + timestamp + a name,

collectd.astro.net.eth0.tx.bytes 12345 <time>).

thanks reo; it worked

we are currently using mostly collectd > carbon relay > carbon > whisper > graphite > grafana, and since grafana has direct support for influxdb queries (a kind of SQL for time series), i'm moving to collectd > influxdb > grafana

CatQuest: :)

That sounds like an improvement, yes :)

Leftmost: is there a schema change ticket you're working on?

InfluxDB has got a lot of attention recently, very active developpement, and tons of nice features coming, and it is very fast compared to whisper, so we'll be able to store more stats. In the future i would like most of our apps or services reporting stats so we can more easily evaluate the impact of changes on the whole system.

zas: that actually looks useful for an IoT data storage thing I'm working on atm, thanks :P

I already and heavily used existing stats, and discovered and eventually fixed multiple performance or reliability issues.

http://tickets.musicbrainz.org/browse/MBS/fixfo... (chirlu`, feel free to assign tickets to yourself, I didn't want to in case you weren't sure about some of them)

and "MBS-xxxx Change how relationships are represented in the database" isn't in there, not sure what that is exactly yet :)

bitmap: http://tickets.musicbrainz.org/browse/MBS-6024

For Leftmost's schema change ticket.

ah, thanks

(Leftmost already had a PR open and doesn't have any other schema change tickets on his plate, so I hope it'll be doable for him. :))

gcilou: Maybe make a "large group" one? ~10 person icons?

yeah..would look mumbo jumbo at a small size thou

though rather

A quartet should suffice :P

for orchestra? https://usercontent.irccloud-cdn.com/file/rpnKX...

heh "director-of-music-icon"

Leo_Verto: but a quartet is not an orchestra! :p

hey that's what it downloaded itself as

(as in, it specifically uses the "group" type :p)

ah

omgomg perfect for choir hahah https://usercontent.irccloud-cdn.com/file/maifX...

Alllright. Here they are https://drive.google.com/open?id=0Byp7nf37UdryL...

That eyes one is kind of creepy.

Remember to keep track of creators and licenses.

yes I know that's why I was joking ;)) ok

I'm not sure the label one really works.

hm okay. what would you suggest?

could add a record to the building

Would the releases work without the "shine"?

RG one probably wouldn't. :/

I could find different cds

I like that the area one is mostly showing ocean. :)

yeah it's not centered over a certain area :)

Yep.

Well, it is.

well land area at least

Just not an area under any nation's sovereignity.

inhabitable area