is it possible to use MySQL Fabric with JIRA

[Piotr Pawlik]

Hi,

I wonder if JIRA can connect to MySQL Fabric.

I followed dev mysql instruction: https://dev.mysql.com/doc/mysql-utilities/1.5/en/connector-j-fabric-connect.html

Configured dbconfig.xml:
<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>mysql</database-type>
  <jdbc-datasource>
    <url>jdbc:mysql:fabric://localhost:32274/jiradb</url>
    <fabricUsername>admin</fabricUsername>
    <fabricPassword>password</fabricPassword>
    <fabricServerGroup>test_group</fabricServerGroup>
    <driver-class>com.mysql.fabric.jdbc.Driver</driver-class>
    <useUnicode>true</useUnicode>
    <characterEncoding>UTF8</characterEncoding>
    <username>root</username>
    <password>password</password>
    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <validation-query>select 1</validation-query>
    <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
    <pool-test-on-borrow>false</pool-test-on-borrow>
    <pool-test-while-idle>true</pool-test-while-idle>
    <validation-query-timeout>3</validation-query-timeout>
  </jdbc-datasource>
</jira-database-config>

But when I try to connect I get:
"Unknown database type name com.mysql.fabric.jdbc.Driver "

And, of course, when I use:
<url>jdbc:mysql://localhost:3308/jiradb</url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
everything works...

BRs,
Piotr

[Piotr Pawlik]

Mysql fabric is not supported. But its not an issue since mysql fabric is a poor choice for database. It has been taken into consideration cause it provieds high availabilility but its not synchronius.

Better solution is to use Galera Cluster as its truly synchronous. Hope someoe will find this info usefull

BRs,
Piotr