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:
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,
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.
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.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs