asked on

MaxScale replacement that can work with mysql-connector-java-5.1.37-bin.jar

we are currently using Pentaho Data Integrator 8.2.0.0-342
which only works with this JDBC driver
mysql-connector-java-5.1.37-bin.jar
so for Pentaho Data Integrator 8.2.0.0-342 we would need to find a MaxScale replacement that can work with mysql-connector-java-5.1.37-bin.jar
And for the rest of Techsolutions Java apps we currently use this, because of the older MaxScale version we are running. But can upgrade this to whatever can be supported.
<mariadb.version>2.5.0</mariadb.version>

<dependency>
<groupId>org.mariadb.jdbc</groupId>
<artifactId>mariadb-java-client</artifactId>
<version>${mariadb.version}</version>
</dependency>

CEHJ

we are currently using Pentaho Data Integrator 8.2.0.0-342

Why such an old version?

Faith Victory

ASKER

@cehj
we would need to find a MaxScale replacement that can work with mysql-connector-java-5.1.37-bin.jar

CEHJ

These are commercial products you're using. You should really be going to them for support

skullnobrains

or just setup a mariadb gallera cluster for free and forget about entirely useless stuff.

the jdbc native connector supports failover. specify multiple hosts or a dns name (do check failover works in this last case ; i am not entirely sure about how jdbc handles multiple hosts under the same a record). multiple hosts do work perfectly. be done with it.

Faith Victory

ASKER

@skullnobrains
According to my boss, (Galera Cluster is a active/active cluster that had previously been discounted because of various issues with it. Mainly latency for commits over slower remote connections (ie HA site) to update all active cluster nodes).

ASKER CERTIFIED SOLUTION

skullnobrains

membership

This solution is only available to members.

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

Start Free Trial

Faith Victory

ASKER

Thanks everyone! I will go ahead and share your suggestions.