marrowyung
asked on
percona, MySQL and MariaDB
hi,
May I know the difference between Percona xtra Cluster, MySQL InnoDB cluster and MariaDB Galeria cluster?
percona monitor and management software:
https://www.percona.com/software/database-tools/percona-monitoring-and-management
suppose to monitor and management all these DB cluster? I want to know cross site failover failure as well and the root cause of it.
May I know the difference between Percona xtra Cluster, MySQL InnoDB cluster and MariaDB Galeria cluster?
percona monitor and management software:
https://www.percona.com/software/database-tools/percona-monitoring-and-management
suppose to monitor and management all these DB cluster? I want to know cross site failover failure as well and the root cause of it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"Note that Percona XtraDB Cluster is just MariaDB Galera Cluster that they have patched/altered to include additional features. "
so XtraDB cluster is just mariaDB...what mariaDB is missing from XtraDB Cluster ,..... ?
so XtraDB cluster is just mariaDB...what mariaDB is missing from XtraDB Cluster ,..... ?
ASKER
Tomas Helgi Johannsson ,
percona Xtracluster really runs as MariaDB as according to the configure file, and it seems MariaDB is not that very good ! as it also has the whole operation held when doing a lot of delete and backup DB!
InnoDB problem! and the powerpoint say sth very powerful but some is not true ! no REAL multi write operation actually.
but one thing, it seems make MariaDB galera cluster and percona Xtacluster the SAME to Compare with MySQL group replication ! we use percona and it see it is MariaDB..
what is the different between percona and mariaDB then.... .. ?
percona Xtracluster really runs as MariaDB as according to the configure file, and it seems MariaDB is not that very good ! as it also has the whole operation held when doing a lot of delete and backup DB!
InnoDB problem! and the powerpoint say sth very powerful but some is not true ! no REAL multi write operation actually.
but one thing, it seems make MariaDB galera cluster and percona Xtacluster the SAME to Compare with MySQL group replication ! we use percona and it see it is MariaDB..
what is the different between percona and mariaDB then.... .. ?
ASKER
as we have this problem:
https://www.experts-exchange.com/questions/29189827/Communications-link-failure-from-web-server-WildFly-9-0-2-which-connect-to-ProxySQL.html?anchor=a43130668¬ificationFollowed=256320178#a43130668
and I am not sure an upgrade to latest Percona xtracluster is a good idea ! we are using percona xtracluster based on MySQL 5.7, any best/safe way to upgrade to percona xtracluster based on MySQL 8.0 ?
https://www.experts-exchange.com/questions/29189827/Communications-link-failure-from-web-server-WildFly-9-0-2-which-connect-to-ProxySQL.html?anchor=a43130668¬ificationFollowed=256320178#a43130668
and I am not sure an upgrade to latest Percona xtracluster is a good idea ! we are using percona xtracluster based on MySQL 5.7, any best/safe way to upgrade to percona xtracluster based on MySQL 8.0 ?
ASKER
please also help on this:
https://www.experts-exchange.com/questions/29189827/Communications-link-failure-from-web-server-WildFly-9-0-2-which-connect-to-ProxySQL.html?anchor=a43130668¬ificationFollowed=256320178#a43130668
very important question