Re: VIP Manager suggestions
On Wed, 2014-03-19 at 21:31 -0600, CS_DBA wrote: Hi all; Anyone have any suggestions per Virtual I.P. managers? OK, I'll bite. What's a Virtual I.P. manager? poc -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
A tool to manage the creation, assignment, shutdown, movement, etc of VIP's (or I.P. alliases) On 03/20/2014 05:31 AM, Patrick O'Callaghan wrote: On Wed, 2014-03-19 at 21:31 -0600, CS_DBA wrote: Hi all; Anyone have any suggestions per Virtual I.P. managers? OK, I'll bite. What's a Virtual I.P. manager? poc -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
RE: VIP Manager suggestions
As we are heading towards 1/4, I was contemplating about virtual Intellectual Properties So for people who would like to think, that they were the one that created something bright. Aka patent-trols So, a VIP-manager would be a tool for managing trolls! -Original Message- From: users-boun...@lists.fedoraproject.org [mailto:users-boun...@lists.fedoraproject.org] On Behalf Of CS_DBA Sent: donderdag 20 maart 2014 14:26 To: Community support for Fedora users Subject: Re: VIP Manager suggestions A tool to manage the creation, assignment, shutdown, movement, etc of VIP's (or I.P. alliases) On 03/20/2014 05:31 AM, Patrick O'Callaghan wrote: On Wed, 2014-03-19 at 21:31 -0600, CS_DBA wrote: Hi all; Anyone have any suggestions per Virtual I.P. managers? OK, I'll bite. What's a Virtual I.P. manager? poc -- users mailing list __ Dit bericht kan informatie bevatten die niet voor u is bestemd. Indien u niet de geadresseerde bent of dit bericht abusievelijk aan u is toegezonden, wordt u verzocht dat aan de afzender te melden en het bericht te verwijderen. De Staat aanvaardt geen aansprakelijkheid voor schade, van welke aard ook, die verband houdt met risico's verbonden aan het electronisch verzenden van berichten. This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. The State accepts no liability for damage of any kind resulting from the risks inherent in the electronic transmission of messages. -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/20/14 09:26, CS_DBA wrote: A tool to manage the creation, assignment, shutdown, movement, etc of VIP's (or I.P. alliases) On 03/20/2014 05:31 AM, Patrick O'Callaghan wrote: On Wed, 2014-03-19 at 21:31 -0600, CS_DBA wrote: Hi all; Anyone have any suggestions per Virtual I.P. managers? OK, I'll bite. What's a Virtual I.P. manager? poc Well, the next question should be: Why? Why would you need something like that? What are you doing that requires that kind of setup that DHCP wouldn't work better? - -- Mark Haney Network/Systems Administrator Practichem W: (919) 714-8428 Fedora release 20 (Heisenbug) 3.13.6-200.fc20.x86_64 -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTKu8mAAoJEM/YzwEAv6e7gTIIAJatUkppaLVCGaPc86QJ6z8k N5rpvBMug3dT7LRbBD0dQJZmzvS9ftAEOo37NbkKQYCKe/DkA95GDi36dzNh7n30 cOv1QXXOGpv8dIls3w74YN+nsTxLy1M0y0ELkojD4FLlOGDJAxQWzcmxnGp3IrB+ 9RrcKLuYfAxmLpRPsrwZZkkWC9+ZEivHl+nlnsnwXDnf+twvzCS6qUdYeeFUqyu6 BUbatUO/3MllKETkf/EXyKzuJFd0N6ki/5PLmkfVTSlM1j/+N8Ik4/uSO/cVmN+C Yy3zJJ03ExwHna3JCMKbYIRSr1Ee6L+CkKq1JvMb2Q/XG829OFMk124I5M6Qh+Y= =hGRj -END PGP SIGNATURE- -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/20/14 09:35, j.witvl...@mindef.nl wrote: As we are heading towards 1/4, I was contemplating about virtual Intellectual Properties So for people who would like to think, that they were the one that created something bright. Aka patent-trols So, a VIP-manager would be a tool for managing trolls! So a virtual lawyer? God, that is just what this world needs. I can see it now 'Clippy' threatening lawsuits for infringing on Microsoft's virtual patent for virtual grammatical errors. (Which is CLEARLY different from actual grammatical errors.) Man, I need to stop thinking - -- Mark Haney Network/Systems Administrator Practichem W: (919) 714-8428 Fedora release 20 (Heisenbug) 3.13.6-200.fc20.x86_64 -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTKu/7AAoJEM/YzwEAv6e7owQH/2AAoVyEJhyCKpjE7x0i4U7V /JcSLnSzqZdWaj1GCviuICNCqniTwA0azu/PEhNVdFUbbl2ds+iUSxaMRKTIbtgv 1NgpCYuWq9e8t+p3WndS7SQcpjoD+M1Ra3Ytw0PPSiqvzq4gnKoi+oPjOBH0js4t nlmGLLrQ1jQri43NGqyU1u9NbEb4q+TAwGPlgHgKPvROEUuJEX4VrFpNCOLHfgSc m4+J8rXF6hYPZS+5ordr0mRLUUlsbiFjhUI51xqB3d+24CEbvMfNOWwbmlb/tOvh oWucP2eTMbHRgMMnS16Sp/6JHTZbiLVwmJ9TYjHqz/Osv2H/U+sMxhEDm4Lxozo= =8yNY -END PGP SIGNATURE- -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
On 03/20/2014 07:37 AM, Mark Haney wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/20/14 09:26, CS_DBA wrote: A tool to manage the creation, assignment, shutdown, movement, etc of VIP's (or I.P. alliases) On 03/20/2014 05:31 AM, Patrick O'Callaghan wrote: On Wed, 2014-03-19 at 21:31 -0600, CS_DBA wrote: Hi all; Anyone have any suggestions per Virtual I.P. managers? OK, I'll bite. What's a Virtual I.P. manager? poc Well, the next question should be: Why? Why would you need something like that? What are you doing that requires that kind of setup that DHCP wouldn't work better? - -- Mark Haney Network/Systems Administrator Practichem W: (919) 714-8428 Fedora release 20 (Heisenbug) 3.13.6-200.fc20.x86_64 -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTKu8mAAoJEM/YzwEAv6e7gTIIAJatUkppaLVCGaPc86QJ6z8k N5rpvBMug3dT7LRbBD0dQJZmzvS9ftAEOo37NbkKQYCKe/DkA95GDi36dzNh7n30 cOv1QXXOGpv8dIls3w74YN+nsTxLy1M0y0ELkojD4FLlOGDJAxQWzcmxnGp3IrB+ 9RrcKLuYfAxmLpRPsrwZZkkWC9+ZEivHl+nlnsnwXDnf+twvzCS6qUdYeeFUqyu6 BUbatUO/3MllKETkf/EXyKzuJFd0N6ki/5PLmkfVTSlM1j/+N8Ik4/uSO/cVmN+C Yy3zJJ03ExwHna3JCMKbYIRSr1Ee6L+CkKq1JvMb2Q/XG829OFMk124I5M6Qh+Y= =hGRj -END PGP SIGNATURE- So we're looking at database failover, application connections to the db are via I.P.'s (or aliases) we can of course use ifconfig and create/destroy aliases and thus move the IP aliases at failover time, however I would like to leverage a tool so the IP alias move can be both seamless and executable via command(s) on a single server. With ifconfig aliases we need to do the following in the failover script: - execute the ifdown on the old / failed master server (probably via commands over ssh) - validate that the ip alias came down - execute the ifup of the alias on the slave (going to be the new master shortly) - verify that it came up - then finish the db failover It would be keen if I could execute a single command like we do with amazon elastic ip's or RackSpace virtual ip's... Thoughts? -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
On Thu, 2014-03-20 at 10:51 -0600, CS_DBA wrote: It would be keen if I could execute a single command like we do with amazon elastic ip's or RackSpace virtual ip's... Just a thought: how about using a round-robin DNS server? poc -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/20/14 12:51, CS_DBA wrote: So we're looking at database failover, application connections to the db are via I.P.'s (or aliases) we can of course use ifconfig and create/destroy aliases and thus move the IP aliases at failover time, however I would like to leverage a tool so the IP alias move can be both seamless and executable via command(s) on a single server. With ifconfig aliases we need to do the following in the failover script: - execute the ifdown on the old / failed master server (probably via commands over ssh) - validate that the ip alias came down - execute the ifup of the alias on the slave (going to be the new master shortly) - verify that it came up - then finish the db failover I've been in a similar situation before, and here's what I did. Instead of failing over from one to another, use round-robin DNS and replicate the DB between servers. My original setup was with 2 DB servers with a backend GigE fiber connection with as close to real-time replication as I could make it. This kept the data consistent and let me take one down if I needed to, or if one failed round robin would send connections to the live DB. I ended up scaling it up from 2 Db servers to 4, 2 live servers, 2 'backup' servers that I could make live if my primaries were hit really hard, or would be backups if one of my primaries died. RR DNS and DB replication is your friend here. Mucking with IP aliases might sound good initially, and it may be fine for a while, but I would consider long-term improvements. My situation was kind of special due to the demands of MilSpec with the SGI Altix HPCCs and DB servers I managed, but this setup will work in almost every situation. I'll be glad to offer any assistance off-list if you like. - -- Mark Haney Network/Systems Administrator Practichem W: (919) 714-8428 Fedora release 20 (Heisenbug) 3.13.6-200.fc20.x86_64 -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTKyT6AAoJEM/YzwEAv6e7KQQH/RHZ0OE3Ni+Mu+ChDkkZ0z2C NwZt4Br11vYfHq/80rPGnFm/W7m4i1Sfg1cunwN6LqKGGkp1B0KRIDDuuM26oxd6 LZMrUPhGOGWPFxjruV9r658USVsKqbLbFNNFmTapoDK6XyuB+URYbYdz1JCordEy 4vHBnTIyPi4H5qMjG6cfcIHVXieda6+/v7pm4JZIfIE3Hv6kztWXUOvhKJAG8gCl DLloSCxEABiaOq/M/v/zaK1NEc5Ge4OCHQT+WqY76FveM7QbNcF9k/4Oda3sZfcZ 38Wn/qQdWNaVnqfjPJeQlWmYGImnok7sKIgfQpVfLOlfCnD2I+4T0dngm8jsyug= =oayJ -END PGP SIGNATURE- -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
On 03/20/2014 09:51 AM, CS_DBA issued this missive: On 03/20/2014 07:37 AM, Mark Haney wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/20/14 09:26, CS_DBA wrote: A tool to manage the creation, assignment, shutdown, movement, etc of VIP's (or I.P. alliases) On 03/20/2014 05:31 AM, Patrick O'Callaghan wrote: On Wed, 2014-03-19 at 21:31 -0600, CS_DBA wrote: Hi all; Anyone have any suggestions per Virtual I.P. managers? OK, I'll bite. What's a Virtual I.P. manager? poc Well, the next question should be: Why? Why would you need something like that? What are you doing that requires that kind of setup that DHCP wouldn't work better? So we're looking at database failover, application connections to the db are via I.P.'s (or aliases) we can of course use ifconfig and create/destroy aliases and thus move the IP aliases at failover time, however I would like to leverage a tool so the IP alias move can be both seamless and executable via command(s) on a single server. With ifconfig aliases we need to do the following in the failover script: - execute the ifdown on the old / failed master server (probably via commands over ssh) - validate that the ip alias came down - execute the ifup of the alias on the slave (going to be the new master shortly) - verify that it came up - then finish the db failover It would be keen if I could execute a single command like we do with amazon elastic ip's or RackSpace virtual ip's... Thoughts? First off, make SURE you have your database replication set up correctly (master-slave, master-master, whatever). It is SO easy to hose a database when you flip automatically like that. You can look at Linux HA (commonly used for this sort of thing). You may want to look at using DRBD as well, putting your databases on the DRBD- managed partitions. If you're comfortable with your replication, have a look at keepalived: http://keepalived.org/ -- - Rick Stevens, Systems Engineer, AllDigitalri...@alldigital.com - - AIM/Skype: therps2ICQ: 22643734Yahoo: origrps2 - -- - Veni, Vidi, VISA: I came, I saw, I did a little shopping. - -- -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
On 03/20/2014 10:51 AM, CS_DBA wrote: On 03/20/2014 07:37 AM, Mark Haney wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/20/14 09:26, CS_DBA wrote: A tool to manage the creation, assignment, shutdown, movement, etc of VIP's (or I.P. alliases) On 03/20/2014 05:31 AM, Patrick O'Callaghan wrote: On Wed, 2014-03-19 at 21:31 -0600, CS_DBA wrote: Hi all; Anyone have any suggestions per Virtual I.P. managers? OK, I'll bite. What's a Virtual I.P. manager? poc Well, the next question should be: Why? Why would you need something like that? What are you doing that requires that kind of setup that DHCP wouldn't work better? The applications can only write to one database at a time, only the master database is read/write. if the db fails and we need to promote the slave to the master then we don't want to mess with the apps but simply move the database IP they use so that IP now points to the new master - -- Mark Haney Network/Systems Administrator Practichem W: (919) 714-8428 Fedora release 20 (Heisenbug) 3.13.6-200.fc20.x86_64 -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTKu8mAAoJEM/YzwEAv6e7gTIIAJatUkppaLVCGaPc86QJ6z8k N5rpvBMug3dT7LRbBD0dQJZmzvS9ftAEOo37NbkKQYCKe/DkA95GDi36dzNh7n30 cOv1QXXOGpv8dIls3w74YN+nsTxLy1M0y0ELkojD4FLlOGDJAxQWzcmxnGp3IrB+ 9RrcKLuYfAxmLpRPsrwZZkkWC9+ZEivHl+nlnsnwXDnf+twvzCS6qUdYeeFUqyu6 BUbatUO/3MllKETkf/EXyKzuJFd0N6ki/5PLmkfVTSlM1j/+N8Ik4/uSO/cVmN+C Yy3zJJ03ExwHna3JCMKbYIRSr1Ee6L+CkKq1JvMb2Q/XG829OFMk124I5M6Qh+Y= =hGRj -END PGP SIGNATURE- So we're looking at database failover, application connections to the db are via I.P.'s (or aliases) we can of course use ifconfig and create/destroy aliases and thus move the IP aliases at failover time, however I would like to leverage a tool so the IP alias move can be both seamless and executable via command(s) on a single server. With ifconfig aliases we need to do the following in the failover script: - execute the ifdown on the old / failed master server (probably via commands over ssh) - validate that the ip alias came down - execute the ifup of the alias on the slave (going to be the new master shortly) - verify that it came up - then finish the db failover It would be keen if I could execute a single command like we do with amazon elastic ip's or RackSpace virtual ip's... Thoughts? -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
On 03/20/2014 10:56 AM, Patrick O'Callaghan wrote: On Thu, 2014-03-20 at 10:51 -0600, CS_DBA wrote: It would be keen if I could execute a single command like we do with amazon elastic ip's or RackSpace virtual ip's... Just a thought: how about using a round-robin DNS server? poc Only one of the databases is writable at any time (the master) -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
Re: VIP Manager suggestions
On 03/20/2014 11:27 AM, Mark Haney wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/20/14 12:51, CS_DBA wrote: So we're looking at database failover, application connections to the db are via I.P.'s (or aliases) we can of course use ifconfig and create/destroy aliases and thus move the IP aliases at failover time, however I would like to leverage a tool so the IP alias move can be both seamless and executable via command(s) on a single server. With ifconfig aliases we need to do the following in the failover script: - execute the ifdown on the old / failed master server (probably via commands over ssh) - validate that the ip alias came down - execute the ifup of the alias on the slave (going to be the new master shortly) - verify that it came up - then finish the db failover I've been in a similar situation before, and here's what I did. Instead of failing over from one to another, use round-robin DNS and replicate the DB between servers. My original setup was with 2 DB servers with a backend GigE fiber connection with as close to real-time replication as I could make it. This kept the data consistent and let me take one down if I needed to, or if one failed round robin would send connections to the live DB. I ended up scaling it up from 2 Db servers to 4, 2 live servers, 2 'backup' servers that I could make live if my primaries were hit really hard, or would be backups if one of my primaries died. RR DNS and DB replication is your friend here. Mucking with IP aliases might sound good initially, and it may be fine for a while, but I would consider long-term improvements. My situation was kind of special due to the demands of MilSpec with the SGI Altix HPCCs and DB servers I managed, but this setup will work in almost every situation. I'll be glad to offer any assistance off-list if you like. we're running PostgreSQL and Streaming replication which means that we can only write to the master. Were both of your db's read/write nodes? What db platform? - -- Mark Haney Network/Systems Administrator Practichem W: (919) 714-8428 Fedora release 20 (Heisenbug) 3.13.6-200.fc20.x86_64 -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTKyT6AAoJEM/YzwEAv6e7KQQH/RHZ0OE3Ni+Mu+ChDkkZ0z2C NwZt4Br11vYfHq/80rPGnFm/W7m4i1Sfg1cunwN6LqKGGkp1B0KRIDDuuM26oxd6 LZMrUPhGOGWPFxjruV9r658USVsKqbLbFNNFmTapoDK6XyuB+URYbYdz1JCordEy 4vHBnTIyPi4H5qMjG6cfcIHVXieda6+/v7pm4JZIfIE3Hv6kztWXUOvhKJAG8gCl DLloSCxEABiaOq/M/v/zaK1NEc5Ge4OCHQT+WqY76FveM7QbNcF9k/4Oda3sZfcZ 38Wn/qQdWNaVnqfjPJeQlWmYGImnok7sKIgfQpVfLOlfCnD2I+4T0dngm8jsyug= =oayJ -END PGP SIGNATURE- -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
VIP Manager suggestions
Hi all; Anyone have any suggestions per Virtual I.P. managers? Thx -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org