Log for #openttdcoop.devzone on 13th August 2013:
Times are UTC Toggle Colours
01:36:14  *** Supercheese has joined #openttdcoop.devzone
01:50:03  *** Supercheese has quit IRC
02:08:45  *** Supercheese has joined #openttdcoop.devzone
05:51:14  *** Supercheese has quit IRC
06:07:48  *** Zuu has joined #openttdcoop.devzone
08:12:16  *** Zuu has quit IRC
11:44:01  <Brot6> DACh - Narrow Gauge - Feature #5396: NG sprites XVoyager1X @
14:57:01  *** ODM has joined #openttdcoop.devzone
16:04:48  <Brot6> Grapes - Revision 183:aef9d68b722f: Change: move callback execution into a central place and make it... XdihX @
16:04:48  <Brot6> Berries - Revision 68:87c9ac07233d: Change: comply with changes made to PluginManager XdihX @
16:13:12  *** Alberth has joined #openttdcoop.devzone
16:37:12  *** Jam35 has joined #openttdcoop.devzone
17:06:05  <planetmaker> @op
17:06:17  <planetmaker> @services op
17:06:37  <Alberth> op doesn't like you :)
17:07:29  *** ChanServ sets mode: +o planetmaker
17:07:49  <^Spike^> ? :)
17:08:18  <planetmaker> :-P
17:08:25  <^Spike^> it's not like i'm about to break stuff.....
17:08:28  <^Spike^> oh wait... ;)
17:08:29  *** planetmaker changes topic to "DevZone might be currently unresponsive due to DB maintenance | Talk about things hosted and developed on | Downloads log: | Sandbox passwords are the same as the usernames"
17:08:37  <planetmaker> just wanted... to warn people :D
17:09:38  <Rubidium> doing the same as owen?
17:09:58  <^Spike^> ?
17:10:00  <^Spike^> what
17:10:18  <planetmaker> dunno exactly what owen does. But I don't think so
17:11:02  <^Spike^> me neither... :)
17:11:55  <^Spike^> hmmmm.....
17:13:33  *** Jam35_ has joined #openttdcoop.devzone
17:14:32  <Rubidium> I'd say: see the forum, but it's unbearibly slow
17:14:45  <Rubidium> but... some tidbits of the last few days (including today)
17:14:53  <Rubidium> "I've moved the database back to MyISAM and the old MySQL search index."
17:15:04  *** Jam35 has quit IRC
17:15:08  <Rubidium> "All posts up to post id 121200 have now been indexed"
17:15:21  <Rubidium> "The search indexing is still going, which may slow things down for a bit."
17:15:38  <^Spike^> :)
17:15:46  *** Jam35 has joined #openttdcoop.devzone
17:15:53  <^Spike^> i only try to setup a copy of the DB so we know it works yes/no...
17:15:55  <Rubidium> "I've made some more changes to the database server. If this still doesn't help, I'll see what else can be done."
17:15:56  <^Spike^> not break devzone :)
17:16:05  <^Spike^> wget
17:16:06  <^Spike^> ;)
17:16:18  <^Spike^> helps alot...
17:16:19  <^Spike^> or well
17:16:29  <^Spike^> 2 DB servers... master/master.... 1 read only
17:16:35  <^Spike^> and loadbalance that stuff... :)
17:16:44  <^Spike^> also makes load alot easier on the server...
17:16:54  <^Spike^> if that still breaks... you seriously need a server that can handle IO....
17:17:00  <^Spike^> i recommend FusionIO in that case....
17:17:10  <^Spike^> only costs a few K per card... but SSD on steroids ;)
17:17:34  <^Spike^> as you might notice... i've done alot of these kind of setups in the past 1,5 year :)
17:19:11  <dihedral> ^Spike^, ever had a master/master with mysql
17:19:32  <^Spike^> use it at work for several customers... only 1 node in forced read only for users
17:19:33  <dihedral> that works for small db's but never start carzy queries or else it will miserably fail
17:19:38  <^Spike^> ehm....
17:19:46  <dihedral> that is master/slave
17:19:50  <^Spike^> as said... we use it to create a fail-over scenario
17:19:53  <^Spike^> yes/no
17:19:55  <dihedral> yes
17:19:57  <^Spike^> it's master/master...
17:20:06  <^Spike^> with a global define read_only yes on one side
17:20:10  <^Spike^> the moment we need to fail-over
17:20:11  <dihedral> master master means you can write to any db and it will be synced to the other
17:20:12  <^Spike^> fix LB
17:20:15  <^Spike^> fix node....
17:20:17  <^Spike^> and done...
17:20:27  <^Spike^> the moment your other node comes back it's the slave of the new master and syncs
17:20:38  <^Spike^> i know...
17:20:43  <dihedral> there you have it - master / slave with failover :-)
17:20:45  <^Spike^> :)
17:20:53  <^Spike^> but big dbs?
17:21:02  <dihedral> complex statements
17:21:03  <^Spike^> ehm./.. think got a customer with 50GB db...
17:21:10  <^Spike^> and they make fucked up statements
17:21:14  <dihedral> nah - i mean the real master master
17:21:18  <^Spike^> ah...
17:21:21  <dihedral> active active might be more specific
17:21:31  <^Spike^> well these f***** had a 75GB DB just for caching....
17:21:36  <^Spike^> until we put them on fusionio
17:21:58  <^Spike^> they dropped that "cache" database :D
17:21:59  <dihedral> hehe - ssd helps :-P
17:22:03  <^Spike^> it's not even SSD
17:22:13  <^Spike^> it's even worse..... it's much faster then that :D
17:22:18  <dihedral> if you have enough disks in the stripe it works as well
17:22:22  <dihedral> with SAS
17:22:33  <^Spike^> for this site that wasn't even enough
17:22:37  <^Spike^> they had 4 DB servers
17:22:42  <^Spike^> 1 master 3 slaves
17:22:59  <^Spike^> with christmas.... ehm.... it was hell of a work to keep it running
17:23:04  <^Spike^> i wonder how it will be this year :D
17:23:05  <dihedral> once had a client with a 60GB DB, gave his VM 128 GB and made a tmpfs of 64GB for the db :-D
17:23:12  <dihedral> ran mysql out of a ramdisk :-D
17:23:16  <^Spike^> ......
17:23:23  <dihedral> it worked like a charm
17:23:27  <^Spike^> true it works....
17:23:29  <^Spike^> just don't reboot...
17:23:36  <dihedral> have a background process sync to harddisk
17:23:49  <^Spike^> live sync? ;)
17:23:55  <dihedral> hihi
17:23:59  <^Spike^> so.....
17:24:03  <^Spike^> don't reboot...
17:24:09  <^Spike^> and hoe for no power fails :D
17:24:16  <^Spike^> but back to ruby/gems being a bitch....
17:24:21  <^Spike^> you must install gem...
17:24:24  <^Spike^> ok install....
17:24:27  <^Spike^> run command again
17:24:30  <^Spike^> you must install gem....
17:24:35  <^Spike^> i just installed that thing FFS!!!!
17:24:47  <planetmaker> I'd not call it 'gem' ;-) I call it... something else :-P
17:25:00  <^Spike^> i call it *(#$*(@#&$)(@#$*)_(@#&$*(@#&$*(@#&)$() ruby
17:25:08  <planetmaker> yeah, similar
17:25:19  <^Spike^> i know i have 255 characters... but well it would be repetitive :D
17:25:20  <Alberth> doesn't look like a proper RE :p
17:25:38  <^Spike^> RAILS_ENV=new_postgres rake db:migrate
17:25:41  <^Spike^> all ik want to do....
17:26:02  <^Spike^> i*
17:27:29  <^Spike^> atleast devzone still works
17:27:51  <^Spike^> even worst.... gem list shows it installed.....
17:28:35  <Alberth> lol
17:28:50  <^Spike^> really feels like a talk at work....
17:28:57  <^Spike^> for IT ppl everything has to be logical.....
17:29:03  <^Spike^> the moment it isn't.... they either...
17:29:06  <^Spike^> 1. PANIC!!!!!!
17:29:13  <^Spike^> 2. Ah screw it let's start over
17:29:21  <^Spike^> :)
17:32:45  *** frosch123 has joined #openttdcoop.devzone
17:33:45  <Alberth> hi hi
17:33:56  <^Spike^> say that i'm wrong in that... :)
17:34:38  <Alberth> my reaction is then 3. stop typing, and start thinking about why it happens :)
17:34:54  <^Spike^> well... that's what we tried friday with a loadbalancer.....
17:34:56  <Alberth> but then again, maybe I am not part of  "IT PPL" :)
17:35:15  <^Spike^> it kept showing the wrong server..... every setting was correct up to the IP and everything
17:35:18  <^Spike^> still wrong server....
17:35:23  <Rubidium> oh please... can I have one of those at my work?
17:35:38  <planetmaker> no, I want that one person ;-)
17:35:40  <^Spike^> we remove the external IP completly... start over... exact same settings and it works...
17:35:42  <Alberth> ^Spike^: might have one :)
17:36:04  <^Spike^> dev:~ # gem install adapter-postgres
17:36:04  <^Spike^> ERROR: Error installing adapter-postgres:
17:36:04  <^Spike^> adapter-postgres requires adapter-postgres (>= 0)
17:36:06  <^Spike^> also a fun one
17:36:18  <^Spike^> i start to like ruby more with the minute :D
17:36:22  <Alberth> how useful :)
17:36:40  <^Spike^> do we really need redmine? ;)
17:37:24  <Alberth> do you really want to install another one from scratch? ;)
17:37:45  <^Spike^> ehm.... well if we can switch to something else... ;)
17:39:02  <planetmaker> uhm... if it helps
17:39:25  <planetmaker> that means indeed completely new everything. Still we need to transition projects + issues
17:39:31  <^Spike^> :)
17:39:57  <^Spike^> it's too much to do on 1 night though :D
17:40:09  <^Spike^> as said... tomorrow i have to upgrade/downgrade my friend the loadbalancer(s)
17:40:29  <^Spike^> what could only go wrong next to over 10k sites going down... :)
17:41:05  <planetmaker> that's less important! ;-)
17:41:08  <^Spike^> ;)
17:56:15  <^Spike^> even worse.... i foudn the actual ruby file of that gem....
17:56:17  <^Spike^> it's there ffs
18:16:46  *** ChanServ sets mode: +o ^Spike^
18:16:59  *** ^Spike^ changes topic to "Talk about things hosted and developed on | Downloads log: | Sandbox passwords are the same as the usernames"
18:23:34  <Brot6> Grapes - Revision 184:def1d6fefd0c: Change: method name changed - use it! XdihX @
18:24:47  <^Spike^> dihedral felt safe committing the moment i changed topic... :D
18:29:15  *** Jam35 has quit IRC
18:32:31  *** andythenorth has joined #openttdcoop.devzone
18:35:14  <Alberth> o/
18:35:41  <andythenorth> o/
18:35:48  <^Spike^> \o/
18:39:48  <planetmaker> o
18:39:50  <planetmaker> ;-)
18:40:26  <V453000> o//-f>/
18:57:32  <dihedral> hihi
18:57:38  <dihedral> ^Spike^, i like moving in shadows
18:58:10  <^Spike^> ;)
18:58:19  <^Spike^> /etc/init.d/vz stop
18:58:23  <^Spike^> oh.. wrong screen... ;)
18:58:34  <^Spike^> more of a case of try it now!!! ;)
19:00:03  <dihedral> ... lol?
19:01:29  <^Spike^> basicly if i did that... i killed all containers :D
19:01:31  <^Spike^> try commits then ;)
19:01:35  <^Spike^> to devzone ;)
19:44:07  *** ODM has quit IRC
19:44:30  *** Alberth has left #openttdcoop.devzone
20:46:43  <^Spike^> should devzone respond slower.. SORRY i'm cloning it :)
20:50:32  *** ^Spike^ changes topic to "DevZone MIGHT respond slow/not, Known issue | Talk about things hosted and developed on | Downloads log: | Sandbox passwords are the same as the usernames"
20:51:48  *** ^Spike^ changes topic to "DevZone MIGHT respond slow/not, Known issue. ETA: Blame the server | Talk about things hosted and developed on | Downloads log: | Sandbox passwords are the same as the usernames"
20:53:33  <TWerkhoven> i like your eta
20:53:42  <^Spike^> :D
20:53:51  <^Spike^> i can't help it if copying takes long :)
20:53:55  <^Spike^> out of my power :D
20:54:16  <^Spike^> and well... i really need that clone so...
20:54:19  <TWerkhoven> its done when its done
20:54:26  <^Spike^> :)
20:54:37  <^Spike^> best way to work with it :)
20:54:48  <^Spike^> do it at work all the times with outtages
20:54:56  <^Spike^> alot of customers calling:
20:55:00  <^Spike^> we're working on it
20:55:04  <^Spike^> when will it be fixed!?
20:55:12  <^Spike^> we don't know... but you'll know when we know!
20:55:12  <^Spike^> :D
20:55:17  <TWerkhoven> hehe
20:56:51  <^Spike^> better said all we tell the ppl on the phone: Yes there is an outtage that is all you can tell
20:56:54  <frosch123> get a better coffee machine
20:57:00  <^Spike^> the moment they ask: But what is it
20:57:02  <frosch123> one which gives you an eta when the coffee is ready
20:57:08  <^Spike^> You'll get to know when you NEED to know
20:57:11  <^Spike^> at this time you don't!
20:57:19  <TWerkhoven> 'we dont know either, we're just phonemonkeys'
20:57:24  <TWerkhoven> at least that was my excuse
20:57:26  <^Spike^> that's the idea yeah
20:57:35  <^Spike^> the less they know the less they can tell :)
21:00:36  <^Spike^> not rocket science that is happening is see.....
21:00:47  <^Spike^> cp container containerclone
21:00:55  <^Spike^> even i could've thought of that....
21:34:38  <^Spike^> seems it didn't like the clone action...
21:34:44  <^Spike^> next time i'll do it manually... :D
21:45:34  <^Spike^> i get a feeling i have one choice....
21:45:49  <^Spike^> might aswell update when i do so
21:48:57  <^Spike^> Our servers will need a reboot... might be down for a few minutes

Powered by YARRSTE version: svn-trunk