MySQL Performance: MySQL => Mutliple database commit using .net connector ?

Members

Help

Home

Home » Performance » MySQL » Mutliple database commit using .net connector ?

Show: Today's Messages :: Show Polls :: Message Navigator

Mutliple database commit using .net connector ? [message #3480]

Sat, 30 August 2008 09:56

newtomysql
Messages: 30
Registered: February 2007

Member

Dear All,
I am currently using the .net connector. So I would like to run distributed transaction meaning that I need to commit multiple database at one gone. Can .net connector support distributed transaction? Thanks.

Report message to a moderator

Re: Mutliple database commit using .net connector ? [message #3496 is a reply to message #3480 ]

Tue, 02 September 2008 01:33

debug
Messages: 122
Registered: March 2008

Senior Member

look here: http://forums.mysql.com/read.php?3,186077,186077
there is a reference to some bug related to distributed transactions

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: Mutliple database commit using .net connector ? [message #3498 is a reply to message #3480 ]

Tue, 02 September 2008 06:33

newtomysql
Messages: 30
Registered: February 2007

Member

Dear Mikhail,
Yes I have seen this thing many places "Fixed problem where attempting to enlist in a distributed transaction would succeed even though Connector/Net doesn't currently support that. (Bug #31703) ". So what does it say actually ? Can I still use the transaction scope to implement the distributed transactions with .net connector? Now I am using 5.2.3? So I dont know whether it will work or not ? Do you have any link where I can do my reference? Thanks.

Report message to a moderator

Previous Topic:	To change username
Next Topic:	Benchmark tool for MySQL

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 20 19:32:10 EST 2008

Total time taken to generate the page: 0.03592 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.