Linux/Unix - Anyone knows mySQL?

Author

Anyone knows mySQL?

2000-10-04, 3:43 pm

I know that there not too many experienced users of mySQL out there, but I decided to learn mySQL.

The reason for it is that RedHat 7 now include mySQL in the distribution.

This makes me think that soon we will see many more web hosting companies use mySQL and also more programs will be written for mySQL.

This makes a lot of sense. Why pay $1000.00 or more for Microsoft's SQL server of even more for Oracle when you can get mySQL for free. From what I've read so far, it is very fast database, ideal for web applications.

Anyhow, if any of you have had experience with it, let me know, I need all the help I can get with this one.

I've only used Access database in the past, so I don't have alot of experience with databases in general.

------------------
Webmaster and founder of this site and of
<A HREF="http://www.cert21.com"" TARGET=_blank>Cert21.com</A>
MCSE+I, CNA, A+, N+, I-NET+

2000-10-04, 4:00 pm

Webmaster,

I agree with u action. I am planning for learning SQL, too.

Until i saw this. I change my mind to mySQl, since I am a RH 6.2 user.

Please keep us inform about this.

Any good instruction book u can recommend to read or from anybody..

THANKS

2000-10-04, 4:24 pm

I ordered this book yesterday form Amazon.com
http://www.amazon.com/exec/obidos/A...11/examnotesnet

What sold me on this book is that it's rated 5 stars with 34 reviews. Very very few books on Amazon have 5 stars rating with so many reviews.

I'll receive it in a few days and then I 'll let you know how it is.

In the mean time, I am getting a Linux server with Apache, mod_perl and mySQLinstalled on it. I want to try a few web applications and scripts to work with mySQL.

So far I was not very successful with mySQL, I could not even add a new database to it, I'll keep on trying....

------------------
Webmaster and founder of this site and of
<A HREF="http://www.cert21.com"" TARGET=_blank>Cert21.com</A>
MCSE+I, CNA, A+, N+, I-NET+

2000-10-04, 11:17 pm

OK, I made some progress and now I know how to create database, add user and grant permissions to the database for the user.

THere is a lot more to learn, but I will get there.

------------------
Webmaster and founder of this site and of
<A HREF="http://www.cert21.com"" TARGET=_blank>Cert21.com</A>
MCSE+I, CNA, A+, N+, I-NET+

2000-12-03, 9:34 pm

Excellent find Webmaster, can you give us any updates on your progress with this book and your studies of MySQL?

2000-12-05, 3:24 pm

My database experience is all in IBM's DB2 and some IMS. I'd be interested in knowing more about mySQL as well.

2000-12-06, 1:42 pm

I just saw it.

New Rider have a book for MySQL!

2000-12-15, 8:20 am

Here is a link I found to MySql if anyone wants to have a closer look http://www.mysql.com/documentation/mysql/bychapter/

Mr. Linux Guy

2002-10-08, 12:47 pm

Anyone here used phpMyAdmin? the source is at:

http://phpmyadmin.sourceforge.net/

I have installed it on my web database server and I love it. It allows you to manage MySQL databases with PHP applications, all from a web-page type GUI. It makes using databses much faster and easier, especially if you're new to them.

namrak

2002-10-08, 3:17 pm

Thanks for the find Webmaster. So much to learn and not enough time in the day. My Linux journey will eventually take me to mySQL as well and will keep the New Riders book in mind when I eventually purchase materials to read. My database experience has all been with SQL Server 2000.

Antz49

2002-10-14, 5:05 pm

MySQL is fairly simple, works well with PHP and PhpMyAdmin makes it a breeze to setup, just check MySQL is not 100% free in commercial sense, its fast but lacks powerful features seasoned SQL users might need.

If you are really serious about a powerful DB try PostGreSQL

drdirt

2002-10-15, 12:05 am

Does anyone know what the volume limits of my-squeel and postGre squeel are?

I don't trust this old tech instructor on this subject but he claimed that these two database structures were too limited in size for "real" enterprise use.

I would love to know some commercial use examples (not just to throw in his face). As you may have guessed, this guy bleeds blue, not a single herring in his gut.

One of these is probably the thing for me to learn next. Just concerned that it will be another one of those novel-really-cool-things I can do on my home box but has absolutely no value in business.

Antz49

2002-10-16, 4:38 pm

Well drDirt

Your Blue Blood Instructor is obviously too easily swayed in the mindset - if its expensive its better. MySQL being the "smaller" of the two (Postgre and MySQL) our company host the site HowHotAmI , it gets a few thousand hits per day , it got something like a million hits in the first launch (less now) - for every photo and vote it does a query and a write, the server hosts over a hundred other accounts to - each with its own connection to the same MySQL database, MySQL has never crashed or slowed down enough for the server to fail requests. In fact one of our partners that handles NT hosting for us and SQL server 7 always has database problems.

I dont have exact figures for you, I think postgres.org/com/net ? might have some technical data. Just dont want you to get influenced by the ignorant sentiment of a Corporate sheep.

azimuth40

2002-10-16, 6:07 pm

Are you comparing apples to oranges?? You seem to be talking about speed and I think his instructor was talking about table size's. For example could it host the entire Visa or AMX credit card system or the billing for one of the baby bells? Could it handle a multi terabyte database which I do not believe is the definition of volume that you are using.

mikop

2002-10-16, 6:54 pm

http://www.mysql.com/documentation/...html#Table_size

MySQL Version 3.22 has a 4G limit on table size. With the new MyISAM table type in MySQL Version 3.23, the maximum table size is pushed up to 8 million terabytes (2 ^ 63 bytes).

in true enterprise system, decision maker would be more concern about support contract than the actual spec anyway as long as it meets guidline and projected growth... its about whose number ppl is gonna call when sh*t hits the fan more than all this techno jumble.

and quite honestly... comparing mysql to oracle etc... its like... why use MS SQL server when there is MS Access... totally different product placement... even mysql would not make the claim to be true enterprise dbase solution.

http://www.mysql.com/articles/us/yahoo_finance.html

MySQL at Yahoo!
Some Technical Details:
Operating system used: FreeBSD and Linux, synchronized using MySQL Replication
Size of database: 25 GB
Average number of concurrent connections: 60
Max number of concurrent connections: 250

azimuth40

2002-10-17, 2:57 am

Thanks mikop, those are all the magic answers to stop people from going off on a tangent here.

Mr. Linux Guy

2002-10-17, 5:48 am

I agree with Milkop. MySQL is great, but it is not the solution for everything. It still does not allow transactions and doesn't enforce referential integrity. Then again, because of this "lightness", it is super fast. I don't think the MySQL development team had in mind replacing Oracle or DB2 with their product. They belong to two wholly different cataegories in that sense.

Antz49

2002-10-17, 8:02 am

As far as comparing apples and oranges, glad to see someone here could give more tech based data.

Does anyone know what Postrgres capabilities is compared to what stated here about MySQL and how does that compare to stuff like Oracle etc.

Antz

Mr. Linux Guy

2002-10-17, 8:35 am

If you're migrating from Oracle, Sybase, or Microsoft SQL Server, I suggest PostgreSQL. Like those databases, PostgreSQL has triggers, stored procedures, and a rich set of built-in functions (including many functions for date manipulation like Oracle does). Also, PostgreSQL procedural language is easy to learn if you're familiar with Oracle's PL/SQL and SQL Server's Transact-SQL. PostgreSQL also has much better support for subqueries and supports foreign keys.

MySQL is a much lighter client, ideal for the web, faster, but does not (and will not, according to the developers) have the features that PostgreSQL has. So let's say you are doing bankwork or something that depends on transactions. If the plug is pulled when using the database, MySQL will lose your data most like. postgreSQL will roll back the changes and nothing will be left in an unfinished state. MySQL doesn't have facilities for procedural language statements either.

Currently I know of no databse that can compete with the closed source "big guys" (Oracle, Sybase, Informix, DB2). If there will be a contender in the future it will be PostgreSQL. So basically, if you are looking for some complex database development, PostgreSQL would better suit your needs. If you are doing web development, all of that bulk and complexity gets in your way and slows stuff down, so go with MySQL. To me they seem best suited for a wholly different set of needs. I use Oracle, PostgreSQL and mySQL where I work depending on what type of functionality that I need. best thing would be to make notes of what you need to get accomplished with your database and then to try to match up the features that you need with those that the database products offer and then make a decision based on that. No one product is best suited for all types of apps.

onoski

2002-10-17, 8:48 am

Mr Linux Man, what about SQL Server 7.0, and 2000 are they not part of the big boys or in a league of RDMS?

Mr. Linux Guy

2002-10-17, 9:10 am

quote:
Originally posted by onoski
Mr Linux Man, what about SQL Server 7.0, and 2000 are they not part of the big boys or in a league of RDMS?

Never actually used any of them or heard much about them. First databases I actually used were IBM's IMS and DB2 and then went to Oracle and the open source databases. I don't think the MS databases are as popular as Oracle and IBM's dbs. I am not sure how they compare to MS products, although in a Linux forum, you might not get an unbiased answer about that one.

Sponsored Links