We have been trying to configure our confluence 5.5 installation but we're struggling on this issue when setting up a database.
The following error(s) occurred:
The database that we are trying to put in-place is MySQL. The database is on a cluster (using MySQL Galera and HAProxy).
In the JDBC setting, when being asked for the JDBC URL, we are feeding this information:
jdbc:mysql://host_name_of_the_load_balancer(HAPROXY)/confluence?sessionVariables=storage_engine%3DInnoDB
I hope someone can help us on this issue and enlighten us with our inquiries.
1. Is it valid to use a Database Cluster (MySQL Galera and HAProxy) for confluence.
2. If yes, what sort of items may we have missed-out in our set-up to work.
FYI: We have installed a mysql-client in our confluence server as well to test if it can connect to the Database via the LoadBalancer (HAProxy) and seems to be working fine.
Hoping for your kind consideration and most positive response.
Thanks in advance,
Jeff
Hi Sean.
As of this writing., nope, i havent had any encountered issue on the setup of our atlassian products installed in our premise (i.e. wiki, jira, crowd) which are all configured to use galera and haproxy. the rsync which is being used by galera underneath is smooth combined with the configuration made in galera and haproxy.
Jeff Rey
Hi Jeff,
I'm considering using Galera with HAProxy, as well. Have you had any issues with your setup since your last post? My main concern is that Confluence or JIRA will fall out of sync with Galera.
I'd greatly appreciate your input.
Sean
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Finally figured this one out.
During the confluence setup, we have temporarily pointed the target database (via JDBC) on just one node.
After completing the confluence setup wizard., we stopped the confluence and edited the confluence.cfg.xml to finally point it to the assigned host (or IP Address) that of the MySQL Galera Cluster.
Start the confluence again and should now be working good.
FYI: We have also installed JIRA that has also used the same database and didnt encounter any issues similar to what we have experienced in confluence.
Hope this will somehow help others who might have this road block as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.