[gentoo-dev] Creating a dedicated gentoo profile for commercial mysql support

[Matthew Marlowe]

I dont know whether this should be a GLEP or just a simple email,
but I'll start as an email....

GENERAL BACKGROUND:
--------------------------------------------
Gentoo is being increasingly deployed in datacenter environments, especially
in multilayered apache/tomcat/mysql configurations.  Many clients in the 10-25
box range have decided to switch their infrastructure entirely to gentoo due to
satisfaction with gentoo's ease of configuration and overall lifetime flexibility with
key applications (no need to reinstall/make a major upgrade of the OS - and 
no RPM hell).

Recently, Mysql AB has released two new features/products: cluster support
and mysql network (a commercial support offering).  As a consultant, I have
several clients looking to deploy both.   However, the clients are worried that
they are going to be forced to switch their DB layers to redhat to ensure stability
and support.  Mysql also participates in TSA Network such that any mysql server
issues could be reported to them and multiple vendors including dell, redhat, and mysql
would all work together to resolve problems.  Dell has just launched a mysql support
program at http://www.dell.com/mysql.


RECENT ACTIONS
--------------------------------
I had multiple discussion with mysql representatives at the mysql users conference
this week in Santa Clara.  Mysql initially had a two faced response: They would try
to support all their customers to the extent possible due to a strong commitment
to no bugs in their code, however the more complex your mysql configuration was
the more they wanted you to be on a certified platform (which involves mysql building
a test environment and putting it through extensive regression testing for a period of
time, they have contracted out with a third party testing company to do this for each
platform and some hardware configurations).  They didn't know how they could do 
this to gentoo based on the fact that one person's gentoo was different than anothers.
I was told that at least three individuals: Andy Bang (Marketing VP, manager mysql network),
Arjen(sp?) (Community Relations), and Brian Akker(sp?) would all have to approve adding
a new platform.

During the conference I spoke with Andy and Arjen about gentoo discussion regarding 
creating a server profile, and at least locking key libraries for six month intervals.  Mysql
also told me they were receiving many requests for gentoo support, and if gentoo
could get a server profile setup, they would be interested in supporting it - as it would make
their gentoo users happy and provide additional income via mysql network.  So, there 
appears to be a deal that can be reached here.  I will try to speak with Brian Akker and
any other individuals at mysql next week to confirm an agreement.

Last night, I broached the idea on the gentoo-dev channel and suggested that if the
generic server profile wasn't ready - I should at least be able to create a specific
profile dedicated to commercial mysql support.  Others seemed to agree, although
a few technical issues were brought up and which would need to be resolved.  I was
also told to confer with gentoo-releng before starting any new profile work.

I also posted a question about the server profile status to gentoo-server, but there wasn't
a substantive response and after 1-2 years of waiting, I'm not sure I want to depend on it.
(the above isn't meant to slam it, it's just that my clients can't wait any longer).

I messeged wolf31o2 and he seemed ammenable, but asked that an email be sent out
and this is that email.

PROPOSAL:
--------------------
Creation of a "commercial/amd64/mysql" profile under /usr/portage/profiles.  The directory structure
is setup so that any other developers could create dedicated profiles for similiar commercial 
support w/o cluttering up the tree.  Everything would be under /usr/portage/profiles/commercial.

I would initially use default-linux/amd64/2005.0/no-multilib as the base for modification as this is what I 
currently use on our servers.

After submitting the new profile and testing it, I would create online documentation that both gentoo and
mysql could reference to and provide ongoing maintenance for the profile- but would avoid making any
significant changes other than at 6-12 month intervals.

As for the mysql installation itself on these boxes, these would be binaries provided by mysql for two reasons:

1) Mysql binaries are compiled with icc which could provide significant performance gains for the targeted user base.  
Untill icc is fully compatible with portage, I'd rather avoid installing icc myself on customer boxes.

2) Mysql would prefer their own binaries for certification.


Regards,
MattM


-- 
gentoo-dev@g.o mailing list