RE: Machine Learning
Hi Garot, How is the visual diagram coming along ? I'd be good to have a good idea of core system specifics so that DB design can be tailored to that ... of course, knowing that things will change as the concept evolves. Thanks, Justin -Original Message- From: Garot Conklin [mailto:garotconk...@yahoo.com] Sent: 23 August 2012 20:14 To: Martin Gainty; ag4ve...@gmail.com Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com Subject: Re: Machine Learning That is in fact a very interesting approach... I like it very much. Any architectural thoughts on an auto-population attempt? Odly I have not created a db like this before, not from this large of an import anyway... Please share some thoughts there and I will get that rolling... seems that if we can get something physical going I would like to offer it up as a sandbox to all those interested. I have a few X336's lying around my house just collecting dust, they would be a great testing environment for all to work on. garotconk...@yahoo.com From: Martin Gainty mgai...@hotmail.com To: ag4ve...@gmail.com; garotconk...@yahoo.com Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com mysql@lists.mysql.com Sent: Thursday, August 23, 2012 11:30 AM Subject: RE: Machine Learning Shawn and Garot I like the parsing capability of the lucene and its ability to stem incoming queries.. If you are able to start populating your data then we *should* be able to start identifying which root terms we can pull for building lucene-indexes I have an upcoming stuck-in-JFK-airport-on-labor-day-waiting-for-the-next-am-flight-of-USscare for an interrupted timeframe(i never learned how to 'sleep' in airport terminal) as long as I can find a wifi connection (and an AC connection within 6 hours) and use a working MySQL JDBC connection string..I should be able to bang out a quick prototype.. Let me know how i can help out, Martin Gainty __ ..place long-winded disclaimer here.. From: ag4ve...@gmail.com Date: Thu, 23 Aug 2012 10:42:55 -0400 Subject: Re: Machine Learning To: garotconk...@yahoo.com CC: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com just a few thoughts (things to look into) if you want to populate a db with command parameters, i'd mine the man pages. it's a consistent format and you should be able to find a parser for whatever language you prefer. if you want to see what has been entered and statistics about that process, look at the audit framework. it won't tell you success or failure, but you might be able to derive that based on the time, memory, and process usage that you can get from audit. auditd also maintains a db - you might look into the engine and schema they use. you might also find some interesting topics looking into language processing (after all, commands are a type of language). people generally use other database engines to do this type of thing - elastic search or some other things people have done with lucene maybe. do let us know where you go with this. it sounds quite interesting (and might help me with something i've been looking into)... and getting zsh to autocomplete options might be a bonus if you parse man pages and shove it into a db (i might do that part for you if i get a lazy afternoon). On Wed, Aug 22, 2012 at 7:51 PM, Garot Conklin garotconk...@yahoo.com wrote: I am going to work up a visual diagram for this to better... visualize (LOL) the lay of the land. I will forward it when i have it completed then I hope we can continue the architectural discussion here! Thanks -Garot garotconk...@yahoo.com From: Garot Conklin garotconk...@yahoo.com To: Garot Conklin garotconk...@yahoo.com; webmas...@lisol.co.uk webmas...@lisol.co.uk; 'Martin Gainty' mgai...@hotmail.com; mysql@lists.mysql.com mysql@lists.mysql.com Sent: Tuesday, August 21, 2012 4:40 PM Subject: Re: Machine Learning to elaborate: I would almost rather qualify from the OS perspective what will work in advance, but take into consideration any failing condition. I may be getting a bit too specific at this juncture however as I am already apply this logic to issues I see in MY environment rather than total ambiguity, which is a best position here. I am ultimately expecting the learning algorithm to create new and excitingly effective ways of stringing commands together to solve issues, this being a notable aspect in and of itself, then creating some centralization based on what the machine determines as a best solution. Seems a relative snapshot of the system pre and post execution would be favorable as well so long as resources are not taxed as a result. This discussion is leading me to believe that this will be a multifaceted db solution without a doubt comprised of multiple layers of
RE: Machine Learning
we'll need a user-friendly architecture diagram with a hopefully one to one mapping to DBSchema Table Elements..(run the napkin thru a scanner and publish it) once the Table Elements are defined then we'll need to populate Tables with columns..determine Primary Keys with Foreign keys..get the relationships defined and written down then create the database ..once the DB is up and running in an accesible location with sftp or scp running so we can import.. publish the JDBC connection string Martin __ ..place long winded disclaimer here.. From: webmas...@lisol.co.uk To: garotconk...@yahoo.com; mgai...@hotmail.com; ag4ve...@gmail.com CC: mysql@lists.mysql.com Subject: RE: Machine Learning Date: Fri, 24 Aug 2012 09:04:21 +0100 Hi Garot, How is the visual diagram coming along ? I'd be good to have a good idea of core system specifics so that DB design can be tailored to that ... of course, knowing that things will change as the concept evolves. Thanks, Justin -Original Message- From: Garot Conklin [mailto:garotconk...@yahoo.com] Sent: 23 August 2012 20:14 To: Martin Gainty; ag4ve...@gmail.com Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com Subject: Re: Machine Learning That is in fact a very interesting approach... I like it very much. Any architectural thoughts on an auto-population attempt? Odly I have not created a db like this before, not from this large of an import anyway... Please share some thoughts there and I will get that rolling... seems that if we can get something physical going I would like to offer it up as a sandbox to all those interested. I have a few X336's lying around my house just collecting dust, they would be a great testing environment for all to work on. garotconk...@yahoo.com From: Martin Gainty mgai...@hotmail.com To: ag4ve...@gmail.com; garotconk...@yahoo.com Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com mysql@lists.mysql.com Sent: Thursday, August 23, 2012 11:30 AM Subject: RE: Machine Learning Shawn and Garot I like the parsing capability of the lucene and its ability to stem incoming queries.. If you are able to start populating your data then we *should* be able to start identifying which root terms we can pull for building lucene-indexes I have an upcoming stuck-in-JFK-airport-on-labor-day-waiting-for-the-next-am-flight-of-USscare for an interrupted timeframe(i never learned how to 'sleep' in airport terminal) as long as I can find a wifi connection (and an AC connection within 6 hours) and use a working MySQL JDBC connection string..I should be able to bang out a quick prototype.. Let me know how i can help out, Martin Gainty __ ..place long-winded disclaimer here.. From: ag4ve...@gmail.com Date: Thu, 23 Aug 2012 10:42:55 -0400 Subject: Re: Machine Learning To: garotconk...@yahoo.com CC: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com just a few thoughts (things to look into) if you want to populate a db with command parameters, i'd mine the man pages. it's a consistent format and you should be able to find a parser for whatever language you prefer. if you want to see what has been entered and statistics about that process, look at the audit framework. it won't tell you success or failure, but you might be able to derive that based on the time, memory, and process usage that you can get from audit. auditd also maintains a db - you might look into the engine and schema they use. you might also find some interesting topics looking into language processing (after all, commands are a type of language). people generally use other database engines to do this type of thing - elastic search or some other things people have done with lucene maybe. do let us know where you go with this. it sounds quite interesting (and might help me with something i've been looking into)... and getting zsh to autocomplete options might be a bonus if you parse man pages and shove it into a db (i might do that part for you if i get a lazy afternoon). On Wed, Aug 22, 2012 at 7:51 PM, Garot Conklin garotconk...@yahoo.com wrote: I am going to work up a visual diagram for this to better... visualize (LOL) the lay of the land. I will forward it when i have it completed then I hope we can continue the architectural discussion here! Thanks -Garot garotconk...@yahoo.com From: Garot Conklin garotconk...@yahoo.com To: Garot Conklin garotconk...@yahoo.com; webmas...@lisol.co.uk webmas...@lisol.co.uk; 'Martin Gainty' mgai...@hotmail.com; mysql@lists.mysql.com mysql@lists.mysql.com Sent: Tuesday, August 21, 2012 4:40 PM Subject: Re: Machine Learning to elaborate: I would
Re: Machine Learning
I have not as yet created the visual or really mapped anything out yet, it has been a somewhat oddly long working strectch for me this last week, so I will have some time to myself on Sunday of this week to work solely on this effort. garotconk...@yahoo.com From: webmas...@lisol.co.uk webmas...@lisol.co.uk To: 'Garot Conklin' garotconk...@yahoo.com; 'Martin Gainty' mgai...@hotmail.com; ag4ve...@gmail.com Cc: mysql@lists.mysql.com Sent: Friday, August 24, 2012 4:04 AM Subject: RE: Machine Learning Hi Garot, How is the visual diagram coming along ? I'd be good to have a good idea of core system specifics so that DB design can be tailored to that ... of course, knowing that things will change as the concept evolves. Thanks, Justin -Original Message- From: Garot Conklin [mailto:garotconk...@yahoo.com] Sent: 23 August 2012 20:14 To: Martin Gainty; ag4ve...@gmail.com Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com Subject: Re: Machine Learning That is in fact a very interesting approach... I like it very much. Any architectural thoughts on an auto-population attempt? Odly I have not created a db like this before, not from this large of an import anyway... Please share some thoughts there and I will get that rolling... seems that if we can get something physical going I would like to offer it up as a sandbox to all those interested. I have a few X336's lying around my house just collecting dust, they would be a great testing environment for all to work on. garotconk...@yahoo.com From: Martin Gainty mgai...@hotmail.com To: ag4ve...@gmail.com; garotconk...@yahoo.com Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com mysql@lists.mysql.com Sent: Thursday, August 23, 2012 11:30 AM Subject: RE: Machine Learning Shawn and Garot I like the parsing capability of the lucene and its ability to stem incoming queries.. If you are able to start populating your data then we *should* be able to start identifying which root terms we can pull for building lucene-indexes I have an upcoming stuck-in-JFK-airport-on-labor-day-waiting-for-the-next-am-flight-of-USscare for an interrupted timeframe(i never learned how to 'sleep' in airport terminal) as long as I can find a wifi connection (and an AC connection within 6 hours) and use a working MySQL JDBC connection string..I should be able to bang out a quick prototype.. Let me know how i can help out, Martin Gainty __ ..place long-winded disclaimer here.. From: ag4ve...@gmail.com Date: Thu, 23 Aug 2012 10:42:55 -0400 Subject: Re: Machine Learning To: garotconk...@yahoo.com CC: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com just a few thoughts (things to look into) if you want to populate a db with command parameters, i'd mine the man pages. it's a consistent format and you should be able to find a parser for whatever language you prefer. if you want to see what has been entered and statistics about that process, look at the audit framework. it won't tell you success or failure, but you might be able to derive that based on the time, memory, and process usage that you can get from audit. auditd also maintains a db - you might look into the engine and schema they use. you might also find some interesting topics looking into language processing (after all, commands are a type of language). people generally use other database engines to do this type of thing - elastic search or some other things people have done with lucene maybe. do let us know where you go with this. it sounds quite interesting (and might help me with something i've been looking into)... and getting zsh to autocomplete options might be a bonus if you parse man pages and shove it into a db (i might do that part for you if i get a lazy afternoon). On Wed, Aug 22, 2012 at 7:51 PM, Garot Conklin garotconk...@yahoo.com wrote: I am going to work up a visual diagram for this to better... visualize (LOL) the lay of the land. I will forward it when i have it completed then I hope we can continue the architectural discussion here! Thanks -Garot garotconk...@yahoo.com From: Garot Conklin garotconk...@yahoo.com To: Garot Conklin garotconk...@yahoo.com; webmas...@lisol.co.uk webmas...@lisol.co.uk; 'Martin Gainty' mgai...@hotmail.com; mysql@lists.mysql.com mysql@lists.mysql.com Sent: Tuesday, August 21, 2012 4:40 PM Subject: Re: Machine Learning to elaborate: I would almost rather qualify from the OS perspective what will work in advance, but take into consideration any failing condition. I may be getting a bit too specific at this juncture however as I am already apply this logic to issues I see in MY environment rather than total ambiguity, which is a best position here. I am ultimately expecting the
Replication question: How to make a slave a master?
I have a couple of mysql database slaves and would like to make one of them be a master as well so that I can set another machine to replicate from it. Can anyone tell me how I should go about it or know of any howtos for this specific task? Thanks, Richard
Re: Replication question: How to make a slave a master?
Am 24.08.2012 17:25, schrieb Richard Reina: I have a couple of mysql database slaves and would like to make one of them be a master as well so that I can set another machine to replicate from it. Can anyone tell me how I should go about it or know of any howtos for this specific task? add the same master-conig lines as you did on the other master there is no magic, master-configurazion does not have any impact to slave-operation and vice versa signature.asc Description: OpenPGP digital signature
RE: Replication question: How to make a slave a master?
Pointing the other slave to the new master is a bit tricky. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, August 24, 2012 8:29 AM To: mysql@lists.mysql.com Subject: Re: Replication question: How to make a slave a master? Am 24.08.2012 17:25, schrieb Richard Reina: I have a couple of mysql database slaves and would like to make one of them be a master as well so that I can set another machine to replicate from it. Can anyone tell me how I should go about it or know of any howtos for this specific task? add the same master-conig lines as you did on the other master there is no magic, master-configurazion does not have any impact to slave-operation and vice versa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Replication question: How to make a slave a master?
what would be tricky? remove all relay-logs, remove master.info adn that was it done this many times in the last years and it takes 30 seconds if you are fast enough to type the slave-commands Am 24.08.2012 23:35, schrieb Rick James: Pointing the other slave to the new master is a bit tricky. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, August 24, 2012 8:29 AM To: mysql@lists.mysql.com Subject: Re: Replication question: How to make a slave a master? Am 24.08.2012 17:25, schrieb Richard Reina: I have a couple of mysql database slaves and would like to make one of them be a master as well so that I can set another machine to replicate from it. Can anyone tell me how I should go about it or know of any howtos for this specific task? add the same master-conig lines as you did on the other master there is no magic, master-configurazion does not have any impact to slave-operation and vice versa -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
RE: Replication question: How to make a slave a master?
It's the sequence that is tricky. 1. STOP SLAVE 2. CHANGE MASTER 3. START SLAVE Do it wrong, and you miss or duplicate replication stuff that happens between #1 and #2. Could you please lay out the precise steps, so that I can understand how un-tricky it can be. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, August 24, 2012 2:43 PM To: mysql@lists.mysql.com Subject: Re: Replication question: How to make a slave a master? what would be tricky? remove all relay-logs, remove master.info adn that was it done this many times in the last years and it takes 30 seconds if you are fast enough to type the slave-commands Am 24.08.2012 23:35, schrieb Rick James: Pointing the other slave to the new master is a bit tricky. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, August 24, 2012 8:29 AM To: mysql@lists.mysql.com Subject: Re: Replication question: How to make a slave a master? Am 24.08.2012 17:25, schrieb Richard Reina: I have a couple of mysql database slaves and would like to make one of them be a master as well so that I can set another machine to replicate from it. Can anyone tell me how I should go about it or know of any howtos for this specific task? add the same master-conig lines as you did on the other master there is no magic, master-configurazion does not have any impact to slave-operation and vice versa -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Replication question: How to make a slave a master?
* stop mysqld * rm -f mysql-relay-bin* * rm -f master.info * rm -f relay-log.info * start mysqld so, and now your slave is no longer any slave to make sure you are binary-identical with the new master stop the new master, remove all it's BINLOGS, not its relay-logs, stop the new salve, rsync the data, start both mywqld and start replication from slave this is really easy after you understand what each file in the datadir is supposded to do Am 24.08.2012 23:53, schrieb Rick James: It's the sequence that is tricky. 1. STOP SLAVE 2. CHANGE MASTER 3. START SLAVE Do it wrong, and you miss or duplicate replication stuff that happens between #1 and #2. Could you please lay out the precise steps, so that I can understand how un-tricky it can be. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, August 24, 2012 2:43 PM To: mysql@lists.mysql.com Subject: Re: Replication question: How to make a slave a master? what would be tricky? remove all relay-logs, remove master.info adn that was it done this many times in the last years and it takes 30 seconds if you are fast enough to type the slave-commands Am 24.08.2012 23:35, schrieb Rick James: Pointing the other slave to the new master is a bit tricky. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, August 24, 2012 8:29 AM To: mysql@lists.mysql.com Subject: Re: Replication question: How to make a slave a master? Am 24.08.2012 17:25, schrieb Richard Reina: I have a couple of mysql database slaves and would like to make one of them be a master as well so that I can set another machine to replicate from it. Can anyone tell me how I should go about it or know of any howtos for this specific task? add the same master-conig lines as you did on the other master there is no magic, master-configurazion does not have any impact to slave-operation and vice versa -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
Re: Replication question: How to make a slave a master?
Are you trying to promote a slave as a new master and replace current master or create intermediate slave? If it is the latter all you need to do is to: 1. Stop the slave 2. Add log_slave_updates = 1 in the slave's config file 3. Copy the slave files to the new slave(s) 4. Start your intermediate slave 5. Add replication user on your intermediate slave and allow new slaves to replicate 6. Start your slave(s) of intermediate slave 7. Issue following on your new slaves: CHANGE MASTER TO master_log_file = 'mysql-bin.01', master_log_pos = 4; On Aug 24, 2012, at 11:25 AM, Richard Reina wrote: I have a couple of mysql database slaves and would like to make one of them be a master as well so that I can set another machine to replicate from it. Can anyone tell me how I should go about it or know of any howtos for this specific task? Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql