I’m new to developing with ERPNext. I’m interested in seeing if I can integrate it with some of my existing systems, but they all use Percona DB and we can’t switch. I had a couple of questions:
I noticed MariaDB is the recommended option, however will EPRNext also work fine with Percona DB?
We use Percona’s cluster replication (PXC) for high availability for our databases. PXC isn’t compatible with MyISAM or ARIA tables. Does ERPNext use any MyISAM or ARIA tables, or are they all InnoDB / xtraDB?
In fact, MariaDB should play well with your other software, as it is compatible with MySQL and provides a much more stable InnoDB implementation called XtraDB (by Percona).
I figured that since Percona invented XtraDB and therefore fully supports XtraDB tables, it should work fine. But I just wanted to check first. We’re really happy with Percona and have lots of systems built around it, so we don’t want to switch. And we’d prefer to not have to run a second MySQL server just for ERPNext if we can avoid it
Great, thanks all! Will give it a shot and report back.
@Pawan One suggestion- if the error log is using MyISAM (I’ll check this and let you know) then I think it’s worth switching it to InnoDB as well, unless it’ll break something. MariaDB’s built-in Galera replication is becoming really important for high availability and it doesn’t support replication of MyISAM tables. Percona PXC also uses Galera for replication.