MySQL setting up database replication



Database replication is one of those useful things that can really make your life simpler. It’s not really a way of backing up the data in a MySQL database, because if you inadvertently issue a command to delete the entire database, it won’t save you from yourself…. it will faithfully replicate the change to the slave servers. However, in the event of hardware failure or other abrupt disruption of connectivity, the concept of replicating from a master to a slave server is ideal.


How-to forge has a good writeup on how to get this kind of replication setup.

Related Posts

Blog Traffic Exchange Related Posts
  • Fantastic command reference for Windows, Linux, Apple and Oracle This is going to be a reference to a really great site. I've used this several times and it's wonderful. ss64.com Is a reference site that gives you a command lookup for Windows, Linux, Apple OS X, and Oracle. basically, you can browse and see the commands available, plus some......
  • Linux software raid notes Here are a few other notes on linux software raid. I created a directory called raidinfo to keep information in to make it easy to maintain the raid array. First... from the software raid howto, I've done the following.... sfdisk -d /dev/hda > /raidinfo/partitions.hda sfdisk -d /dev/hde > /raidinfo/partitions.hde So..........
  • Zarafa Exchange Server replacement and Postfix Integration for multiple domains with unique users So, I've spent some time recently working with Zarafa. It's an exchange replacement that has a completely open source version as well as a version with licenses for outlook if you want that level of integration. It's web interface looks good and is an improvement on Exchange server's capabilities with......
Blog Traffic Exchange Related Websites
  • How to Choose the Best Coin Collection Software Coin collecting is something which has been happening for over 200 years. There are collectors which have written many different books to help other collectors understand the different things to look out for when buying and selling coins. These books have been treasured by all those who are getting started......
  • Making More Money with a Masters Degree Millions of people are returning to school in the face of depressed job market. Having a masters degree seems to be the new bachelors degree. When the massive layoffs started to happen in the last few years, it's become really difficult for people. Even though they had years of experience......
  • Using MySQL In A Hosting Environment MySQL is a heavy-duty database server. Used with various software languages, most notably PHP, and part of the LAMP family (which is comprised of Linux, Apache, MySQL, and PHP), Whether it's a customer relations management list or medical records, any data you have that needs storing, is stored on a......
www.pdf24.org    Send article as PDF   

Similar Posts


See what happened this day in history from either BBC Wikipedia
Search:
Keywords:
Amazon Logo

Comments are closed.


Switch to our mobile site