error is showing that, You are using old ibdata file. I would recommend, uninstall mariadb and install mysql back. Then take healthy backup.
And do fresh installation of mariadb and restore backed up data.
Reading the official documentation at Overview of the Binary Log (MariaDB | Knowledge Base) the first paragraph states:
The binary log contains a record of all changes to the databases, both data and structure, as well as how long each statement took to execute. It consists of a set of binary log files and an index.
If you rummage through MariaDB's ...
Based on the given code and scenario I would assume you are talking about Transactional Replication and that the command "DELETE FROM products.dial" that took place at the publisher was replicated to the subscriber. If this is the case it means that the table products.dial is defined as an article in your publication and one option that may or may ...
There's no tricks that can be done with ibdata1 files.
Look at using mydumper for parallel extraction and load.
pt-data-sync is a way to replicate the data with inbuilt protections against databsae delay. I don't know if it supports multisource
it s clearly telling you that it looks for INNOdb driver and can not find it.
that means that your filesystem can not read the needed files. try to repair the installation, if they are missing or look for the reason.
I recommend handling this requirement in the network vice the database configuration. Modern networking gear provide the flexibility to meet a range of requirements in a secure fashion.
I would setup routers on each end to preferentially route traffic over the dedicated link and failover to a route that is tunneled through an encrypted VPN over the internet....
I am still not sure why mariadb was giving me the error "INSERT is not insertable-into" and I cold not find any documentation that explains this was a mariaDB problem. If anyone has more information about this please share
In MariaDB 10.4, they have introduced some security-related changes. In particular, Authentication in MariaDB 10.4 — ...