Slide

  • LINUX

    LINUX:In 1969 AT&T made a decision to withdraw Multics and go with GECOS (General Electric Comprehensive Operating Supervisor / System), with AT & T in Bells Lab when Multics was withdrawn some of the programmers named Ken Thompson and Dennis Ritchie decided to rewrite operating system in order to support low cost computer..To Know More

    CLICK HERE

  • MICROSOFT

    MICROSOFT:Microsoft was established to develop and sell BASIC interpreters for the Altair 8800. It rose to dominate the home computer operating system market with MS-DOS in the mid-1980s,followed by the Microsoft Windows line of operating systems. To Know More

    CLICK HERE

  • CISCO

    CISCO:During the early 1980s, there was a married couple namely Len and Sandy Bosack who used to work in two different departments of computer located in Stanford University. This couple was facing problem in making their computers communicate with each other To Know More

    CLICK HERE

showinfo=1

Dumping MYSQL Database from Master and Restoring it to Slave



Dumping MYSQL Database from Master and Restoring it to Slave



xtrabackup (online snapshot of mysql database without locking the tables)

#rpm -ivh http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

#yum -y install percona-xtrabackup.x86_64

option 1
the below command both have to be done simultanously

#nice -n20 innobackupex --parallel=5 /home/admin/downloads/mysql/
#nice -n20 innobackupex --apply-log /home/admin/downloads/mysql/2012-12-26_16-02-25


zip the contents of the above folder with tar -zcvf and download the same to the slave server
mv the existing mysql directory if exists and create a new one with the same permissions and unzip the contents into this directory, thereafter chown it to mysql.mysql -R
copy the contents of backup-my.cnf to the my.cnf file on the slave machine replace if already existing
cat xtrabackup_binlog_info file in the mysql data directory
type mysql followed by enter and

CHANGE MASTER TO MASTER_HOST='server-IP',MASTER_USER='dbadmin',MASTER_PASSWORD='db9436mst',MASTER_LOG_FILE='master-bin.000972',MASTER_LOG_POS=16498231,MASTER_CONNECT_RETRY=5;

51 comments:

  1. Believe in yourself! Have faith in your abilities! Without a humble but reasonable confidence in your own powers you cannot be successful or happy. See the link below for more info.

    #without
    www.mocsbar.com

    ReplyDelete
  2. Thanks you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.
    oxicoa-health.com |

    ReplyDelete
  3. It was a positive conversation and each day since then he has made an effort to come and speak to her about his success of the day. 
    www.europetravel101.com |

    ReplyDelete
  4. Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include.
    collegenowtechprep.com |

    ReplyDelete
  5. I like the way you described the topic with such clarity. Thanks for Describing Everything.
    www.tour4peace.com |

    ReplyDelete
  6. I am very happy to read this. This is the kind of manual that needs to be given and not the random misinformation t hat's at the other blogs. Appreciate your sharing this best posting.
    http://www.autoverkade.com |

    ReplyDelete
  7. I really think that one of the best articles is this one. It has everything. I needed this information to prove wrong my teacher. I knew this was happening. But my teacher did not agree with me. Now, he'll know I was right! Thank you!
    autotronicseldh |

    ReplyDelete
  8. I'm impressed, I must say. Very rarely do I come across a blog that's both informative and entertaining, and let me tell you, you've hit the nail on the head. Your blog is important; the issue is something that not enough people are talking intelligently about.
    envisioncentraltexas.com |

    ReplyDelete

  9. I enjoy reading your articles. You really have a wonderful blogs. Keep up the good work. Thank you also for the information!

    Cara
    www.gofastek.com

    ReplyDelete
  10. Love it! Very interesting topics, I hope the incoming comments and suggestion are equally positive. Thank you for sharing this information that is actually helpful.


    ufgop.org
    ufgop.org

    ReplyDelete
  11. I like the way you described the topic with such clarity. Thanks for Describing Everything.
    http://www.lathamsinterior.com |

    ReplyDelete
  12. You have done a great job. I will definitely dig it and personally recommend to my friends. I am confident they will be benefited from this site. 
    HRM Open Home |

    ReplyDelete
  13. I’m reminded of the Lord of the rings quote – “Nothing said before the word ‘but’ really counts.
    http://www.bookworkssoftware.com |

    ReplyDelete
  14. packers and movers in india@
    https://quicksoluction.com
    packers and movers in delhi@
    http://quicksoluction.com/packers-and-movers-in-delhi.html
    packers and movers in mumbai@
    http://quicksoluction.com/packers-and-movers-in-mumbai.html
    packers and movers in pune@
    http://quicksoluction.com/packers-and-movers-in-pune.html
    packers amd movers in gurgaon@
    http://quicksoluction.com/packers-and-movers-in-gurgaon.html

    ReplyDelete
  15. Thank you for such a sweet tutorial - all this time later, I've found it and love the end result. I appreciate the time you spent sharing your skills.
    Run 3

    ReplyDelete
  16. Packers-and-movers-bangalore.in provides all the type of #moving solutions, no matter where you want to shift into the city or shift another city or another country ..
    Packers And Movers Bangalore Charges

    ReplyDelete
  17. I must say you had done a tremendous job,I appreciate all your efforts.Thanks alot for your writings......Waiting for a new 1...Please visit our wonderful and valuable website:
    Packers And Movers in Bangalore charges

    ReplyDelete
  18. It is one of the awesome site in my view as far as my knowledge is concerned about this kind website. Thanks for sharing!
    Packers And Movers Gurgaon
    Packers And Movers In Gurgaon charges
    Packers And Movers Bangalore to hyderabad

    ReplyDelete
  19. If you want to get in touch with dealkare packers and movers in Uttam Nagar, You must visit our website: www.dealkare.com

    Packers and Movers in Uttam Nagar

    ReplyDelete
  20. really a vry nice blog i really appreciate all your efforts ,thank you so mch for sharing this valuable information with all of us.
    Packers And Movers in Bangalore

    ReplyDelete
  21. I understand what you bring it very meaningful and useful, thanks.

    run3unblockedgame.com

    ReplyDelete
  22. I was very impressed by this post, this site has always been pleasant news. Thank you very much for such an interesting post. Keep working, great job! In my free time, I like play game: imgtaram.com. What about you?

    ReplyDelete
  23. ShiftingSolutions.in offers Free Quotes of Registered Movers and Packers Delhi Compare to save money and select the best.



    http://bit.ly/Newdelhi


    http://bit.ly/Newdelhi

    ReplyDelete

  24. Thank you for your post, I look for such article along time, today i find it finally. this post give me lots of advise it is very useful for me

    supersmashflash2s.com

    ReplyDelete
  25. Nice post.. really helpful.
    ShiftingSolutions.in offers Free Quotes of Registered Movers and Packers Delhi Compare to save money and select the best.

    For packers and Movers enquiry and help, plz visit-
    Packers and Movers in Delhi
    Packers and Movers Delhi
    Packer and Mover Delhi
    Movers and Packers in Delhi
    Delhi Packers and Movers

    ReplyDelete
  26. This blog is so nice to me. I will continue to come here again and again. Visit my link as well. Good luck
    obat aborsi
    cara menggugurkan kandungan
    cara menggugurkan kandungan

    ReplyDelete
  27. I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. I hope to have many more entries or so from you.
    Very interesting blog.
    www.baixarfacebookgratis.com.br

    ReplyDelete

Note:- Comment as: Option available to post without login select "Anonymous" from the drop down...........

For Latest Updates: Subscribe Now | | Test Your Knowledge, Take a Quiz now Click Here | | Site Best Viewed In Firefox

X