November 28, 2002 at 2:49 am
Hello there, I am like so new to all of this. I just finished taking a class in SQL, finished MS ACCESS. Just scored an 86% on the MOUS exam in ACCESS. I have been playing around with MySQL. From my understanding this is opensource program is key, and it's performance is being noticed by more and more companies. Does anyone have any feed-back for me?
it goes one for the treble, two for the bass
it goes one for the treble, two for the bass
November 28, 2002 at 5:11 am
I've tried MySQL and found it to be ok. If cost was the issue I'd consider it, so far I've been able to justify SQL (which gives us the option to use MSDE if we need to). If all you need is a basic data store, I think its fine, at some point you start to look for features that do other things (OLAP, distributed views, DTS for example) and I think that is when SQL becomes compelling.
I think you also have to look at what you're wanting to accomplish. The MOUS exams are geared towards end users, in that regard I think you'll find both mySQL and SQL Server less "friendly". If you're moving towards a developer role, then take your choice, though I believe there are more opportunities for a developer that knows SQL (my opinion of course).
Andy
December 1, 2002 at 8:40 pm
Even thou opensource, if used in any commercial venture it does require licensing. It is a good place for a developer to get a basic understanding of desing and the platform is maturing nicely. However, like Andy states their are things it doesn't offer than would not make it a candidate for most companies at this point. Besides his points not many vendors supporting mySQL as an option so apps tend to run on DB2, Oracle, Sybase, Informix or MS SQL Server still. I would for all pratical purpose use it and learn it as it may be a very big contender in the future market but I would also pick up a big name as well. There are enough power and syntax differences and similarities to make a jumop from Access easy but far more enjoyable.
December 1, 2002 at 10:26 pm
MySQL is extremely fast at retrieving queries until load starts getting high. Then MySQL drops like a rock. It's not enterprise ready... yet. But it's getting there in a hurry.
There are apps built around MySQL, but they tend to be on the Linux platform. There are mail systems and web applications used by ISPs that rely on MySQL pretty efficiently. The catch is concurrent load isn't a beast.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
December 2, 2002 at 10:22 am
I have found with any open source system, you will typically make up any difference in cost through employee hours in making the system work. For example, MySQL does not have a very good enterprise manager on initial install, but there are lots out there in PHP or CGI, all you have to do is find one and install it. SQL Server has a good enterprise manager, installed by default. If you are a good programmer and have a good programming staff you can get away with an open source system. But if you have other duties to perform and need something quick pay for a package.
Most open source guru's spend time making their systems act like off the shelf software. My favorite line "Check out this new CGI based enterprise manager I found on the web, and its totally free and it only took me 2 weeks to find it, test it and configure it on my test server"
December 2, 2002 at 10:58 am
In MySQL's defense, it does have a rather nice web-based interface already built for it (PHP, as mentioned). Me being a command-line junkie and having a shell account means I don't use it, but I do appreciate it, especially for the ASP who wants to give MySQL support to someone without giving 'em said shell account. It's called phpMyAdmin.
And yes, it does run on Win2K as long as you have PHP installed. On my test Win2K system with PHP/MySQL I have it installed.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
December 8, 2002 at 3:11 pm
You get what you payfor. MySQL is a great learning tool. Industrial strength solutions require industrial strength tools. You have to have things like backup, multiple queries, support for large disks, RAID, etc. For a learning tool, it's ok.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply