We are thinking of migrating a mission critical application from
Informix/Solaris to MySQL/Linux platform. It is a OLTP app and has
got 400 gb of data with @ 800 tables, few stored procs and triggers.
Lot of business logics is there in the form of 'C' Embedded SQL
routines. Some of the big tables have been partitioned. Average # of
DB users is @ 100.
Can MySQL realistically handle this kind of app ?
Does it have Embedded SQL pre-processor for C/C++ ?
Any experiences/thoughts are greatly appreciated.
Thanks
Murty