asked on

DML and DDL operation during MariaDB failing over.

hi,

I am now testing any MariaDB dML and DDL operation when apply through maxscale, when failover during DDL and DML operation, the transaction will keep going even switch nodes, is it possible that connection do not drop during failover?

what version of maxscale and mariadB can support this?

what parameter can make this happen in maxscale and mariaDB?

I just knew oracle TAF component can make it happen !

I want transcation level failover man and when failover, it is transparent to application.

Mark Geerlings

Yes, Oracle can support TAF (Transparent Application Failover) in an Oracle RAC system, at least according to the documentation, and under some circumstances. But that doesn't mean that all other SQL-based databases can support this! That may be one reason some people and organizations are willing to pay for Oracle rather than switching to a cheaper alternative.

marrowyung

ASKER

yeah. but I am not referring to Oracle, I am focusing on MariaDB. any idea ?

ASKER CERTIFIED SOLUTION

Mark Geerlings

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marrowyung

ASKER

ok, then this mean I have to close this ticket, tks for your help man.

marrowyung

ASKER

this can also help to answer some of my concern:

http://galeracluster.com/documentation-webpages/schemaupgrades.html

but not totally.