RMySQL | mydumper | |
---|---|---|
1 | 26 | |
207 | 2,361 | |
0.5% | 1.7% | |
4.7 | 9.6 | |
5 months ago | 1 day ago | |
C | C | |
- | GNU General Public License v3.0 only |
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.
RMySQL
-
How to convert Blob from SQL to string?
Google came up with this, though I can't say it really looks like a likely winner.
mydumper
-
Ask HN: Any one still using MySQL?
Yes, but MariaDB, mostly DIY on localhost (various test & live VMs I manage).
Most painful? Replication with automatic failover could be easier to setup. Considering switching to MySQL 8.x for the new-ish innodb cluster tools (mysqlsh, mysql-router).
Why not Postgres? Familiarity, mostly using it for Drupal & Wordpress sites where MySQL is king. Besides the occasional poorly-designed query that eats memory and causes timeouts, MySQL rarely needs my attention.
Side note: I'm excited for https://github.com/mydumper/mydumper. Multi-threaded logical backups, 2 to 5 times faster than mysqldump. It's not super stable yet, so we haven't been relying on it for long term backups, but doing a "mydumper to grab a schema on live, rsync down to laptop, myloader to import" it's been a big time saver.
-
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.
What are some alternatives?
mydumper - Official MyDumper project [Moved to: https://github.com/mydumper/mydumper]
zstd - Zstandard - Fast real-time compression algorithm
Collapse Launcher - An Advanced Launcher for miHoYo Games
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.
catboost - A fast, scalable, high performance Gradient Boosting on Decision Trees library, used for ranking, classification, regression and other machine learning tasks for Python, R, Java, C++. Supports computation on CPU and GPU.
volumerize - Docker Volume Backups Multiple Backends
jsonlite - A Robust, High Performance JSON Parser and Generator for R
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.
qs - Quick serialization of R objects
kunlun - KunlunBase is a distributed relational database management system(RDBMS) with complete NewSQL capabilities and robust transaction ACID guarantees and is compatible with standard SQL. Applications which used PostgreSQL or MySQL can work with KunlunBase as-is without any code change or rebuild because KunlunBase supports both PostgreSQL and MySQL connection protocols and DML SQL grammars. MySQL DBAs can quickly work on a KunlunBase cluster because we use MySQL as storage nodes of KunlunBase. KunlunBase can elastically scale out as needed, and guarantees transaction ACID under error conditions, and KunlunBase fully passes TPC-C, TPC-H and TPC-DS test suites, so it not only support OLTP workloads but also OLAP workloads. Application developers can use KunlunBase to build IT systems that handles terabytes of data, without any effort on their part to implement data sharding, distributed transaction processing, distributed query processing, crash safety, high availability, strong consistency
mysqld_exporter - Exporter for MySQL server metrics