Showing results for 
Search instead for 
Did you mean: 

Magento 2 Percona-XtraDB-Cluster


Magento 2 Percona-XtraDB-Cluster

Have anyone trying to setup magento 2 in clustered environment ? It seems like magento temp tables (with MEMORY Storage engine) not working with Percona-XtraDB-Cluster which allows only InnoDB Storage engine

I am trying to run Magento 2 in clustered environment with 3 DB nodes using Percona-XtraDB-Cluster but I got this error during magento installation.

[ERROR] PDOException: SQLSTATE[HY000]: General error: 1105 Percona-XtraDB-Cluster prohibits use of ALTER command on a table (magento2cluster.catalog_product_index_eav_tmp) that resides in non-transactional storage engine (except switching to transactional engine) with pxc_strict_mode = ENFORCING or MASTER in /var/www/html/cluster/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:2


when I change from pxc_strict_mode from ENFORCING the installation completed successfully but when I try to add new product from admin panel I got below error

'main.CRITICAL: Warning: PDOStatement::execute(): MySQL server has gone away in '