Re: Patch for compile-time username-length setting

[Gabe Jackson]

> Gabe Jackson wrote:
>> Submitted patch for setting username-length at compile-time instead of 
>> using mysql's default 16 Byte maximum usernames.
>>
>> please read details at: http://bugs.mysql.com/bug.php?id=16553
>>
>> Greetings,
>>
>> Gabe Jackson
>>
> Great for environments with only one server, but what happen if there
> are multiple master and slave or in a cluster environment?
> Every server must be compiled with the same value, right ?
>
> Also, there are scripts to upgrade the "mysql" schema and data from one
> version to another how these work with this change ?
>
> Look dangerous im(user)ho
>
> Regards,
> Francesco
>

Yeah this could cause some compatibility problems in a cluster setup.
But of course it's the administrators decision to compile with a custom
username length, so she/he could also recompile the slave servers.

The mysql_fix_privilege_tables.sql script has been updated (see patch notes)
so this should be no problem.

Thanks for your thoughts,

Greetings,

Gabe Jackson