[development] Fundamental MySQL changes in Drupal 6 (six)

[Dries Buytaert]

On 13 Nov 2006, at 08:42, Larry Garfield wrote:
>> "Discussion" was I asked Dries whether he is OK with dropping 4.0  
>> for D6
>> and introducing subqueries. He said yes. That's all.
>
> I asked a question, sheesh.  Chill. :-)  All I wanted to know was the
> reasoning behind the change, since none was provided in the  
> original email.
> I don't think that's an unreasonable think to ask, given that  
> Drupal 5's
> MySQL requirements were discussed here on the list.  If "by  
> whenever Drupal 6
> is released the number of shared hosts running MySQL 4.0 instead of  
> 4.1
> should probably be low enough that we can get away with it in  
> return for
> subqueries" is the answer, then fine; please just say that.  (As  
> I've said
> before, I have no idea what the current deployments are for MySQL  
> 4.0 vs.
> 4.1.)

The rule is actually pretty simple: we follow MySQL's official  
support cycle.  When MySQL drops support (and security updates!) for  
a specific MySQL version, we drop that version as well.  When your  
hosting company is not willing to upgrade, just tell them they are  
running an insecure MySQL version (unless they have a support  
contract with MySQL).  I'd say this makes for a simple rule of thumb,  
that requires very little discussion.  Hence the prompt decision.  :)

--
Dries Buytaert  ::  http://www.buytaert.net/