Welcome to the Treehouse Community
Looking to learn something new?
nicholas maddren12,793 Points
Live MySQL data updates?
Hey guys, I currently use a CSV file to update my database every 15 minutes using a cron job. This seems to be a little impractical as I really need live data and the whole CSV importing and replacing process is a little server thirsty.
Does anyone know of any methods to update a MySQL database with live data? For example let's say I have a called database1 on another server and I want to bridge any changes on database1 to my database which is named database2, how could I do this? It would need to post the changes instantly.
Jonathan Petersen45,548 Points
If I understand your question correctly, I believe you are asking about replication. There is some lag, but low in most cases.
Here is some links to MySQL replication resources --
Hopefully this will get you started.