--0016e6d999e1cc8e730476f6ef00
Content-Type: text/plain; charset=ISO-8859-1
Hello Everyone,
I am a newbie using innodb.
How can I implement START TRANSACTION COMMIT ROLLBACK when I need to update
two tables
that are located in two different databases. Would a single START
TRANSACTION be sufficient ?
Any help would be appreciated.
TIA
Mos
--0016e6d999e1cc8e730476f6ef00--
That is correct. Many db interfaces off programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil
:
> Hello Everyone,
> =A0I am a newbie using innodb.
> How can I implement =A0START TRANSACTION COMMIT ROLLBACK when I need to u=
pdate
> two tables
> that are located in two different databases. Would a single =A0START
> TRANSACTION be sufficient ?
> Any help would be appreciated.
> TIA
> Mos
>
--=20
- michael dykman
- mdykman@gmail.com
"May you live every day of your life."
Jonathan Swift
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
Michael,
Does MySQL support multi-db transactions?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
That is correct. Many db interfaces off programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil
> Hello Everyone,
> I am a newbie using innodb.
> How can I implement START TRANSACTION COMMIT ROLLBACK when I need to
> update
> two tables
> that are located in two different databases. Would a single START
> TRANSACTION be sufficient ?
> Any help would be appreciated.
> TIA
> Mos
>
--
- michael dykman
- mdykman@gmail.com
"May you live every day of your life."
Jonathan Swift
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m.tonies@upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--00504502f54404d4b50476fbce34
Content-Type: text/plain; charset=ISO-8859-1
Looks to me we should use XA transaction syntax instead. Check this:
http://dev.mysql.com/doc/refman/5.0/en/xa.html
Thanks,
YY
2009/10/28 Martijn Tonies
> Michael,
>
> Does MySQL support multi-db transactions?
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>
>
>
>
> That is correct. Many db interfaces off programmatic abstractions of
> these facilities, but you may certainly just issue the statments.
>
> START TRANSACTION
>
> INSERT that
> UPDATE that
>
> on success: COMMIT
>
> on error: ROLLBACK
>
> - michael dykman
>
>
>
> On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil
> wrote:
>
>> Hello Everyone,
>> I am a newbie using innodb.
>> How can I implement START TRANSACTION COMMIT ROLLBACK when I need to
>> update
>> two tables
>> that are located in two different databases. Would a single START
>> TRANSACTION be sufficient ?
>> Any help would be appreciated.
>> TIA
>> Mos
>>
>>
>
>
> --
> - michael dykman
> - mdykman@gmail.com
>
> "May you live every day of your life."
> Jonathan Swift
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=m.tonies@upscene.com
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=yuan4ye3@gmail.com
>
>
--00504502f54404d4b50476fbce34--
------=_NextPart_000_004B_01CA57C4.9AF2A440
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Ah, works for InnoDB I see.
Nice.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
Looks to me we should use XA transaction syntax instead. Check this:
http://dev.mysql.com/doc/refman/5.0/en/xa.html
Thanks,
YY
2009/10/28 Martijn Tonies
Michael,
Does MySQL support multi-db transactions?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
That is correct. Many db interfaces off programmatic abstractions =
of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil =
Hello Everyone,
I am a newbie using innodb.
How can I implement START TRANSACTION COMMIT ROLLBACK when I need =
to update
two tables
that are located in two different databases. Would a single START
TRANSACTION be sufficient ?
Any help would be appreciated.
TIA
Mos
--=20
- michael dykman
- mdykman@gmail.com
"May you live every day of your life."
Jonathan Swift
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dm.tonies@upscene.com
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dyuan4ye3@gmail.com
------=_NextPart_000_004B_01CA57C4.9AF2A440--
If all the tables are InnoDB, XA isn't needed. It doesn't matter
whether all tables are in the same database.
On Oct 28, 2009, at 5:48 AM, Martijn Tonies wrote:
> Ah, works for InnoDB I see.
>
> Nice.
>
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>
>
> Looks to me we should use XA transaction syntax instead. Check this:
>
>
> http://dev.mysql.com/doc/refman/5.0/en/xa.html
>
> Thanks,
> YY
>
>
>
> 2009/10/28 Martijn Tonies
>
> Michael,
>
> Does MySQL support multi-db transactions?
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>
>
>
>
> That is correct. Many db interfaces off programmatic
> abstractions of
> these facilities, but you may certainly just issue the statments.
>
> START TRANSACTION
>
> INSERT that
> UPDATE that
>
> on success: COMMIT
>
> on error: ROLLBACK
>
> - michael dykman
>
>
>
> On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil
>
> Hello Everyone,
> I am a newbie using innodb.
> How can I implement START TRANSACTION COMMIT ROLLBACK when I
> need to update
> two tables
> that are located in two different databases. Would a single START
> TRANSACTION be sufficient ?
> Any help would be appreciated.
> TIA
> Mos
>
>
>
>
>
> --
> - michael dykman
> - mdykman@gmail.com
>
> "May you live every day of your life."
> Jonathan Swift
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
There seems to be some confusion about 'multi-db'. Within a single
MySQL instance, assuming that all your tables are a transactional type
(InnoDB isn't the only one), you don't have to do anything special to
cross database boundaries. XA is required if you plan to spread your
transactions out across multiple database instances.
- michael
On Wed, Oct 28, 2009 at 10:08 AM, Paul DuBois
> If all the tables are InnoDB, XA isn't needed. It doesn't matter whether =
all
> tables are in the same database.
>
> On Oct 28, 2009, at 5:48 AM, Martijn Tonies wrote:
>
>> Ah, works for InnoDB I see.
>>
>> Nice.
>>
>>
>> With regards,
>>
>> Martijn Tonies
>> Upscene Productions
>> http://www.upscene.com
>>
>> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
>> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>>
>> Database questions? Check the forum:
>> http://www.databasedevelopmentforum.com
>>
>>
>> =A0Looks to me we should use XA transaction syntax instead. Check this:
>>
>>
>> =A0http://dev.mysql.com/doc/refman/5.0/en/xa.html
>>
>> =A0Thanks,
>> =A0YY
>>
>>
>>
>> =A02009/10/28 Martijn Tonies
>>
>> =A0 Michael,
>>
>> =A0 Does MySQL support multi-db transactions?
>>
>> =A0 With regards,
>>
>> =A0 Martijn Tonies
>> =A0 Upscene Productions
>> =A0 http://www.upscene.com
>>
>> =A0 Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
>> =A0 Anywhere, MySQL, InterBase, NexusDB and Firebird!
>>
>> =A0 Database questions? Check the forum:
>> =A0 http://www.databasedevelopmentforum.com
>>
>>
>>
>>
>> =A0 That is correct. =A0Many db interfaces off programmatic abstractions=
of
>> =A0 these facilities, but you may certainly just issue the statments.
>>
>> =A0 START TRANSACTION
>>
>> =A0 INSERT that
>> =A0 UPDATE that
>>
>> =A0 on success: COMMIT
>>
>> =A0 on error: ROLLBACK
>>
>> =A0 - michael dykman
>>
>>
>>
>> =A0 On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil
>> wrote:
>>
>> =A0 =A0 Hello Everyone,
>> =A0 =A0 I am a newbie using innodb.
>> =A0 =A0 How can I implement START TRANSACTION COMMIT ROLLBACK when I nee=
d to
>> update
>> =A0 =A0 two tables
>> =A0 =A0 that are located in two different databases. Would a single STAR=
T
>> =A0 =A0 TRANSACTION be sufficient ?
>> =A0 =A0 Any help would be appreciated.
>> =A0 =A0 TIA
>> =A0 =A0 Mos
>>
>>
>>
>>
>>
>> =A0 --
>> =A0 - michael dykman
>> =A0 - mdykman@gmail.com
>>
>> =A0 "May you live every day of your life."
>> =A0 =A0 Jonathan Swift
>
> --
> Paul DuBois
> Sun Microsystems / MySQL Documentation Team
> Madison, Wisconsin, USA
> www.mysql.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>
--=20
- michael dykman
- mdykman@gmail.com
"May you live every day of your life."
Jonathan Swift
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
>There seems to be some confusion about 'multi-db'. Within a single
>MySQL instance, assuming that all your tables are a transactional type
>(InnoDB isn't the only one), you don't have to do anything special to
>cross database boundaries. XA is required if you plan to spread your
>transactions out across multiple database instances.
Right, makes sense, thanks for clearing that up.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org