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
  • Codeweavers releases beta of Windows compatibility software for Apple Mac OS X Yesterday codeweavers announced a beta release of their Crossover Office product geared towards Apple Mac OS X users. The software will allow certain windows applications to run on top of Apple's operating system. They're of course, seeking feedback and suggestions for what direction to take the project. This is based......
  • Ultravnc for remote computer support A little while back I talked some about TightVNC which for a long time has been my favorite implementation of a remote framebuffer, or remote desktop viewing protocol known as VNC (Virtual Network Computing.) The original VNC (now realvnc) came out of AT&T research labs in the UK and has......
  • Tech support tutorials made easy on linux.... One of the real frustrations with phone tech support is translating step by step what is needed to the person on the other end. I know it sounds easy, but in reality - what if they've got xyz theme for their menuing and it's not there, what if... oh you......
Blog Traffic Exchange Related Websites
  • 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......
  • 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......
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