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......
  • A closer look at x11vnc I've got to say, one of the things I really like about linux are the myriad of options for remotely administering a system. SSH is the one I use the most, but for the graphical you have x (especially on the LAN), nxserver (which is a compressed and optionally encrypted......
  • Software raid under linux (Ubuntu 6.06 Dapper Drake) First, I should disclaim that this is going to be a brain dump of the resources and experience of a quick setup of Ubuntu 6.06 on a software raid based storage system. This may be less than ideal, but is doable and seems relatively solid as a system. First off,......
Blog Traffic Exchange Related Websites
  • 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......
  • 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......
  • 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......
PDF24    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