MySQL Question

[ITJunkie]

Hi All,

Looking for advice here. Client is looking to build an enterprise level data warehouse. We are talking 50 to 100 GB's of data to start with and hundreds of interconnected fields. I am thinking along the lines of Oracle or MSSQL Server but one bidder mentioned MySQL. I am not familiar with MySQL. Can it handle very complex databases?

Thanks in advance.

 

[Barnaby W. Füi]

I don't know anything about your situation, but I'm guessing that that person is a complete jackass.

I would figure that oracle or db2 would be good for a big job.

 

[nsafreak]

Originally posted by: BingBongWongFooey
I don't know anything about your situation, but I'm guessing that that person is a complete jackass.

I would figure that oracle or db2 would be good for a big job.

Ummmm no the person was suggesting a good piece of software. Unless you want to tell companies like Cox Communications, VERITAS, Dell, Pason Systems, Red One Aviation, SGI, and Novell that they're using the wrong database software.

To answer the poster's question yes MySQL can handle very complex databases and coupled with a good operating system it has very high availability.

 

[CTho9305]

Originally posted by: nsafreak

Originally posted by: BingBongWongFooey
I don't know anything about your situation, but I'm guessing that that person is a complete jackass.

I would figure that oracle or db2 would be good for a big job.

Ummmm no the person was suggesting a good piece of software. Unless you want to tell companies like Cox Communications, VERITAS, Dell, Pason Systems, Red One Aviation, SGI, and Novell that they're using the wrong database software.

To answer the poster's question yes MySQL can handle very complex databases and coupled with a good operating system it has very high availability.

If you're going to have to write / maintain this system, note that at at present, MySQL lacks some features (notably stored procedures and triggers which are important if you have multiple client applications) which could potentially make it more difficult. I still agree with nsafreak though.

 

[Barnaby W. Füi]

Originally posted by: CTho9305

Originally posted by: nsafreak

Originally posted by: BingBongWongFooey
I don't know anything about your situation, but I'm guessing that that person is a complete jackass.

I would figure that oracle or db2 would be good for a big job.

Ummmm no the person was suggesting a good piece of software. Unless you want to tell companies like Cox Communications, VERITAS, Dell, Pason Systems, Red One Aviation, SGI, and Novell that they're using the wrong database software.

To answer the poster's question yes MySQL can handle very complex databases and coupled with a good operating system it has very high availability.

If you're going to have to write / maintain this system, note that at at present, MySQL lacks some features (notably stored procedures and triggers which are important if you have multiple client applications) which could potentially make it more difficult. I still agree with nsafreak though.

I dunno, I always hear database nerds bitching about how MySQL sucks.

Dropping company names doesn't always say much though, I'm sure you could find plenty of big successful companies that use any given piece of great or crap software.

 

[Nothinman]

MySQL isn't a bad piece of software, but PostgreSQL is also free, open source and has more of the DBMS features that MySQL lacks.

 

[nsafreak]

That's odd I usually hear that MySQL is a good piece of database software. I use it myself at home, granted I'm not a large company but it's worked well for me.

 

[Barnaby W. Füi]

Originally posted by: nsafreak
That's odd I usually hear that MySQL is a good piece of database software. I use it myself at home, granted I'm not a large company but it's worked well for me.

Notepad works well for me, that doesn't mean anything 😉

 

[crazydave]

The first time I used MySQL it was pretty annoying b/c I'm used to Oracle and certain functions that are easy to do in Oracle are either nonexistent or have to be done in a more complicated way with MySQL. But if you don't need any of the extra features that are available in Oracle you might be pleased with it. Especially since it's a lot less bloated and requires a lot less resources (both systemwise and cash-wise!) You might also want to use PostgreSQL if you need store procedures, etc. that are not available in MySQL.

 

[ITJunkie]

Thanks for the info/tips all. This will be really helpful. :beer:

 

[CTho9305]

Originally posted by: BingBongWongFooey

I dunno, I always hear database nerds bitching about how MySQL sucks.

I would, but I didn't feel like doing research for more ammo than stored procs/triggers and don't want to get caught with an innaccurate attack 😉. As I use stored procedures a lot (just makes more sense to me), I find MySQL a huge PITA.