Hi all,
I found following feature with Connector/NET:
https://blogs.oracle.com/MySqlOnWindows/entry/how_to_using_replication_load
Feature is great, but unfortunately performance is degrading massively in comparison to direct connection. It seems that connection pooling is not active (is it supported in replication mode?).
We are working on a maria-db cluster with 3 hosts.
Can I find more information/documentation on this feature?
Visual Studio app.config:
<Group name="MariaCluster_icom_db" retryTime="60">
<Servers>
<Server name="maria4" IsMaster="true" connectionstring="server=maria4;port=3306;uid=user;password=;database=icom_db;POOLING=TRUE;Min Pool Size=1;Max Pool Size=100;"/>
<Server name="maria5" IsMaster="true" connectionstring="server=maria5;port=3306;uid=user;password=;database=icom_db;POOLING=TRUE;Min Pool Size=1;Max Pool Size=100;"/>
<Server name="maria6" IsMaster="true" connectionstring="server=maria6.;port=3306;uid=user;password=;database=icom_db;POOLING=TRUE;Min Pool Size=1;Max Pool Size=100;"/>
</Servers>
</Group>
Cheers,
Marcus