rasqlinsert Feature Request

[Carter Bullard]

Hey Leif,
So I have implemented your suggestions in rasqlinsert() for the command line, and
all looks good as a prototype, so looks like a doable strategy.  I still need to test the input
for correctness, at least that they are reasonable table types, and then implement the
.rarc variable.

Is this approach what you were interested in?  Do we like "-M mysql_engine=ndb" is
the syntax we like?  Other suggestions?

I found out the ENGINE thing started with mysql 4.1.  Now,  I test the version to make sure its
at least 4.1, and then we use ENGINE=MyISAM as the default, but if you override it, you
get ENGINE=whatever on table creation.

Carter


On Apr 25, 2011, at 3:43 PM, Carter Bullard wrote:

> Hey Leif,
> Have you implemented this for rasqlinsert()?  Should be just a change on line 8321 from
> "TYPE=MyISAM" to "ENGINE=ndb" ?
> 
> So, I can add a variable to .rarc and a command line mode using the "-M " type of configuration.
> So, "MYSQL_DB_ENGINE=", would trigger the use of "ENGINE=%s", where %s is whatever 
> they set the variable to?  And "-M mysql_engine='ndb'" would do the same thing?  
> Would that do it?  Other options?
> 
> I'm trying to find what version made the change to ENGINE rather than TYPE, so I can put
> a test for the version and make the change when creating tables.
> 
> Carter
> 
> On Apr 25, 2011, at 2:47 PM, Leif Tishendorf wrote:
> 
>> Hey Carter,
>> 
>> I was wondering if it would be possible to have a command line switch to select the type of mysql engine to use for the table creation?  Default to MYISAM, but have the ability to explicitly call the DB engine.
>> 
>> This would be nice for a couple of reasons:
>> 
>> 1) Currently rasqlinsert uses TYPE which is not supported in 5.5 and later.
>> 
>> 2) We would like to use mysql clustering since we have a huge volume of daily flows, and the only change required is that you feed the table creation string an ENGINE=ndb.
>> 
>> We could write our own ra wrapper but thought others might find the flexibility useful as well.
>> 
>> Thanks,
>> 
>> --Leif
>> 
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4367 bytes
Desc: not available
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20110425/750c3dc8/attachment.bin>