<div>
You could make an initial dump and play it into the second database server. Then once per day you run &quot;flush logs&quot; and script-copy the latest binary log file &nbsp;to the second server and import it there.<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html</a>
</div>


You could make an initial dump and play it into the second database server. Then once per day you run "flush logs" and script-copy the latest binary log file  to the second server and import it there.
http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html [http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html]

<div>
multimac's solution will also work, but it involves multiple steps including transferring of binary logs. &nbsp;I see it has one advantage though - once you run the binary logs you know you're done - unlike the master-slave replication where you need to check the status.
</div>


multimac's solution will also work, but it involves multiple steps including transferring of binary logs.  I see it has one advantage though - once you run the binary logs you know you're done - unlike the master-slave replication where you need to check the status.

<div>
@joahnntagle,<br />
<br />
So I would put those script on the slave server correct?
</div>


@joahnntagle,

So I would put those script on the slave server correct?

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


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.

Thanks

Both databases would be running on RHEL6.

Replicate MySQL database once per day

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.