MySQL - what is this????
-
Has anyone any experience of MySQL? This is being visited upon me (albeit on a trial basis) and I know nothing about it.
Trawling up and down the intranet has revealed everything from the basic (welcome back, command line) to gui tools which appear to cost.
Madame Artois
-
glad you posted this under "not about sql"
thought everyone had heard of mysql - opensource and free - loads of books in bookstores for it, pop along to your nearest bookstore.
If you want free I'd suggest sql express.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
I've heard of MySQL but that is as far it goes; we use 90% SQL Server here. I haven't really got time to visit the bookstore; the thing arrives tomorrow (yes, I know! Words have been said!)
What I wanted was anyone's experience; good or bad. I've downloaded some documentation but I won't know what I've got till it arrives.
Madame Artois
-
All I can offer is course experience I had back in school. Seems to be a nice alternative, I had a free GUI at the time. Sorry but I don't remember the name and it was 3 years ago so things may have changed. I'm sure it can be a viable solution to many problems... but since I'm a sql server guy I would also stick to sql server express for a free version
. -
The GUI tools "Administrator" and "Query Browser", roughly equivalent to Enterprise Manager and Query Analyzer, are free. I find the Admin to be very flaky though, in my experience - command line is best. In my opinion, MySQL is fine as a simple "data respository", but it lacks management/ETL tools (like DTS) to make it a real competitor to SQL Server.
Chris
-
Thanks for the help.
Madame Artois
-
It wasn't that long ago that the editorials linked to some comparisons between SQL Server and other databases. SQL Server was far and away the best with regards to security and vulnerabilities.
Scott
-
And now for something completely different: I brought MySQL into a Microsoft-only shop at my last place of employment (we didn't have SQL Server 2000, and my boss, a notoriously frugal CEO, didn't want to pay for the licensing). MySQL ran beautifully under NT Server; it was fast, stable, and very scalable. The open-source management interface we used was called MySQL Administrator, which was every inch as good as SQL Server Enterprise Manager.
Yes, SQL Server Express is free, but it isn't that scalable (I think it has a 4Gb storage limitation?). At this time, it does have some good features not found in MySQL, that are certainly worth considering, such as Reporting Services and the ability to emit result sets in XML. However, MySQL has usually kept up with the feature sets found in its commercial competitors, and I would expect it to continue doing so.
The choice really comes down to your business requirements and the database technology you'll need to support those requirements. But toe-to-toe with SQL Server Express, MySQL, in my opinion, is certainly a viable choice in many, many ways.
Cheers.
Craig
-
It really depends on what you want to do with as to how well it meets certain features. Auditing is a weak point. Multiple environment, multiple database types (a framework to plug in your own database type), interfacing with PHP, those are all strengths. And yeah, there are GUI tools which are free and almost as good as the pay to get ones. Some require a web server/PHP (MyPHPAdmin), others do not.
As for me, I administer several MySQL databases where I work, mostly for network or security-based applications, though.
K. Brian Kelley
@kbriankelley -
I got access to one too!
As for the usage, there are some third-party apps that use MySQL and if we want to use this third-party app we will need to use MySQL. I am just making sure that our reporting tools will work with MySQL database especially with the long text fields.
Regards,Yelena Varsha
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply