Thursday, 2014-08-14

SlickNikglucas: I found out what the issue was.00:05
SlickNikglucas: I was running into another timing condition.00:06
SlickNikglucas: Basically the timeout for instance-create (400s) was not high enough for the restore to happen successfully in my environment00:06
glucasOh?00:07
SlickNikglucas: Which meant that the attach_replication_slave message was being sent to the guest too early (before the prepare call had had a chance to finish).00:07
glucasSlickNik: ah, ok00:08
SlickNikAnd since prepare hadn't finished, the access for os_admin hadn't been set up correctly yet00:08
glucasSlickNik: Right - that makes sense.00:08
glucasSlickNik: So for now is increasing timeouts sufficient?00:09
*** nosnos has joined #openstack-trove00:11
*** julienvey has joined #openstack-trove00:18
openstackgerritAuston McReynolds proposed a change to openstack/trove: Clusters API Implementation  https://review.openstack.org/11367500:21
SlickNikglucas: it probably makes sense to have a different (higher) timeout for a create based on a backup (i.e. the restore scenario).00:22
SlickNikI can't think of many real DBs you'd be able to restore within 5 mins.00:23
*** julienvey has quit IRC00:23
SlickNik(given that the prepare call itself also has some overhead)00:23
glucasYeah.00:23
*** eguz has joined #openstack-trove00:24
*** eguz has quit IRC00:24
SlickNikhttps://bugs.launchpad.net/trove/+bug/1356645 filed00:26
*** johnma has quit IRC00:26
glucasCool. And thanks for the follow up.00:27
*** eghobo has quit IRC00:28
glucasCreating a slave may need even more time since it has to both backup and restore.00:30
*** boblebauce has quit IRC00:36
*** boblebauce has joined #openstack-trove00:36
*** boblebauce has joined #openstack-trove00:37
*** boblebauce has quit IRC00:38
*** boblebauce has joined #openstack-trove00:39
*** boblebauce has joined #openstack-trove00:39
*** boblebauce has joined #openstack-trove00:39
*** boblebauce has joined #openstack-trove00:40
*** boblebauce has joined #openstack-trove00:40
*** boblebauce has joined #openstack-trove00:41
*** rwsu has quit IRC00:42
*** achampion has joined #openstack-trove00:44
*** nosnos has quit IRC00:46
openstackgerritAuston McReynolds proposed a change to openstack/trove: Clusters TaskManager Implementation  https://review.openstack.org/11369200:46
*** IanGovett has joined #openstack-trove00:47
openstackgerritRamashri Umale proposed a change to openstack/trove: Clusters Guest Implementation  https://review.openstack.org/11372800:48
*** IanGovett has quit IRC00:50
*** IanGovett has joined #openstack-trove00:53
*** rwsu has joined #openstack-trove00:55
*** IanGovett has quit IRC00:55
*** rwsu has quit IRC00:57
*** rwsu has joined #openstack-trove00:57
*** saurabhs has quit IRC00:58
*** eghobo has joined #openstack-trove01:02
openstackgerritNikhil Manchanda proposed a change to openstack/trove: Look up trove instance by ID instead of name  https://review.openstack.org/11409501:05
*** eghobo has quit IRC01:07
*** amcrn has quit IRC01:10
*** Krast has quit IRC01:17
*** Krast has joined #openstack-trove01:17
*** demorris has joined #openstack-trove01:19
*** julienvey has joined #openstack-trove01:19
*** julienvey has quit IRC01:24
openstackgerritRamashri Umale proposed a change to openstack/trove: Unit tests for clusters guest code  https://review.openstack.org/11409601:28
*** tvoran has quit IRC01:28
*** annashen has quit IRC01:32
*** Riddhi has quit IRC01:34
*** Riddhi has joined #openstack-trove01:37
*** nosnos has joined #openstack-trove01:38
*** ramashri has quit IRC01:38
*** haomaiw__ has quit IRC01:53
*** haomaiwang has joined #openstack-trove01:53
*** rushiagr_away is now known as rushiagr02:11
*** julienvey has joined #openstack-trove02:20
*** ramishra has joined #openstack-trove02:20
*** jcru has quit IRC02:23
*** julienvey has quit IRC02:25
*** rushiagr is now known as rushiagr_away02:30
*** jdonalds has joined #openstack-trove02:35
*** ramashri has joined #openstack-trove02:38
*** haomaiw__ has joined #openstack-trove02:40
*** Riddhi has quit IRC02:42
*** ramashri has quit IRC02:42
*** haomaiwang has quit IRC02:44
*** ramashri has joined #openstack-trove02:46
*** annashen has joined #openstack-trove02:48
*** demorris has quit IRC02:48
*** ViswaV_ has joined #openstack-trove02:59
openstackgerritRamashri Umale proposed a change to openstack/trove: Unit tests for clusters guest code  https://review.openstack.org/11409602:59
*** ramishra has quit IRC03:00
*** ramishra has joined #openstack-trove03:01
*** ViswaV has quit IRC03:03
*** tylerhannan has quit IRC03:07
*** tylerhannan has joined #openstack-trove03:07
*** ramashri has quit IRC03:17
*** julienvey has joined #openstack-trove03:21
*** julienvey has quit IRC03:25
*** Barker has joined #openstack-trove03:26
*** ViswaV_ has quit IRC03:30
*** nosnos has quit IRC03:32
*** jdonalds has quit IRC03:51
*** erik_x1 has joined #openstack-trove03:51
*** dloi_ has quit IRC03:52
*** radez_g0n3 has quit IRC03:52
*** coolsvap has quit IRC03:52
*** erik_x1_ has quit IRC03:52
*** peterstac has quit IRC03:52
*** jdonalds has joined #openstack-trove03:53
*** peterstac has joined #openstack-trove03:53
*** dloi has joined #openstack-trove03:53
*** radez_g0n3 has joined #openstack-trove03:53
*** jdonalds has quit IRC03:59
*** nosnos has joined #openstack-trove04:01
*** coolsvap has joined #openstack-trove04:01
*** dmakogon_ has quit IRC04:01
*** achampion has quit IRC04:09
*** julienvey has joined #openstack-trove04:21
*** julienvey has quit IRC04:26
*** juantwo has quit IRC04:40
*** amcrn has joined #openstack-trove04:46
*** jdonalds has joined #openstack-trove05:05
*** jdonalds has quit IRC05:07
*** jdonalds has joined #openstack-trove05:10
*** rushiagr_away is now known as rushiagr05:19
*** amcrn has quit IRC05:21
*** julienvey has joined #openstack-trove05:22
*** arborism has joined #openstack-trove05:24
*** julienvey has quit IRC05:27
*** haomaiw__ has quit IRC05:31
*** rushiagr is now known as rushiagr_away05:31
*** rushiagr_away is now known as rushiagr05:31
*** haomaiwang has joined #openstack-trove05:31
*** arborism has quit IRC05:35
*** arborism has joined #openstack-trove05:37
*** haomai___ has joined #openstack-trove05:42
*** haomaiwang has quit IRC05:46
*** ajayaa has joined #openstack-trove06:01
*** arborism has quit IRC06:03
openstackgerritGuanYu, lin proposed a change to openstack/trove: Guest Agent goes active before connecting to message queue  https://review.openstack.org/11413106:06
*** ramishra has quit IRC06:14
*** ramishra has joined #openstack-trove06:14
*** julienvey has joined #openstack-trove06:23
*** tshefi_ has joined #openstack-trove06:24
*** julienvey has quit IRC06:28
*** k4n0 has joined #openstack-trove06:30
*** ViswaV has joined #openstack-trove06:34
*** iartarisi has joined #openstack-trove06:35
*** ViswaV has quit IRC06:35
*** ramishra has quit IRC06:40
*** sgotliv has joined #openstack-trove06:50
*** arborism has joined #openstack-trove06:57
*** jdonalds has quit IRC07:05
*** jdonalds has joined #openstack-trove07:08
*** jdonalds has quit IRC07:08
*** jdonalds has joined #openstack-trove07:08
*** jdonalds has quit IRC07:10
*** haomai___ has quit IRC07:12
*** haomaiwang has joined #openstack-trove07:12
*** Longgeek has joined #openstack-trove07:13
*** haomaiw__ has joined #openstack-trove07:15
*** haomaiwang has quit IRC07:18
*** julienvey has joined #openstack-trove07:24
*** boblebauce has joined #openstack-trove07:26
*** julienvey has quit IRC07:28
*** arborism has quit IRC07:30
*** annashen has quit IRC07:43
*** denis_makogon has joined #openstack-trove07:44
*** Longgeek has quit IRC07:46
*** Longgeek has joined #openstack-trove07:46
*** mrsnivvel has joined #openstack-trove07:51
*** mrsnivvel has left #openstack-trove07:53
*** Longgeek has quit IRC08:00
*** Longgeek has joined #openstack-trove08:00
*** Longgeek has quit IRC08:04
*** haomaiw__ has quit IRC08:04
*** Longgeek has joined #openstack-trove08:05
*** haomaiwang has joined #openstack-trove08:05
*** iartarisi has quit IRC08:06
*** haomai___ has joined #openstack-trove08:11
*** iartarisi has joined #openstack-trove08:13
*** haomaiwang has quit IRC08:14
*** julienvey has joined #openstack-trove08:24
*** boden has joined #openstack-trove08:27
*** julienvey has quit IRC08:29
*** haomai___ has quit IRC09:11
*** haomaiwa_ has joined #openstack-trove09:11
*** julienvey has joined #openstack-trove09:25
*** julienvey has quit IRC09:29
*** julienvey has joined #openstack-trove09:37
*** ramishra has joined #openstack-trove09:45
*** sgotliv has quit IRC10:02
*** denis_makogon has quit IRC10:09
*** Longgeek has quit IRC10:10
*** Longgeek has joined #openstack-trove10:11
*** Longgeek has quit IRC10:14
*** nosnos has quit IRC10:16
*** ramishra has quit IRC10:19
*** ramishra has joined #openstack-trove10:21
*** haomaiw__ has joined #openstack-trove10:24
*** sgotliv has joined #openstack-trove10:25
*** haomaiwa_ has quit IRC10:27
*** ramishra has quit IRC10:30
*** ramishra has joined #openstack-trove10:31
*** ajayaa has quit IRC10:34
*** Longgeek has joined #openstack-trove10:37
*** haomaiw__ has quit IRC10:50
*** haomaiwang has joined #openstack-trove10:51
*** ramishra has quit IRC10:51
openstackgerritGuanYu, lin proposed a change to openstack/trove: Guest Agent goes active before connecting to message queue  https://review.openstack.org/11413110:51
*** ajayaa has joined #openstack-trove11:01
*** sgotliv_ has joined #openstack-trove11:05
*** sgotliv has quit IRC11:07
*** ramishra_ has joined #openstack-trove11:18
*** sgotliv_ has quit IRC11:21
*** ramishra_ has quit IRC11:31
*** Krast has quit IRC11:31
*** ramishra_ has joined #openstack-trove11:35
*** denis_makogon has joined #openstack-trove11:38
*** ramishra_ has quit IRC11:47
*** julienvey has quit IRC11:48
*** juantwo has joined #openstack-trove12:09
*** juantwo has quit IRC12:10
*** juantwo has joined #openstack-trove12:11
*** IanGovett has joined #openstack-trove12:13
*** sgotliv has joined #openstack-trove12:26
*** pdmars has joined #openstack-trove12:31
*** sgotliv has quit IRC12:42
*** tkatarki has joined #openstack-trove12:42
*** tkatarki has quit IRC12:44
*** robertmyers has joined #openstack-trove12:47
*** robertmyers has quit IRC12:51
*** IanGovett has quit IRC12:53
*** tkatarki has joined #openstack-trove12:59
*** ajayaa has quit IRC13:01
*** kevinconway has joined #openstack-trove13:08
*** achampion has joined #openstack-trove13:11
*** tkatarki has quit IRC13:20
*** tkatarki has joined #openstack-trove13:23
openstackgerritGuanYu, lin proposed a change to openstack/trove: Guest Agent goes active before connecting to message queue  https://review.openstack.org/11413113:35
*** rushiagr is now known as rushiagr_away13:39
*** pdmars has quit IRC13:43
openstackgerritA change was merged to openstack/trove: Adjusted audit logging for taskmanager module  https://review.openstack.org/10802013:51
*** pdmars has joined #openstack-trove13:51
*** coolsvap has quit IRC14:07
*** coolsvap has joined #openstack-trove14:11
*** jasondotstar has joined #openstack-trove14:13
*** IanGovett has joined #openstack-trove14:14
*** tkatarki has quit IRC14:20
*** Barker has quit IRC14:23
*** tkatarki has joined #openstack-trove14:26
*** IanGovett has quit IRC14:26
*** ruebenramirez has joined #openstack-trove14:27
*** tkatarki has quit IRC14:27
*** grapex_ has joined #openstack-trove14:29
*** Riddhi has joined #openstack-trove14:30
*** tkatarki has joined #openstack-trove14:37
*** ramashri has joined #openstack-trove14:38
*** rushiagr_away is now known as rushiagr14:41
*** k4n0 has quit IRC14:45
*** mattgriffin has joined #openstack-trove14:50
*** mattgriffin has quit IRC14:50
*** mattgriffin has joined #openstack-trove14:51
*** johnma has joined #openstack-trove14:51
*** kevinconway has quit IRC14:55
*** jcru has joined #openstack-trove14:59
*** Barker has joined #openstack-trove15:00
*** kevinconway has joined #openstack-trove15:04
*** sgotliv has joined #openstack-trove15:08
*** kevinconway has quit IRC15:10
*** robertmyers has joined #openstack-trove15:15
*** dkehnx has quit IRC15:16
*** iartarisi has quit IRC15:17
*** ramashri has quit IRC15:20
*** boblebauce has quit IRC15:21
openstackgerritSimon Chang proposed a change to openstack/trove: Adjusted audit logging for trove.instance module  https://review.openstack.org/10529415:22
*** dkehn_ has joined #openstack-trove15:31
*** achampio1 has joined #openstack-trove15:31
*** dkehn_ is now known as dkehnx15:32
*** tkatarki1 has joined #openstack-trove15:32
*** tkatarki has quit IRC15:38
*** achampion has quit IRC15:38
*** dkehnx has quit IRC15:46
*** sgotliv has quit IRC15:49
*** ramashri has joined #openstack-trove15:50
*** Longgeek has quit IRC15:52
*** dkehn_ has joined #openstack-trove15:52
*** dkehn_ is now known as dkehnx15:52
*** jmontemayor has joined #openstack-trove15:53
*** mattgriffin has quit IRC15:59
*** tkatarki1 has quit IRC15:59
*** georgelorch has quit IRC16:00
*** pdmars has quit IRC16:01
*** PeterSchwaller has quit IRC16:01
*** georgelorch has joined #openstack-trove16:01
*** kevinconway has joined #openstack-trove16:02
*** ramashri has quit IRC16:11
*** tshefi_ has quit IRC16:14
*** shayneburgess has joined #openstack-trove16:23
*** ruebenramirez has quit IRC16:25
*** tvoran has joined #openstack-trove16:29
openstackgerritFelipe Reyes proposed a change to openstack/trove: Add support to detect SUSE  https://review.openstack.org/10839416:32
openstackgerritFelipe Reyes proposed a change to openstack/trove: Add SUSE support in mysql datastore  https://review.openstack.org/10870316:33
*** annashen has joined #openstack-trove16:34
*** PeterSchwaller has joined #openstack-trove16:35
*** ramishra has joined #openstack-trove16:37
*** ruebenramirez has joined #openstack-trove16:37
*** kevinconway has quit IRC16:37
*** PeterSchwaller has quit IRC16:40
*** tkatarki has joined #openstack-trove16:41
*** ramishra has quit IRC16:41
*** kevinconway has joined #openstack-trove16:41
*** saurabhs has joined #openstack-trove16:51
*** georgelorch has quit IRC16:53
*** georgelorch has joined #openstack-trove16:53
*** georgelorch has quit IRC17:01
*** kevinconway has quit IRC17:03
*** PeterSchwaller has joined #openstack-trove17:03
*** georgelorch has joined #openstack-trove17:03
*** radez_g0n3 is now known as radez17:10
*** Barker has quit IRC17:31
openstackgerritGreg Lucas proposed a change to openstack/trove: Mysql guest agent functionality for replication  https://review.openstack.org/9814717:33
*** Barker has joined #openstack-trove17:35
*** PeterSchwaller has quit IRC17:36
*** tkatarki has quit IRC17:36
*** ramishra has joined #openstack-trove17:37
openstackgerritGreg Lucas proposed a change to openstack/trove: Add detach-replication support  https://review.openstack.org/10198117:41
*** ramishra has quit IRC17:42
*** tkatarki has joined #openstack-trove17:46
*** PeterSchwaller has joined #openstack-trove17:52
*** pdmars has joined #openstack-trove17:57
*** pdmars has quit IRC17:59
*** pdmars has joined #openstack-trove17:59
*** tkatarki has quit IRC18:02
*** radez is now known as radez_g0n318:06
*** johnma_ has joined #openstack-trove18:17
*** johnma has quit IRC18:19
*** johnma_ is now known as johnma18:19
*** NehaV1 has joined #openstack-trove18:32
*** ramishra has joined #openstack-trove18:38
*** georgelorch has quit IRC18:40
icchaglucas: I think I am running into timeout issues too18:42
*** georgelorch has joined #openstack-trove18:42
*** ramishra has quit IRC18:42
*** sgotliv has joined #openstack-trove18:54
openstackgerritGreg Lucas proposed a change to openstack/trove: Snapshot component for replication  https://review.openstack.org/10968718:56
*** sgotliv has quit IRC18:57
*** sgotliv has joined #openstack-trove18:57
*** Barker has quit IRC18:59
*** Barker has joined #openstack-trove18:59
amrithhmmm ... now that rdjenkins has become "Deprecated Trove CI", how does one kick it? "rdjenkins no bug" doesn't seem to work. is it "Deprecated Trove CI no bug"?19:10
*** grapex_ has quit IRC19:11
amriththat doesn't work ...19:11
*** grapex has joined #openstack-trove19:11
*** kevinconway has joined #openstack-trove19:15
openstackgerritGreg Lucas proposed a change to openstack/trove: Augment Mysql status checking for replication  https://review.openstack.org/11268919:20
openstackgerritOpenStack Proposal Bot proposed a change to openstack/trove: Updated from global requirements  https://review.openstack.org/11152919:23
openstackgerritGreg Lucas proposed a change to openstack/trove: Unit Tests for Mysql replication functionality  https://review.openstack.org/10931319:33
*** miqui has quit IRC19:33
*** denis_makogon_ has joined #openstack-trove19:35
*** kevinconway has quit IRC19:37
glucasiccha: is it the same agent high timeout that SlickNik hit?19:37
glucasiccha: dougshelley66 was saying he had to increate the usage_timeout as well.19:37
*** jmontemayor has quit IRC19:37
glucass/increate/increase/19:37
*** jmontemayor has joined #openstack-trove19:38
*** ramishra has joined #openstack-trove19:39
SlickNikiccha / glucas: There were two timeouts I needed to increase: the timeout for the get_replication_snapshot, and the usage_timeout.19:39
icchaglucas: i also randomly from time to time strangely run into an error which says xtraback_binlog_info file is not found. i have no clue why. digging in. dont knoe if its related to time outs19:40
*** miqui has joined #openstack-trove19:40
*** jdandrea has quit IRC19:44
*** ramishra has quit IRC19:44
*** kevinconway has joined #openstack-trove19:45
*** sgotliv has quit IRC19:46
openstackgerritSimon Chang proposed a change to openstack/trove: Adjusted audit logging for trove.instance module  https://review.openstack.org/10529419:54
*** tkatarki has joined #openstack-trove19:56
*** tkatarki has quit IRC20:05
vgnbkriccha: When I was developing the feature, I couldn't find the xtraback_binlog_info file either - I wonder if there's some state that causes it not to appear.20:09
icchavgnbkr: what did u do it make it work then20:11
icchavgnbkr: i ran it multiple times and only once the slave went activae. other times there was issue finding the binlog info file20:12
*** jcru_ has joined #openstack-trove20:15
*** robertmy_ has joined #openstack-trove20:15
*** jcru has quit IRC20:18
*** robertmyers has quit IRC20:18
SlickNikiccha: There's a race condition where the attach_replication_slave message makes it to the guestagent even before prepare is finished — if the usage_timeout in the models is set too low.20:19
*** jasondotstar has quit IRC20:19
icchagotcha that makes sense SlickNik20:19
icchaSlickNik: do we want to first try to push out and merge https://review.openstack.org/#/c/98147/25 ?20:21
SlickNikiccha: yes, I think that one has had adequate review and test coverage - so let's try and get that merged.20:22
icchaSlickNik: totally agree with that20:22
icchaand on the snapshot code I agree with some of denis_makogon_ 's comments. it could do with a little bit more polishing20:23
SlickNikiccha: rdjenkins died last night — so I'm looking at getting another jenkins box up and running to vet the tests before I +2.20:23
denis_makogon_iccha, nice to hear =)20:23
*** tkatarki has joined #openstack-trove20:23
icchaSlickNik: you have been battling jenkins for a long time. thanks for keeping that going for us.20:24
SlickNikiccha: can you call out which of the comments you agree with as part of your review (if you haven't already done so — I haven't had a chance to look yet).20:24
SlickNikAnd thanks for the reviews, guys :)20:24
icchaok sure will do SlickNik20:26
*** tkatarki has quit IRC20:26
vgnbkriccha: re binlog - I didn't do anything - Greg found the file, then it just worked for me20:27
icchaglucas: SlickNik vgnbkr for some future concerns https://bugs.launchpad.net/trove/+bug/135706520:28
icchaSlickNik: what did u increase the time out too? I increased the usage timeout and agent high timeout and still having issues20:31
SlickNikiccha: I only increased those two values you mentioned.20:33
SlickNikiccha: Can you gist your guestagent-log?20:33
SlickNikiccha: Also, thanks for the bug. +1 to re-iterating and fixing some of these bugs/issues we find once we have the basic functionality merged (but before juno is cut).20:34
icchaSlickNik: https://gist.github.com/isethi/e47dcdec32000ada48ae its related to what you said i think. its trying to attach slave even before the restore is done20:35
dougshelley66SlickNik, I think that makes the most sense as well. We can have more folks engaged in hardening it after the base commits are merged20:35
*** tkatarki has joined #openstack-trove20:36
*** georgelorch has quit IRC20:36
*** georgelorch has joined #openstack-trove20:37
*** tkatarki has quit IRC20:37
SlickNikiccha: yup looks like it. Just a silly question, but did you ensure to restart the trove-services (esp taskmanager) after you changed the timeouts?20:38
icchayes SlickNik restarted all services. maybe i didnt sufficiently increase timeouts. will try with higher values20:39
*** ramishra has joined #openstack-trove20:40
*** boden has quit IRC20:40
icchabtw SlickNik did the trove community already have options discussed for failover earlier? are there any contenders? glucas vgnbkr dougshelley6620:43
*** ramishra has quit IRC20:44
SlickNikiccha: I know vipul was looking into a few designs for auto-failover earlier — he probably has a lot more info regarding that.20:44
icchavipul: any thoughts?20:45
icchajust trying to do my background work for the midcycle :)20:45
*** rushiagr is now known as rushiagr_away20:47
denis_makogon_iccha, i've got question to you20:47
icchayes denis_makogon_20:47
denis_makogon_iccha, any clue how to fix use of hardcoded repliation password?20:47
vgnbkrI suspect that failover will involve support beyond Trove - I suspect there will need to be some way to change the address that the user uses to connect to the db.  First, I expect we would need to change the way the user addresses the database (i.e, not by direct ip address).20:48
vgnbkriccha: ^^20:48
icchadenis_makogon_: what the mysql dbas i spoke to suggest that we geenrate a random password that we do not need to store. if we need to reset replication we can always create a new user with a new random password20:48
icchavgnbkr: yeah and there are so many ways this can be done. virtual floating ip, load baalncers, etc20:49
denis_makogon_vgnbkr, when you'll try to fix it, leave some place for barbican integration20:50
denis_makogon_vgnbkr, sorry20:50
denis_makogon_iccha, ^^20:50
denis_makogon_iccha, when you'll try to fix it, leave some place for barbican integration20:50
icchadenis_makogon_: if  we find a concrete need to store passwords then sure20:50
denis_makogon_iccha, not store - deliver20:51
icchawhy would we need to deliver passwords denis_makogon_ ?20:52
denis_makogon_iccha, as you said, for replication user20:52
vipuliccha: No, so the last time we brought this up, the consensus was let's not invent our own mechanism for monitoring mysql and detecting when to fail over20:52
denis_makogon_vipul, ++20:52
vipulthe folks from Percona said we need to be looking at existing tools that do this20:53
vipulbut i haven't gotten around to actually looking at any of them20:53
vipuland what's unclear is how do we integrate those tools with trove20:53
icchavipul: i think thats a good idea.20:53
icchahaha20:53
vipulbecause we want Trove to know when this tools has actually done a fialover20:53
icchai typed the same things vipul20:53
denis_makogon_vipul, existing tools are out of OpenStack, but we can use ceilometer once it'll have in-application monitoring20:53
icchavipul: and some of these tools require setup outside trove infrastructure20:54
vipuliccha: yep exactly -- so i am thinking we need a reference implemenation that is openstack/trove specific.20:54
vipuland we need to make it pluggable so we can use other off the shelf things if an operator wants20:54
vipulimo Trove standalone shoudl be able to do some level of failover..20:55
vipulit might not be as good as a third-party tool might.. but i don't know how to make it available out of the box otherwise20:55
denis_makogon_vipul, what about initially implement periodic notifications from guest (datastore specific)?20:55
icchavipul: so pluggable home grown basic solution?20:55
vipuldenis_makogon_ yea it could be that.. something that relies on the guest notifications as the reference impl20:56
vipuliccha: yea20:56
denis_makogon_vipul, take a look http://lists.openstack.org/pipermail/openstack-dev/2014-July/041356.html20:57
denis_makogon_iccha, please take a look too, http://lists.openstack.org/pipermail/openstack-dev/2014-July/041356.html20:57
vipula guest notification based implemenation won't be that great.. won't be robust, and likely will mean a longer time before we actually faiilover a customer database.. but it's something that Trove can provide without requiring operators to pick a tool20:57
icchawill need to dig in and see how these solutions (failover) can be remotely pluggable20:59
denis_makogon_vipul, yes, i was looking to monitoring systems, and seems that there's no transparent way to integrate them into some sort of monitoring service (ceilometer or something else)20:59
icchastuff like mha seems so different from say mysqlfailover20:59
denis_makogon_iccha, there are tons of ways to do failover21:00
denis_makogon_iccha, personally, i'd like to have failover with hidden node that's ready for substitution of any failed node21:01
denis_makogon_returning to guest notifications21:02
denis_makogon_we can add notification to guest and once DB is down due to certain reasons, the closest notification to ceilometer will raise alarm that can be used by side tools21:03
vipuliccha: yea, a lot of them also require the ability to ssh onto these boxes21:03
vipulwhich Trove has tried to avoid opening up.. (although an operator can do that if they still choose)21:04
denis_makogon_for example, heat does autoscaling taking  into account ceilometer alarm21:04
vipulwhile the ceiolometer based approach seem good long term, i don't know how many of us actually run Ceiolometer21:05
vipuland it would be adding a new dependency to run Trove21:05
icchadenis_makogon_: yeah this is gonna be a hard one to solve cause everyone is going to have their own preferences21:05
icchavipul: yeah there are solutions liek opening specific ports only to the sentinel nodes etc, but i dont know why but i feel that this is going to be something hard to get into trove21:06
icchabbiab happy hour time here21:08
vipulwoah cool -- enjoy!21:09
*** jmontemayor has quit IRC21:10
*** robertmy_ has quit IRC21:11
glucasiccha: nice. I'm enjoying happy hour too, but that's only because I'm working at home today. :D21:13
*** tkatarki has joined #openstack-trove21:15
*** tkatarki has quit IRC21:27
*** annashen has quit IRC21:30
*** georgelorch has quit IRC21:30
*** georgelorch has joined #openstack-trove21:30
*** juantwo has quit IRC21:34
*** ruebenramirez has quit IRC21:35
*** openstackgerrit has quit IRC21:46
*** openstackgerrit has joined #openstack-trove21:47
*** ramishra has joined #openstack-trove21:54
*** georgelorch has quit IRC21:58
*** georgelorch has joined #openstack-trove21:58
*** johnma has quit IRC21:58
*** ramishra has quit IRC21:59
*** ramashri has joined #openstack-trove22:05
*** achampio1 has quit IRC22:07
*** arist has quit IRC22:09
*** arist has joined #openstack-trove22:10
*** NehaV1 has quit IRC22:10
*** Barker has quit IRC22:10
amrithoh, thanks glucas. I was wondering where you were at lunch.22:18
openstackgerritSimon Chang proposed a change to openstack/trove: Fixed database migration script issues  https://review.openstack.org/11358222:25
*** jcru_ has quit IRC22:40
*** georgelorch has quit IRC22:41
*** georgelorch has joined #openstack-trove22:43
denis_makogon_glucas, are you there ?22:53
*** amcrn has joined #openstack-trove22:54
*** ramishra has joined #openstack-trove22:55
*** pdmars has quit IRC22:56
*** juantwo has joined #openstack-trove22:58
*** juantwo has quit IRC22:59
*** juantwo has joined #openstack-trove22:59
*** ramishra has quit IRC22:59
denis_makogon_SlickNik, are you around?23:00
*** kevinconway has quit IRC23:02
*** denis_makogon has quit IRC23:06
*** denis_makogon_ has quit IRC23:06
*** denis_makogon has joined #openstack-trove23:06
SlickNikdenis_makogon: Around now.23:07
openstackgerritNikhil Manchanda proposed a change to openstack/python-troveclient: Add new command: detach-replica  https://review.openstack.org/10177123:12
*** tvoran has quit IRC23:35
*** tvoran has joined #openstack-trove23:37
*** ramishra has joined #openstack-trove23:56
*** Riddhi has quit IRC23:59

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!