MySQL4removalARC

Template Version: @(#)sac_nextcase 1.64 07/13/07 SMI
This information is Copyright 2008 Sun Microsystems
1. Introduction
1.1. Project/Component Working Name:
     Removing MySQL 4.0 from OpenSolaris

1.2. Name of Document Author/Supplier:
     Author:  Sunanda Menon

1.3  Date of This Document:
     21 October, 2008

1.4  Introduction

     This FastTrack will EOL the MySQL 4.0 from OpenSolaris.
     All products and users should migrate to 5.0, as MySQL 4.0 is an end of life
     product.

     Since we now have MySQL 5.0 as part of Solaris we should move users to
     the 5.0 version.

1.5 Previous Relevant ARC cases

    LSARC/2004/324 - SIP Proxy Server
    LSARC/2007/608 - Including MySQL 5.0 with Solaris
    LSARC 2008/150 - Include 64-bit /Connectors ARC Case

2.  Technical issues

2.1 Changes to existing code

    All references to MySQL 4.0 in the SIP proxy server(ser) will be
    updated to reference to the new location at /usr/mysql
 
2.2 Upgrade procedure for existing users of SIP/ser

    The upgrade procedure on the MySQL page:
    http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html
    http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
    need to be followed on current installations, to ensure that the tables
    created with /etc/sfw/ser/ser_mysql.sh will be upgraded to the current 
    MySQL version.

2.3 Risks and Assumptions
   
    All 4.0 users/products will have been updated to use 5.0 by the time
    Solaris 11 ships.

2.4 SMF

    No changes as MySQL 4.0 does not have any smf support.

3. Documentation

   Sip Proxy documentation on [2] need to be updated,
   as well as an upgrade procedure need to be written.
   This is pending information from the SIP proxy team inspite 
   of several attempts to reach out to them.

4. Packaging and Delivery

   SUNWmysqlr ,SUNWmysqlu and SUNWmysqlt packages will be removed.

5.  Interfaces

    MySQL 4.0 binaries from /usr/sfw/bin will be removed:
       isamchk
       isamlog
       pack_isam
       msql2mysql
       my_print_defaults
       myisamchk
       myisamlog
       myisampack
       mysql
       mysql_config
       mysql_convert_table_format
       mysql_explain_log
       mysql_find_rows
       mysql_fix_extensions
       mysql_fix_privilege_tables
       mysql_install
       mysql_install_db
       mysql_secure_installation
       mysql_setpermission
       mysql_tableinfo
       mysql_waitpid
       mysql_zap
       mysqlaccess
       mysqladmin
       mysqlbinlog
       mysqlbug
       mysqlcheck
       mysqld_multi
       mysqldump
       mysqldumpslow
       mysqlhotcopy
       mysqlimport
       mysqlmanager
       mysqlmanager-pwgen
       mysqlmanagerc
       mysqlshow
       mysqltest

    MySQL 4.0 libraries from /usr/sfw/lib will be removed:
       /usr/sfw/lib/mysql - entire directory
       libmysqlclient.so
       libmysqlclient.so.12
       libmysqlclient.so.12.0.0
       libmysqlclient_r.so
       libmysqlclient_r.so.12
       libmysqlclient_r.so.12.0.0


   MySQL 4.0 man pages from /usr/sfw/man/man1 will be removed:
      mysql.1
      mysql_fix_privilege_tables.1
      mysql_zap.1
      mysqlaccess.1
      mysqladmin.1
      mysqld.1
      mysqld_multi.1
      mysqld_safe.1
      mysqldump.1
      mysqlshow.1
      isamchk.1
      isamlog.1

    MySQL 4.0 tests in /usr/sfw/mysql will be removed, that is 
    including the entire directory.
    MySQL 4.0 I18N and config files at /usr/sfw/share/mysql/ will
    be removed, including the entire directory, and the file
    /usr/sfw/share/info/mysql.info
   

6.    References

 [1] [http://www.mysql.com/]
 [2] [http://developers.sun.com/solaris/articles/solaris_as_sip/solaris_as_sip.html#MySQL]

7. Resources and Schedule
7.4. Steering Committee requested information
7.4.1. Consolidation C-team Name:
sfw
7.5. ARC review type: FastTrack
7.6. ARC Exposure: open