Connector/NET: Replication & Load balancing
Posted by: Marcus Mueller
Date: November 23, 2016 05:56AM

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

Options: ReplyQuote


Subject
Written By
Posted
Connector/NET: Replication & Load balancing
November 23, 2016 05:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.