mydumper
Official MyDumper Project (by mydumper)
symmetric-ds
SymmetricDS is database replication and file synchronization software that is platform independent, web enabled, and database agnostic. It is designed to make bi-directional data replication fast, easy, and resilient. It scales to a large number of nodes and works in near real-time across WAN and LAN networks. (by JumpMind)
| mydumper | symmetric-ds | |
|---|---|---|
| 25 | 12 | |
| 2,355 | 693 | |
| 1.4% | 1.2% | |
| 9.6 | 9.5 | |
| 3 days ago | 1 day ago | |
| C | Java | |
| GNU General Public License v3.0 only | - |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
mydumper
Posts with mentions or reviews of mydumper.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-11-03.
-
Restore or Migrate your MySQL Database to Railway
You can create a MySQL backup for Railway.app using the MyDumper tool or by using a backup service like SimpleBackups. Both methods involve generating a dump file that can be used for restoration.
-
Has anyone ever restored a 15GB db from mysqldump?
Maybe check mydumper which uses a multi-threaded multi-file approach so that backups are faster, but more important, restores are faster. Plus it makes it way easier to do a partial recovery (for instance, a specific table).
-
Recommend me an Azure-native solution for archival and encryption
It looks like MyDumper added support to invoke PGP, etc. https://github.com/mydumper/mydumper/issues/101
-
mysqldump for innodb + myisam mixed db
Either xtrabackup, or mydumper.
-
Is --single-transaction enough to protect mysqldump while backing up a replication replica?
Use mydumper. It has lightweight locking that can produce consistent backups without stopping replication. It also has multi-threaded sharding so it can backup much faster.
-
MariaBackup Restore to Second 'test' database
Agree with you, just let me suggest mydumper as a parallel and compressed version of mysqldump, much faster way to export and import tables- unless your tables are tiny.
-
Is replication between v5.1 and v8 possible?
Take a snapshot backup of the 5.1 server with mydumper.
-
How to transfer data across MySQL 5.7 servers, from Windows to Ubuntu?
Either way, use mydumper. It is much faster than basic mysqldump.
-
Fastest method of making a copy of a database on another server?
Check out mydumper it's multithreaded and way faster than mysqldump.
-
Migrating a database to a new server?
Better than basic mysqldump is mydumper. It has a bunch of nice features like multi-threaded parallel dumping. It can cut the dump/restore time by a huge amount.
symmetric-ds
Posts with mentions or reviews of symmetric-ds.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-08-14.
- FLaNK Stack Weekly for 14 Aug 2023
-
SymmetricDS: Open-Source, cross platform database replication software
For those interested in the source, here is the GitHub repo: https://github.com/JumpMind/symmetric-ds
-
How do I add database replication across different servers to my Docker Compose deployment without using different Docker files on each server?
I’m not a database guy, but maybe look at symmetricds. Also at https://hub.docker.com/r/jumpmind/symmetricds.
-
Seamless integration of Databases
There are several CDC (change data capture) solutions on the market. I've used https://www.symmetricds.org quite successfully in the past.
- Dockerfile for jumpmind image
-
How do you "ship out" web-based systems na isang establishment lang gagamit?
And then using https://www.symmetricds.org/ with mongodb
-
migrate giant 17TB DB from mariadb10.4 to MySQL 8
Use replication. https://www.symmetricds.org/
- [AMA] We are the developers of SymmetricDS, a FOSS database synchronization project. Ask us anything
- SymmetricDS: Fast and Flexible Database Replication
- SymmetricDS: Database Synchronisation Solution
What are some alternatives?
When comparing mydumper and symmetric-ds you can also consider the following projects:
zstd - Zstandard - Fast real-time compression algorithm
Flyway - Flyway by Redgate • Database Migrations Made Easy.
rsync - An open source utility that provides fast incremental file transfer. It also has useful features for backup and restore operations among many other use cases.
walrus - Applying RLS to PostgreSQL WAL
volumerize - Docker Volume Backups Multiple Backends
pglogical - Logical Replication extension for PostgreSQL 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
RMySQL - Legacy DBI interface for MySQL
obevo - Obevo is a database deployment tool that handles enterprise scale schemas and complexity
mydumper - Official MyDumper project [Moved to: https://github.com/mydumper/mydumper]
LINQ to DB - Linq to database provider.
mysqld_exporter - Exporter for MySQL server metrics
scalardb - Universal transaction manager