DBdumper is a easy distributed network system for creating database dumps and restoring databases, managed via Web interface
It consists of three components
All components interact with REST RPC over HTTPS.
2018-Jan-12: Now I install first release DBdumper for regular backups 12 corporate finance databases what cover ~2000 staff.
2018-Jan-24: Now I install next release for all corporate DBMS for validation stage
Roles/user management, logging and other function now in development.
That is, the data storage/recovery model is “any to any”
But you/I/we can wrote interface for manage MySQL/MS SQL/… DBMS.
It may use around 200-300 code string.
I used a very simple kind of RPC over HTTP, basically abstracted 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
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