asked on

Functional test when comparing MySQL Cluster and MariaDB cluster.

hi,

I am going to do some functional test when comparing MySQL Cluster and MariaDB, I know MariaDB by some studies, is faster when compression is on. So any kind of test make mariaDB stand ahead of MySQL cluster and any test can be make to show MySQL cluster is faster than MariaDB?

1) I will do simple select statement and failover.
2) will simple select statement with compression is on and during the select statement is running, I try failover back and forward.
any thing else can show difference of 2 ?

ASKER CERTIFIED SOLUTION

theGhost_k8

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

"Hope you meant to compare Mariadb cluster with MySQL Cluster and not a single mariadb instance.."

yes! of course ! MaraiDB with Maxscale and MySQL cluster with proxySQL.

marrowyung

ASKER

but that one is for old version of them , right ?

SOLUTION

Tomas Helgi Johannsson

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

hi,

also any load test driver for MySQL cluster and MariaDB ?

for this product test, what files system should I use redhat linux installation ?

theGhost_k8

I guess you can try with mysqlslap or sysbench.

marrowyung

ASKER

I am sorry, what do you want me to test ?

theGhost_k8

"So any kind of test make mariaDB stand ahead of MySQL cluster and any test can be make to show MySQL cluster is faster than MariaDB?"

Use any of above tools to benchmark... which answers your above question.

marrowyung

ASKER

tks.