Why no MySQL roles

[Durbs]

And if I can do it with virtually no database experience (I've learned how to do JOIN today!), then it's not a skill anyone's going to pay for.

The same applies to SQL Server, Oracle etc etc, you can now do JOINS in those too. Get your CV out for those Oracle Financials roles, kerchiiiing!

MySQL, as has been said is on the whole used for little sites with a budget of £3.78 that require nothing more than a few JOINS. Its far more capable then that (used it a few times and its good IMO), but that's just where it is in the market hence few jobs.

[oversteer]

Yes, and there's the problem, you are now an experieced database guy right? Wrong! When the Db's need scaled up that's when they'll wish they hired a professional. But hey keeps me in a job ...

There are certainly bigger companies using MySQL (or small companies who have big MySQL installations), surely they have headaches of expansion, developers who don't optimise queries etc.

Maybe they stick to using consultancies (Sun/MySQL etc) if they have a desire to spend money..

[Durbs]

There are certainly bigger companies using MySQL (or small companies who have big MySQL installations), surely they have headaches of expansion, developers who don't optimise queries etc.

Maybe they stick to using consultancies (Sun/MySQL etc) if they have a desire to spend money..

Or if they are a big company then they'd likely have their in-house Oracle or SQL Server DBA's look after the MySQL instances they have.

[NickFitz]

Who's running a business off MySQL?

Twitter, amongst many others.

[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!

[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.

[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.

[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.

[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.

[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.