MySQL Bugs: #69973: MYSQL replication stops working when using the connector

Bug #69973	MYSQL replication stops working when using the connector
Submitted:	9 Aug 2013 15:31	Modified:	14 Jul 2016 12:54
Reporter:	Rak Fal	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	6.7.4	OS:	Windows (SBS 2003)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	connector, MySQL, replication

Description:
I have setup MYSQL replication, Master-Slave, and this seems to be working fine. But, when I use the connector 6.7.4, no data is being replicated at all. This includes INSERTS/DELETES/UPDATES..etc. 

If I use the ODBC driver 5.1, this seems to be replicating data fine. I have also tested replication by using phpMyAdmin, and this seems to be fine too. 

How to repeat:
Setup MYSQL replication, and use the connectors to see if replication is occurring.

Hi,

You need to configure Connector/NET load balancing/replication at the app.config/web.config level, for example:

<?xml version="1.0"?>
<configuration>
  <configSections>
    <section name="MySQL"	type="MySql.Data.MySqlClient.MySqlConfiguration,MySql.Data"/>
  </configSections>
  <MySQL>
    <Replication>
      <ServerGroups>
        <Group name="Group1" groupType="MySql.Data.MySqlClient.Replication.ReplicationRoundRobinServerGroup">
          <Servers>
            <Server name="master" IsMaster="true" connectionstring="server=localhost;port=3307;uid=root;password=;logging=true;"/>
            <Server name="slave1" IsMaster="false" connectionstring="server=localhost;port=3308;uid=lbuser;password=lbpass;logging=true;"/>
          </Servers>
        </Group>
      </ServerGroups>
    </Replication>
  </MySQL>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5"/>
  </startup>
</configuration>

The sample above assumes two severs, the master (read/write) in port 3307 and the slave (read only) in port 3308.

Then you open a connection referencing the Group1 only:
MySqlConnection conn = new MySqlConnection("server=Group1;")

And Connector/NET takes care of the rest.

I am using this config file on the test. the problem is (in my system) pooling.

ignore me. its not related to this bug.

Hello Rak Fal,

Thank you for your feedback.
Please try with below Configuring for MySQL replication using Connector/NET.
https://blogs.oracle.com/MySqlOnWindows/entry/how_to_using_replication_load

Thanks,
Chiranjeevi.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".