Skip to content

molindo/molindo-dbcopy

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

molindo-dbcopy

Incrementally compare and synchronize MySQL databases.

Usage:

wget -O molindo-dbcopy.jar https://oss.sonatype.org/service/local/repositories/snapshots/content/at/molindo/molindo-dbcopy/0.1.0-SNAPSHOT/molindo-dbcopy-0.1.0-20140210.131708-1.jar
cat > dbcopy.properties <<PROPS
source.jdbc=jdbc:mysql://localhost/db1
source.user=user1
source.pass=pw1
source.pool=2

target.jdbc=jdbc:mysql://localhost/db2
target.user=user2
target.pass=pw2
target.pool=4

db.dry_run=true
db.disable_unique_checks=true

task.tables.include=*

task.queries.q1.query=select ... order by ...
task.queries.q1.table=Q1_TARGET
task.queries.q2.query=select ... order by ...
task.queries.q2.table=Q2_TARGET
PROPS

java -jar molindo-dbcopy.jar

Maven:

<dependency>
  <groupId>at.molindo</groupId>
  <artifactId>molindo-dbcopy</artifactId>
  <version>0.1.0</version>
</dependency>

Releases available from Maven Central, snapshots from oss.sonatype.org.

CI Build:

Build Status

About

Incrementally copy remote MySQL databases

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages