Connect Server Extension load balance setting

OL Connect Enterprise
1

I want to set server clustering load balance
Now I have a Master Connect Server(2022.1) in hostA
I install the “PReS Connect Server Extension module”(Slave) to connect Master Connect Server
When I setting Connections to Master Connect Server MariaDB that said "Unable to connect to localhost "

so I enter the Master Connect Server(2022.1) in hostA to test
if I use localhost:3306 to connect , it can work.
but I use hostA_IP:3306 to connect , it the same problem with setting (Slave).
this is my Master Connect Server(2022.1) in hostA MariaDB my.ini

1662024499869
1662024499869709×432 107 KB

Server_Clustering Server Clustering

and also checkout firewall is open.

How to connect Master Connect Server(2022.1) MariaDB in hostA with “PReS Connect Server Extension module” ?

2

Hi @weikai, welcome to our forum!

I’m just wondering, can you let me know please if you have executed the following two steps after you’ve made these changes:

  1. Restart the Master server then, once restarted, restart the Server Extension (Client) servers.

This step can be found below the heading “Quick Howto”(*).

Once the changes have been made and saved you need to restart the MariaDB services.

This step can be found below the heading “Binding and Root access on the Master server”(*).

Both headings can be found on the following webpage: ‘Server Clustering - PReS Connect 2022.1 User Guide (link)’

3

Hi @Marten ,

Yes, I have executed the two steps.

I found an error in documentation.

The MariaDB server's binding must be set to accept connections from the Server Extension (Client) servers.
To do this, open C:\*Program Files*\Objectif Lune\OL Connect\MariaDB\my.ini in a text editor and change the line bind-address= 127.0.0.1 to bind-address=0.0.0.0.

I saw PReS Connect MariaDB Server in Service. It start command config is

C:\*ProgramData*\Objectif Lune\OL Connect\MariaDB\my.ini

then I Set the MariaDB my.ini in C:*ProgramData*\Objectif Lune\OL Connect\MariaDB\ that remote user can access finially.

and The Documentation Team said that
This is indeed an error, and the page will need to be updated.

1 Like