Re: Running .Net Natively on IBMi

[Richard Schoen <Richard.Schoen@xxxxxxxxxxxxxxx>]

Got it. 

I wouldn't be afraid of running MySQL native on i.

However if you're running MySQL it runs well on Linux or Windows as well.

Most IBMi shops today have a mix of servers running as VMware images on Windows or Linux. 

Regards,
Richard Schoen 
Director of Document Management 
e. richard.schoen@xxxxxxxxxxxxxxx 
p. 952.486.6802 
w. helpsystems.com 
-----Original Message-----
message: 4
date: Sat, 13 Jan 2018 20:56:39 +0100
from: john erps <jacobus.erps@xxxxxxxxx>
subject: Re: Running .Net Natively on IBMi

Richard,

I have no specific use case for MySQL, i just used it as an example in my generic question.

On Sat, Jan 13, 2018 at 3:21 PM, Richard Schoen < Richard.Schoen@xxxxxxxxxxxxxxx> wrote:

> I believe the integrated file system (IFS) might be a little slower, 
> but it's pretty performant from my experience.
>
> Our biggest issue was always the limitation of object ownership. A 
> single user profile used to be limited to ~1million objects they could 
> own (Not sure if this is still true.). This wreaked havoc for large 
> document management shops. We had one customer who had to create a new 
> object owner every month because of this limitation. Moved docs to SAN 
> and problem went away (But that's another story...).
>
> I have not used MySQL in production on IBMi, but I've played with it a bit.
>
> You can use all the standard MySQL engine mechanisms to store your 
> database in the IFS. Or if you want to be able to share data between 
> RPG/CL/Cobol apps and PHP/Node/Etc you can turn on the storage engine 
> that lets you store your data in DB2 but access it also as native MySQL tables.
>
> The real question would be what is your use case and what apps do you 
> want to run ?
>
> Regards,
> Richard Schoen
> Director of Document Management
> e. richard.schoen@xxxxxxxxxxxxxxx
> p. 952.486.6802
> w. helpsystems.com