i have a mysql server on a local machine but the connection is not got for users outside the local network. I want that database to be available on another server wich can handle way more requests and is more stable than the local server. My question is: What is the best way to replicate the data from the local server into the web server? I've readed a little about slave servers, are they made for this case? If i use a mysql slave server and the internet on the main server goes offline, what happens to the slave? If the main server makes some database changes while offline will these changes be written on the slave when the master goes online again? Are there any performace loss for using a slave server?
I do not want a backup server, i want a server to redirect ouside queries into it, so the main server wont be affected for huge traffic and etc.