Time Nick Message 12:47 pdurbin hmm. need to monitor mysql replication. in the past, we've checked Seconds_Behind_Master by running SHOW SLAVE STATUS \G . maybe there's a better way... 13:04 ventz is this in a mysql cluster 13:04 ventz or just some manual hack? :) 13:04 pdurbin well 13:05 pdurbin it's a simply master/slave relationship, i think... 13:05 pdurbin i didn't set up the replication. but that's my understanding 13:05 pdurbin i'm just thinking about monitoring the replication 13:05 ventz funny you mentioned this today, i am trying to build a new mysql solutikon here and i don't want to create another cluster (as for FAS -- seems an overkill for security) so trying to figure out a good way to do it 13:06 ventz i am thinking a cron that just does a mysqldump and imports on a dedicated "fail safe" system 13:06 pdurbin huh. dump and import? why not use master/slave replication? 13:06 SEJeff pdurbin, For anything mysql, you can't go wrong with percona. They *wrote* the High Performance MySQL book 13:06 SEJeff Yeah mysqldump doesn't make sense for that 13:07 SEJeff http://www.percona.com/doc/percona-monitoring-plugins/nagios/pmp-check-mysql-replication-running.html 13:08 pdurbin SEJeff: that pmp-check-mysql-replication-running nagios plugin looks pretty good. thanks! 13:08 SEJeff pdurbin, And the percona guys are the real deal. We had them come here for some mysql tuning and increased insert throughput almost a perfect 2x 13:09 SEJeff http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/0596101716 Baron Schwartz is one of the Percona founders 13:09 pdurbin SEJeff: cool. but i don't need to hire them do i? i can just use their nagios plugin, right? 13:09 ventz SEJeff: for us, it's just for a redundant site though 13:10 SEJeff pdurbin, Right. I'm just pointing out, they are legit 13:10 SEJeff I can say from experience they are 13:10 pdurbin ok 13:11 pdurbin ventz: i'm still wondering if you have something against mysql replication :) 13:11 SEJeff pdurbin, http://www.percona.com/doc/percona-monitoring-plugins/index.html 13:12 ventz i saw iffy results with it a while ago, but i think it has greatly improved since 13:13 SEJeff Yeah a long time ago. Not the case more recently 13:13 pdurbin ventz: ok. mysql replication has a tendency to fall over, in my experience (rhel 5, mostly). there's a reason i'm interested in monitoring it! :) 13:14 pdurbin kind of a pain to reinitialize the mysql slaves when replication gets pretty broken 13:18 pdurbin SEJeff: yum! "You can download the Percona Monitoring Plugins from the Percona Software Downloads directory, including our APT and Yum repositories" 13:20 SEJeff :) 13:20 SEJeff Glad to share some fu with you 13:21 pdurbin glad to be back :) 13:21 pdurbin you guys can feel free to talk amongst yourselves when i'm on vacation ;) 13:24 SEJeff heh 13:24 SEJeff I'll be moving to another big city in the 2nd week of July 13:24 SEJeff might be quiet then 13:26 pdurbin how dare you 13:30 shuff vacation? 13:46 pdurbin shuff: see my "phil durbin" google plus posts for pictures and such 13:47 pdurbin actually, i can't help linking to this one. :) Phil Durbin - Google+ - castle and throne - https://plus.google.com/109940583958656614840/posts/LTgDzpxRWMo 13:50 shuff !!! 13:50 shuff outstanding 13:51 pdurbin :) 13:54 SEJeff Is your throne made of real porcelain? That looks really nice 13:55 pdurbin SEJeff: you'd have to ask the owner of the inn, but yes, i believe it was porcelain 13:56 SEJeff looks like you had some fun 13:56 SEJeff I've not had a chance to put pics online, but was in Cabo, Mexico for 7 days 13:56 pdurbin yep. the kids too 13:56 pdurbin cool 14:48 pdurbin westmaas: is this true? "AFAIK you cannot use Swift storage as a Nova volume backend" -- [CentOS-virt] Basic shared storage + KVM - http://lists.centos.org/pipermail/centos-virt/2012-June/002943.html 14:51 westmaas pdurbin: hm, I'm not 100% sure on that. let me ask around. 14:52 pdurbin westmaas: thanks. i thought the point of swift was that it would take away all my storage problems. :) that swift would handle all the scaling for me 14:54 westmaas all your object storage 14:54 westmaas not necessarily block storage 14:54 westmaas but at the same time, I can't imagine this not being a goal 14:55 pdurbin well, i thought the vm images were abstracted away into objects or whatever 14:55 pdurbin i need to do some reading, obviously 14:55 westmaas yeah, the projects aren't tied that closely together yet. 14:56 pdurbin bummer 14:56 pdurbin agoddard had a great internal reply to that centos-virt thread. about iSCSI options 14:57 pdurbin i don 14:57 pdurbin 't see him online but i'll have to ask if he minds if i copy and paste his reply back to the list 17:35 pdurbin shuff: some guy is writing an API for RackTables! [racktables-users] writing a restful API in php for Racktables - racktables-users - FreeLists - http://www.freelists.org/post/racktables-users/writing-a-restful-API-in-php-for-Racktables 17:35 shuff neat! 17:35 pdurbin i updated my post to link to this new thread: https://projects.cs50.net/project/97/build-a-restful-api-for-racktables-at-philip-durbin/