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

Murty wrote:
> 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

Companies like Google and the BBC seem to have faith in it.

Paul Lautman;92304 Wrote:
>
> Companies like Google and the BBC seem to have faith in it.

I don't mean to hijack the thread, but are they really using MySQL?

FFMG


--

'webmaster forum' (http://www.httppoint.com) | 'Free Blogs'
(http://www.journalhome.com/) | 'webmaster Directory'
(http://www.webhostshunter.com/)
'Recreation Vehicle insurance'
(http://www.insurance-owl.com/other/car_rec.php) | 'Free URL
redirection service' (http://urlkick.com/)
------------------------------------------------------------------------
FFMG's Profile: http://www.httppoint.com/member.php?userid=580
View this thread: http://www.httppoint.com/showthread.php?t=20358

Message Posted via the webmaster forum http://www.httppoint.com, (Ad revenue sharing).

FFMG <FFMG.2x2fb8@no-mx.httppoint.com> wrote in news:FFMG.2x2fb8@no-
mx.httppoint.com:

>
> Paul Lautman;92304 Wrote:
>>
>> Companies like Google and the BBC seem to have faith in it.
>
> I don't mean to hijack the thread, but are they really using MySQL?
>
> FFMG
>
>

http://www.mysql.com/why-mysql/case-studies/

Other high-traffic sites using MySQL you'll see on that list:
craigslist,evite,friendster to name but three...

>
> > Paul Lautman;92304 Wrote:
> >>
> >> Companies like Google and the BBC seem to have faith in it.
> >
> > I don't mean to hijack the thread, but are they really using MySQL?
> >
> > FFMG
> >
> >
>
> http://www.mysql.com/why-mysql/case-studies/
>
> Other high-traffic sites using MySQL you'll see on that list:
> craigslist,evite,friendster to name but three...

Then again, Google, for example, makes custom builds :-)


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

In article <1190041161.282375.323080@r29g2000hsg.googlegroups .com>,
Murty <m_adavi@hotmail.com> wrote:

> We are thinking of migrating a mission critical application

Hi Murty,

we are running a 30 GB data + 60 GB indexes mission critical app
on Linux.

MySQL runs rock solid.

greatest table is 180 m records.

i would use InnobaseDB engine.

Please post if you have problems/success,

kind regards,

Toni

--
Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner

Murty <m_adavi@hotmail.com> wrote:

> 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.

So far no problem with MySQL 5.0

> Lot of business logics is there in the form of 'C' Embedded SQL
> routines.

This is not available for MySQL.

> Some of the big tables have been partitioned.

Partitioning is in 5.1 only. And this is beta.

> Average # of DB users is @ 100.
> Can MySQL realistically handle this kind of app ?

Difficult to answer. Need more data:

- read/write ratio?
- using transactions or referential constraints?
- using non-btree indexes?
- using other features that MySQL is lacking?

> Any experiences/thoughts are greatly appreciated.

Yeah. I'm biased, of course


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

Murty wrote:
> 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
>

Murty,

MySQL is pretty good - as stable as any of the databases out there. It
also is quite good at optimizing calls, although some are better.

MySQL doesn't have a preprocessor - everything is done with function
calls. This has advantages and disadvantages - it's easier to program
without the extra step, but if the database is maintained properly
(reorganized, etc. when necessary), preprocessed SQL typically runs faster.

It should do what you need quite well, and won't be much slower than any
of the others - chances are you won't even be able to tell the difference.

Of course, if you need even this slight improvement, you can go to one
of the more expensive databases. Personally, I'd recommend IBM's DB2 in
that case.

But I'd still recommend MySQL unless it has something you just can't do
without.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Thank you all for your inputs.
- Murty