The answer is this...
You can use replication in mysql, mysql is the database software. In order to do what you are asking that is the answer, you need to learn about mysql and use the replication feature of it. The link above gives you a full how too on it.
--------------- Added [DATE]1215845564[/DATE] at [TIME]1215845564[/TIME] ---------------
Here are the links again in case you missed it.
18.1.1. How to Set Up Replication
[+/-]
18.1.1.1. Creating a User for Replication
18.1.1.2. Setting the Replication Master Configuration
18.1.1.3. Setting the Replication Slave Configuration
18.1.1.4. Obtaining the Master Replication Information
18.1.1.5. Creating a Data Snapshot Using mysqldump
18.1.1.6. Creating a Data Snapshot Using Raw Data Files
18.1.1.7. Setting Up Replication with New Master and Slaves
18.1.1.8. Setting Up Replication with Existing Data
18.1.1.9. Introducing Additional Slaves to an Existing Replication Environment
18.1.1.10. Setting the Master Configuration on the Slave
|