Keep It Simple, Stupid | |
PerlMonks |
DBI/MySQL/MariaDB clone tables across DB Connectionsby LanX (Saint) |
on Feb 15, 2023 at 11:01 UTC ( [id://11150394]=perlquestion: print w/replies, xml ) | Need Help?? |
LanX has asked for the wisdom of the Perl Monks concerning the following question:
Hi I'm doing complex insertion operations of hierarchical data between tables. This works quite well, as long as the tables are available within the same DB connection. Now I have the requirement to allow these across different MariaDB servers, with the same schema. I already have a solution to use an intermediary temporary table and could
FWIW: dumping to file is not an option, the transferred data is relatively small and I prefer the flexibility of having the data in memory.
Cheers Rolf
Back to
Seekers of Perl Wisdom
|
|