DBdumper is a easy distributed network system for creating database dumps and restoring SQL databases, managed via Web interface
You can manage databases easy like file in your file system.
Roles/user management, logging and other function can easy added.
The application code is object-oriented and a addition of functionality requires addition of methods without changing application architecture.
That is, the data storage/recovery model is “any to any”
You can install dbagent to any system in network but I install agents into the same system where run database management system.
The dbstore can also install to any physical or virtual system with a reliable network band and conditions for storing backup copies
Format of dumps is gzip compressed SQL, dump name agreement is DBNAME–TIMESTAMP-TZ–SOURCE.HOST.sqlz
The kit of application consists of three components
All components interact with authenticated REST RPC over HTTPS.
I used a very simple kind of RPC over HTTP, isolated from the transport layer. Procedure parameters are sent as parameters GET/POST, responses is sent as JSON structure. In future it is very easy to replace to full JSON RPC 2.0
Please, send my to firstname.lastname@example.org if found.
Master interact with Agent(s) using commands (Web REST RPC)
Master with Store(s)
Agent(s) with DBMS(es) interact using native SQL API
See also RESTful APIs, the big lie
apt-get -y install libjs-prettify apt-get -y install libdbd-pg-perl apt-get -y install libdbi-perl apt-get -y install libapache-htpasswd-perl apt-get -y install libfilesys-df-perl apt-get -y install libev-perl apt-get -y install libio-socket-ip-perl wget http://wiki.unix7.org/_media/dist/jessi/libmojolicious-perl_7.43_dfsg-1_all.deb wget https://wiki.unix7.org/_media/dist/dbagent_0.01.4-1_all.deb wget https://wiki.unix7.org/_media/dist/dbstore_0.01.4-1_all.deb dpkg -i *.deb && rm -v *.deb