rasqlinsert Feature Request

[Leif Tishendorf]

That's awesome.  Yeah, exactly what I was hoping for.

Thanks,

-Leif

On 04/25/2011 01:23 PM, Carter Bullard wrote:
> 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
>>>
>>
>

-- 
--Leif