Reply to: Why no MySQL roles

[pzz76077]

There seem to be hardly any UK MySQL DBA contract roles [aside from the jokers paying £35k pro rata for a 6-month "contract", good luck with that]

Look for Oracle, MSSQL, Sybase etc and there are loads

Any ideas why MySQL is so poorly represented on the jobs side?

Isnt MySQL a bit like house chores - its not proper work thats why do don't get paid for it.

And to prove the point if needed, my wife is a DBA that uses MySQL quite a bit and also looks after the house & I dont pay her a penny.

PZZ

[oversteer]

The full text stopwords thing was configurable in 4.0.10 - circa 2003

Before 5 it was pretty noddy. It's moved on a lot with 5.0 and 5.1 though (apart from the fact it took several years for them to put 5.1 on general release)

[chicane]

I say this having loads of experience using MySQL. Last time I used it, its foreign keys were not enforced. Deep down in the documentation it said that foreign key SQL syntax was there only for "compatibility reasons". WTF?!

It must be several years since you gained 'loads of experience' with mySQL - the InnoDB transactional engine has been around for ages and has full support for foreign keys and other 'modern' database concepts.

You're probably thinking of the older MyISAM engine which doesn't enforce foreign keys. MyISAM isn't used much these days in the enterprise - I think the most common usage scenarios are those needing read-only access at high performance levels.

[stek]

I think Sun have tarted up MySQL very nicely but like others have said, it's not enterprise-class and I feel they were gunning at Oracle with it. Well, trying....

Plus with Sun now being Oracle MySQL will be quietly brushed under the carpet along with Sun Linux 4.0, Sun Internet Mail Server and SunForum, and along with all the other half-arsed bandwagon-type investments Sun have made and quietly forgotten.

[swamp]

MySQL is just a glorified SQL front end to a hash map. For anything serious you should be using a 'proper' RDBMS.

I say this having loads of experience using MySQL. Last time I used it, its foreign keys were not enforced. Deep down in the documentation it said that foreign key SQL syntax was there only for "compatibility reasons". WTF?!

During an earlier soiree with MySQL I needed to modify the stop list for FULLTEXT search -- I needed to include some common words like 'it' in the index. This was only configurable by recompiling the C source code. WTF?!

MySQL is a great little tool, but there are too many WTF moments to make it commercially viable.

[Ruse]

Oracle RAC.

Sybase ASE CLuster Edition.

[stek]

The size of the databse is only one part of scalability. The more significant issue would be number of users, especially for a web app.
MySQL can be installed as a cluster whereas I expect only SQL Server Enterprise edition can.

Oracle RAC.

[PerlOfWisdom]

MySQL users

the ISP - Plusnet uses MySQL for all their systems.

[crack_ho]

4GB, then you are outside of the bundle of loveliness that is SQL Express.

The size of the databse is only one part of scalability. The more significant issue would be number of users, especially for a web app.
MySQL can be installed as a cluster whereas I expect only SQL Server Enterprise edition can.

[Durbs]

How big does a DB have to be before scaling comes into the question?

4GB, then you are outside of the bundle of loveliness that is SQL Express.

[Cliphead]

ClientCo uses MySQL and is very happy with it. How big does a DB have to be before scaling comes into the question?

And moving to an MS server platform will never happen anyway, so the LAMP stack is gonna be it.

[s2budd]

Exactly. Who's running a business off MySQL? Tho I do know a certain online card retailer considered it...

Learn SQL Server, that's the easiest step.

The problem is though that SQL Server runs on that second rate OS that keeps on falling over.

[d000hg]

Exactly. Who's running a business off MySQL? Tho I do know a certain online card retailer considered it...

Learn SQL Server, that's the easiest step.

Thousands of companies use it, and not only for little web-apps. Probably <10% of big software applications have DB needs that go beyond what MySQL can do.

To add to the list, eBay also uses MySQL.

[NickFitz]

The Q&A in that link isn't a great advertisment for MySQL though!

"As many know, replication of MySQL is no easy task, so we've brought in MySQL experts to help us with that immediately"

There's the jobs right there, the OP missed out!

It isn't a very good advertisement for the way they built things, but that isn't a problem with MySQL per se - they would have faced exactly the same problems whichever database they were using.

They've said before that one of the fundamental mistakes they made on starting out was to think of it as a web site, when in fact they were creating a communications channel and associated APIs; they had to do a lot of fundamental re-architecting to take account of this fact.

[Durbs]

Twitter, amongst many others.

The Q&A in that link isn't a great advertisment for MySQL though!

"As many know, replication of MySQL is no easy task, so we've brought in MySQL experts to help us with that immediately"

There's the jobs right there, the OP missed out!