jmccann
|
| Posted: 09/02/2002, 1:07 AM |
|
I've been using Access as my databes when developing CC. I'm now considering moving to MYSQL. THis would be on a Win2k Hosting platform
What have been your guys impression of MYSLQL in thi senvironment?
How many conurrent users can it support, is its fast enough etc etc....
Any thoughts or experiences will be appreciated.
|
|
|
 |
Jeremy
|
| Posted: 09/03/2002, 7:13 AM |
|
I have had good luck with it on NT and 2k. IIS 4 and IIS 5. Just make sure and get it installed as a service. There is also a little tool called MySQLadmin that you can have run in the sys tray at startup. I can't remember the other utils I have downloaded for the front end, basically gui interfaces to create tables and such, much like access or mSQL. Easier than the command line.
As far as speed, that really depends on every other variable, such as processor speed, what kind of selects you are doing, not bloating your code, network speed, and how many other users are on the server for different things. The application itself is fast. It should be considerably faster than Access with multiple users. If you are talking 5-10 users you probably won't see a difference. All in all, I think MySQL is a great solution for a hefty free database server on windows/linux. I run MySQL as my log server for intrusion detection on NT4/IIS 4, and it never crashes. Logs intrustion stuff all day on an entire subnet. The only slowness I see is with the way the PHP files were written to access the log files. If I did it myself, it would be much faster. As for how many users it can support, I'm not sure of the exact amount, but I know it's a lot. It should be a lot more than access.
Hope this helps.
-Jeremy
|
|
|
|
jmccann
|
| Posted: 09/03/2002, 12:41 PM |
|
Jeremy,
I really appreciate the time you took to respond. I don't honestly think I would really go above circa 50 concurrent users, and most of these will be retrieving queries.
I was considering moving up tp SQL server but then, thought, wait a mo... why not consider MYSQL. In my ignorance I had thought it only ran on UNIX/LINUX. Moving to MYSQL would appear to be a more cost effective (ie cheaper ) option to me.
I also like the utility MYAccess that some other guys on the forum were commenting on. I like the idea of utiliisng the familiarity of Access to administer MYSQL.
As an aside, I've posted a couple of questions here and evey time someone has taken the time and courtesy to reply. What a GREAT forum guys. Long may this spirit of help and co-operation continue.
jim mccann
|
|
|
|
Trevor
|
| Posted: 09/03/2002, 8:25 PM |
|
You will not go wrong with MySQL. I have used it both in production and development systems on NT, Win2000, Unix and Linux and have nothing but high regard. (As a GUI use MySQLFront from www.mysqlfront.de) It is extremely fast, unbeleavably robust and a very simple setup. In multi user environments I have only had it up to about 50 concurrent users without a twinge. I am not sure what the max would be.
I develop on a Win2000 machine using PHP, ASP, MySQL and Access. Give MySQL a go, you won't be dissapointed!
|
|
|
|
RonB
|
| Posted: 09/04/2002, 1:30 AM |
|
Hi,
At my company we believe you should pick the right database for the right purpose. SQL server is nice but costly so that's not an option(MS takes enough money from us as it is  Oracle wich we use for clientregistration is to bulky and slow for simple intranet pages. MySQL has everything you need and it's speed is incredible. So we now have two main database servers, Oracle and MySQL and we are very pleased with it. The MySQL server runs on win2k with php as a module and apache as a webserver. We considered IIS but Apache is for us the better choice. We went for PHP because we now develop platform independent and if we should decide to go Linux because of the idiotic prices MS is charging these days, the intranet will be up and running in a few minutes. With asp we would have to redo the whole thing. Acces never was in the picture for us because the support for multiple users is flakey at best. It was never meant as a multi user platform. We started to move all small databases thrue out the company to mysql and are aiming for a situation where we only use Oracle and MySQL. I must say we are very pleased so far and the windows versions of PHP, MySQL and Apache are running like a dream. I wouldn't advise running php as a module on NT. It was fairly unstable and that problem went away wen we switched to win2k.
|
|
|
|
Gregory
|
| Posted: 09/04/2002, 8:46 AM |
|
I use MySQL for most things it's not a bad OSS database but lacks certain features. It's getting better all the time.
Greg
|
|
|
|
|
