Re: [gentoo-user] mysql use flag witout server, using only client libaries

[Tomas Krasnican <krasko@krasko.sk>]

Alan McKinnon wrote:
> On Thursday 29 July 2010 16:54:45 Tomas Krasnican wrote:
>> Hi list,
>>
>> I'm sorry for my bad english..
>>
>> I would like to emerge some packages using mysql use flag (and mysql flag
>> features, for example. php, dovecot, postfix, ...), but without mysql
>> database server (applications will connecting to the mysql database on the
>> another (remote) server). Problem is, when I set the mysql use flag at
>> some package, and I try to emerge that, mysql database is in the
>> dependencies list.
>>
>> I want to emerge that without mysql database server, using mysql client
>> libraries only. How can I define that?
>>
>> Thanks,
>> Regards,
>> Tomas Krasnican
> 
> 
> Short answer: you can't.
> 
> Long answer: you might but the devs are not going to help you
> 
> Huge answer: a mysql client has support for connecting to a server on 
> localhost. Apps like dovecot etc therefore assume the same. So the ebuilds 
> install mysql if you ask for mysql support and you get everything.
> 
> There is no exact meaning for the mysql USE flag, it is interpreted (mostly) 
> in whatever way the dev thinks it makes sense. Maybe this should not be like 
> this. Doesn't matter - right now that's how it is. So you could inspect each 
> ebuild you use for stuff that has mysql support and rip it apaprt to make it 
> do what you want. Repeat for every version bump.
> 
> 
> 
> Or, you could just do the sane thing:
> 
> # equery size mysql
>  * dev-db/mysql-5.1.46
>          Total files : 403
>          Total size  : 45.03 MiB
>  
> It's 45M, not a train smash. Most of that is docs, support configs, other 
> weird shit that Sun thought was a good idea, client libs, common libs. And the 
> server binary.
> 
> 
> You are running php, dovecot and postfix on the box. Therefore apache too.
> 
> Trust me, the extra 2M the mysql server takes up is not disk space you are 
> short off. Not worth the effort.
> 

Thanks for your reply.

When I'll install the mysql database server on the box, the lot of "gentoo-like" things will require it localy.

For example, when I emerge php with mysql support, the apache rc script will contains something like "use mysql ....", or "need mysql" in that depend part. When I emerge something else with mysql support too, it will containts this thing too. And when I try to restart some of that, or when I wanna to restart the box, the mysql server will be started and it will take more time, as is realy needed. I wouldn't like that...

I can edit this scripts and remove the mysql dependency manually...but Why I must do it using this way? I wouldn't like to edit lot of rc scripts after every update. I am too lazy (and many admins too, I think) for doing this...

For "daily" modifying are designed the configuration files, but not rc (and not only rc) scripts. I think that developers are able to edit this scripts, when is it needed, but not end-user.

And I haven't see any reason to run mysql server localy, when all of applications are using external box as the database server. So, I looking for the another solution of this "problem".

Any ideas about this "problem"?

Thanks
Tomas Krasnican