The feature you are looking for is replication, I have used that in MySQL many times to do the exact thing you are talking about, works great.

Example - http://blog.onetechnical.com/2012/05/29/quick-mysql-replicat...