I have a MySQL database that we use for IDS systems. We would like to create a second database in a remote location and replicate DB1 with DB2. I found plenty of information about setting up database replication with MySQL, but it seems they are do replication in near real time.
Is there a way I can set up replication to only take place at night? This would help reduce stress to our WAN link.
Both databases would be running on RHEL6.