Judah, Yes it is nice to have power, but it is rather like buying a Porshe to drive around town at 30MPH, sure you can brag about it and tell everyone how you could drive at 200mph if you wanted to, but really you are never going to do it, and a more practical car is really going to do a better job for you in that scenario.
My comments are based on my own *REAL WORLD* experience hosting hundreds of databases over many years, rather than as a developer building a single database/website. but in those years I have experienced the following, which is why I will always prefer/recommend MSSQL. MySQL databases corrupt quite easily and need to be repaired (even on dedicated machines) Never had a MSSQL corruption problem since MSSQL 2000 MySQL will easily get overloaded by a single database and consume 100% CPU requiring a restart, only experienced this on v4 so far though. Never had that problem on MSSQL MySQL is a PITA to backup and restore, time consuming and quirky and dumps not always reliable. MSSQL is simple and quick to backup/restore/migrate. Our MSSQL servers are able to host far more databases than the MySQL servers. Now granted the limits on Express edition would mean you could not host HUGE memory/CPU hogging databases, but as I said, this scenario is quite rare, most people's databases do not come anywhere near this and the Express edition will handle them just fine, so it certainly is not just good for development. We ran SQL 2005 express for years in a shared hosting environment with no problems at all, the limits did not cause any problems for a long time. We managed to get a lot of databases on the server until it started to run out of power, and now we use SQL Server 2008 web edition, which is actually very cheap to run. Again I would point out that if you are in the need of great power and reliability, then you should be running your own server and probably not running the free editions anyway. The problem with databases and database servers is that most developers really don;t know much about them, and will just throw together a basic database and rely on the servers out of the box config. In this area MSSQL shines, as you can install it out of the box with no tweaking and it will run like a dream. With MySQL on the other hand you really need a deeper understanding of how it works to be able to fine tune its performance and you also need to understand the different database engines it utilises and when to use them, again something most people do not do, which adds to the reliability/performance issues with databases. To be honest this is somewhat of a rarity as M$ products are usually not known for being the best, often it is the 3rd party products which are superior, but you also have to remember that M$ did not originally create SQL Server, it was originally Sybase. So if you are in the anti-Microsoft camp you may find this history of SQL server interesting. http://insidesqlserver.com/companion/History%20of%20SQL%20Server.pdf At the end of the day this is just my opinion/experience, you do not have to agree with it. On Tue, May 10, 2011 at 4:18 AM, Judah McAuley <ju...@wiredotter.com> wrote: > > MySql is free though licensing is a bit complicated because of a > dual-license model. The community edition includes many "enterprise" > sorts of features like replication and partitioning. If I recall, > there are additional backup tools and monitoring in the paid > enterprise edition. If you want to go completely free from the weird > Oracle ownership stuff (which I think is wise, personally), there is > the MariaDB fork which is entirely FOSS as far as I know. What > "enterprise" features are you thinking aren't in the community > edition? > > MySql community edition has none of the limitations present in MS SQL > Express edition. Honestly, not taking advantage of more than a gig of > RAM or 1 cpu core is just stupid. Why would you even have a database > server? I suppose if you are housing the db on the same machine as > your app server then...well, you have plenty of other problems at that > point. > > Sql Express is great for development (though I prefer developer > edition myself). It is not meant for production websites, period. > That's why Microsoft has a Web edition. I like SQL Server and use it > but it is wrong to try and compare Sql Express and MySql community > edition, they are completely different classes of software. > > That being said, I still think people should check out PostGres. A > feature set comparable to Oracle/MS SQL/Sybase and genuinely FOSS, > unlike MySql. Tasty DB goodness. > > Cheers, > Judah > > On Mon, May 9, 2011 at 4:57 PM, Russ Michaels <r...@michaels.me.uk> wrote: > > > > Many people often wrongly assume that MySQL is simply FREE, which is not > > correct. Many people are also completely unaware that there is a FREE > MSSQL > > Express edition. > > The FREE version is the community edition, which also has limitations, > look > > them up, If you want enterprise features then you have to pay i'm afraid, > > even with MySQL. > > The FREE editions of both will meet most peoples needs even with their > > limitations, it is really not very common to have databases of 10GB that > > needs more than 1GB RAM or more than 1CPU, then you probably be using the > > FREE editions anyway. > > > > > > > > On Tue, May 10, 2011 at 12:26 AM, Judah McAuley <ju...@wiredotter.com > >wrote: > > > >> > >> Or possibly Jordan has needed a database that runs on more than 1 CPU, > >> uses more than 1GB of RAM or has a db size of more than 10GB :) > >> > >> > >> On Mon, May 9, 2011 at 4:20 PM, Russ Michaels <r...@michaels.me.uk> > wrote: > >> > > >> > Perhaps you tried to run MSSQL on linux Jordan, that would certainly > >> > be humorous I imagine :-) > >> > > >> > > >> > On Tue, May 10, 2011 at 12:12 AM, Gerald Guido < > gerald.gu...@gmail.com > >> >wrote: > >> > > >> >> > >> >> > Russ Michaels wrote: > >> >> > > >> >> > don't forget that MSSQL express is also free and more powerful than > >> mysql > >> >> > >> >> > >> >> >Jordan Michaels <jor...@viviotech.net> wrote: > >> >> > >> >> > I find the "more powerful" comment humorous. > >> >> > >> >> This should be fun to watch :) I am making some popcorn. Anyone want > >> some? > >> >> > >> >> G! > >> >> > >> >> On Mon, May 9, 2011 at 6:52 PM, Jordan Michaels < > jor...@viviotech.net > >> >> >wrote: > >> >> > >> >> > > >> >> > I find the "more powerful" comment humorous. > >> >> > > >> >> > SQL Express limits are here: > >> >> > > http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx > >> >> > > >> >> > Migration from MS SQL to MySQL documentation is here: > >> >> > > >> >> > > >> >> > >> > http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html > >> >> > > >> >> > I've done it several times with no issues. > >> >> > > >> >> > -Jordan > >> >> > > >> >> > On 05/09/2011 03:38 PM, Russ Michaels wrote: > >> >> > > > >> >> > > don't forget that MSSQL express is also free and more powerful > than > >> >> mysql > >> >> > > community edition so there is no need to migrate to MySQL unless > >> your > >> >> > also > >> >> > > moving to Linux. > >> >> > > There are however free migration tools on the mysql site that > will > >> do > >> >> it > >> >> > for > >> >> > > you. > >> >> > > > >> >> > > On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear< > >> >> > > jenn...@fasttrackonline.co.uk> wrote: > >> >> > > > >> >> > >> > >> >> > >> I'm interested in any info. Pit falls to avoid, best practises, > >> etc. > >> >> > >> > >> >> > >> Many thanks, > >> >> > >> > >> >> > >> Jenny > >> >> > >> No virus found in this outgoing message. > >> >> > >> Checked by AVG - www.avg.com > >> >> > >> Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: > >> >> 05/08/11 > >> >> > >> 19:34:00 > >> >> > >> > >> >> > >> > >> >> > >> > >> >> > >> > >> >> > > > >> >> > > > >> >> > > >> >> > > >> >> > >> >> > >> > > >> > > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
