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

OpenProj - FREE alternative to Microsoft Project I wanted to share with all of you about Projity's important announcement last week at LinuxWorld. Projity announced the release of OpenProj, a FREE (yeah, another FREE software) and open source replacement of Microsoft Project. OpenProj is available on Windows, Linux, Unix or Mac and is interoperable with Microsoft Project. The best thing is, it even opens existing MS Project files! How cool is that? I read on OpenProj website that OpenProj has been downloaded on an average every 35 seconds around the clock at http://www.projity.com since they launched and made the software available last week. OpenProj is now in the 99.99th percentile for activity on Sourceforge.net and is quickly becoming one of the most used open source solutions worldwide. The OpenProj folks are expecting about 11 million worldwide users and in my opinion, this has been an excellent start for them. MS Project has been a key strategic solution for Micro...
1 comment
Read more

High-speed wireless video transfers 100X faster than WiFi

IBM is looking to change the way you watch video. The company today is announcing microprocessor chipsets that can wirelessly transmit high-definition video between computers, televisions and handheld devices in the time it takes to push the Play button. IBM will do this by teaming with MediaTek to launch a joint initiative to develop these ultra fast chipsets that will let users rid their homes and offices of the cumbersome wires needed to connect their HD-TVs to set top boxes and or other devices. The companies will be developing millimeter wave (mmWave) radio technology -- the highest frequency portion of the radio spectrum -- 60 gigahertz rather than 2.4 gigahertz -- and digital chipsets that enable at least 100 times higher data rates than current Wi-Fi standards, IBM said in a release. Users could upload a 10 gigabyte file in five seconds with the new technology versus 10 minutes using current Wi-Fi technology. mmWave wireless technology can be widely used at home and...
Post a Comment
Read more
In early April 2006, I sign-up for the Excellerated Business School for Entrepreneurs (BSE) after a preview session held in Singapore by Executive-Directions. The seminar was held from 15 April to 23 April 2006 in Subang Jaya Hotel in Kuala Lumpur, Malaysia. The BSE in KL was organized by GlobeSL Sdn Bhd. I left Singapore on 14 April via Transtar , the only 1st class coach service which has 16 seats to create a lot of room for your leg. They also provide hot meal during the journey with hot drinks on demand. The seats are equipped with a massage chair, a personal in-flight entertainment system on LCD screen, PC Games and the F&B Attendant will provide anything that you ask for. From newspaper, magazines, blanket, hot/cold drinks, a new set of earphones for the entertainment system... they have it all. They are most courteous and polite at all times. I truly enjoy the Transtar service. For SG$50 from Singapore to KL, it's worth it. I arrived in Subang Jaya Hotel at about 10p...
Post a Comment
Read more