Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

MySQL with InnoDB

Apr 18, 2002, 7:02 AM
webmaster33
Veteran (2312 posts)
Apr 18, 2002, 7:02 AM
Post #1 of 7
Views: 10081
Shortcut
Quote Reply
MySQL with InnoDB
Did you hear about MySQL-3.23.4x with InnoDB?
What are opinions about it?
Will Gossamer products able to cooperate with InnoDB (transactions, foreign keys, etc...)?

http://www.innodb.com/
http://www.innodb.com/howtouse.html
http://www.innodb.com/features.html

Waiting opinions, especially from GT developers.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Apr 25, 2002, 4:30 PM
webmaster33
Veteran (2312 posts)
Apr 25, 2002, 4:30 PM
Post #2 of 7
Views: 9612
Shortcut
Quote Reply
Re: [webmaster33] MySQL with InnoDB In reply to
Alex, Staff: will GT products support MySQL with InnoDB database?

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Apr 25, 2002, 5:04 PM
Alex
Administrator (9387 posts)
Apr 25, 2002, 5:04 PM
Post #3 of 7
Views: 9510
Shortcut
Quote Reply
Re: [webmaster33] MySQL with InnoDB In reply to
Hi,

GT will run on InnoDB databases in much the same was as it will run on MS SQL and Postgres databases. It does not use the built in foreign keys or transactions, but will work just fine.

We are currently looking at making the GT::SQL foreign key support use the database if it is supported, otherwise fall back to the perl method.

However, you still get a lot of the benefits of innodb (superior locking, easier large table support, better backup/restore, etc) without any changes to our products.

Cheers,

Alex
--
Gossamer Threads Inc.
Apr 25, 2002, 5:39 PM
webmaster33
Veteran (2312 posts)
Apr 25, 2002, 5:39 PM
Post #4 of 7
Views: 9533
Shortcut
Quote Reply
Re: [Alex] MySQL with InnoDB In reply to
Great! Thanks Alex!

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Dec 28, 2002, 2:44 PM
webmaster33
Veteran (2312 posts)
Dec 28, 2002, 2:44 PM
Post #5 of 7
Views: 9224
Shortcut
Quote Reply
Re: [Alex] MySQL with InnoDB In reply to
In Reply To:
We are currently looking at making the GT::SQL foreign key support use the database if it is supported, otherwise fall back to the perl method.
Any news, about InnoDB foreign key support in GT::SQL?
Not the most important feature we would need, but would be fine to hear about plans in that subject.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Dec 31, 2002, 2:47 PM
SeanP
User (456 posts)
Dec 31, 2002, 2:47 PM
Post #6 of 7
Views: 9235
Shortcut
Quote Reply
Re: [Alex] MySQL with InnoDB In reply to
Using Links SQL, can I just run:

ALTER TABLE yourtablename TYPE=INNODB;

on each of my tables to convert them to InnoDB? Will Links SQL still function properly?

Sean
Sep 20, 2003, 5:59 AM
jai
User (417 posts)
Sep 20, 2003, 5:59 AM
Post #7 of 7
Views: 8847
Shortcut
Quote Reply
Re: [Alex] MySQL with InnoDB In reply to
In Reply To:
We are currently looking at making the GT::SQL foreign key support use the database if it is supported, otherwise fall back to the perl method.
My database design uses innodb (built in foreign keys and transactions) but it doesn't seem to be available in DBManSQL. Are you still going to impliment full innodb support or has it been shelved? Thanks Simon.