Skip to main content
Planning to Do Database Replication? Here's a solution with MySQL

Savitha Nair writes "This article describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (such as a slave). All updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup method or policy because an accidentally issued DELETE or ALTER command will also be carried out on the slave; but replication can help protect against hardware failures."

Need help to do it? Visit www.commgate.net and get a CommGate Professional Server with built-in MySQL database server.
Labels:

Comments

Post a Comment

Popular posts from this blog

Strategic Plan vs. Operational Plan

Strategic Plan Vs. Operational Plan: Do You Know the  5 Main Differences ? What's the difference between a Strategic Plan vs. an Operational Plan? Both are plans but are they the same? If not, what’s the difference? Do you need both? Why do we need both?  After mentoring Start-Ups from pre-revenue to achieving at least S$1M in revenues since 2012 and supporting growing Small-Medium Enterprises within the S$4M to S$10M range revenues, whose leadership teams are stuck in their day to day operational matters and fire-fighting, I hear these questions frequently.  My response: A  strategic plan  outlines your Vision, Mission, Core Values to build the Culture with high-level goals for the next 3 to 5 years. It also takes into account how you’ll measure those goals, and the major projects you’ll take on to meet them. An  operational plan  (also known as a  work plan ) is an outline of what each of your business d...
Post a Comment
Read more

From Toilet Cleaner to CEO

On 22-April-2012, my entrepreneurship journey story was published by The Sunday Times in Singapore by Mr. Wong Kim Hoh
1 comment
Read more
Howto Deploy Ethernet MAC Address Filtering on CommGate 3.x Download Notepad++ from http://notepad-plus.sourceforge.net/uk/site.htm to edit the following text files from a Windows PC. You can then convert the text files into Windows and UNIX modes easily. Using Notepad++, create a text file and save it as rc.firewall.macaddr in /etc/rc.d directory. Add all the Ethernet MAC Addresses into file /etc/rc.d/rc.firewall.macaddr (one MAC Address per line) to filter it via the firewall rules in the following format; MACADDRS="\ 11:22:33:44:55:66 \ aa:bb:cc:dd:ee:ff \ 66:55:44:33:22:11" Note: Please change the MAC addresses with your own. Using WinSCP3 (downloadable from http://winscp.net/eng/download.php ), login to the CommGate 3.x system as user root and double-click on the following file /etc/rc.d/rc.firewall.local ( Note: Save a copy of the original file for backup purposes before you edit it as a precaution). Add the customize rule...
Post a Comment
Read more