Changeset e3fec8f


Ignore:
Timestamp:
08/15/2012 06:01:58 AM (12 years ago)
Author:
Ragnar Thomsen <rthomsen@…>
Branches:
10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, 7.10, 7.4, 7.5, 7.6, 7.6-blfs, 7.6-systemd, 7.7, 7.8, 7.9, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, basic, bdubbs/svn, elogind, gnome, kde5-13430, kde5-14269, kde5-14686, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, krejzi/svn, lazarus, lxqt, nosym, perl-modules, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, systemd-11177, systemd-13485, trunk, upgradedb, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
Children:
bf15986e
Parents:
697cb83f
Message:

MySQL 5.5.27 with improved instructions.

git-svn-id: svn://svn.linuxfromscratch.org/BLFS/trunk/BOOK@10520 af4574ff-66df-0310-9fd7-8a98e5e911e0

Files:
3 edited

Legend:

Unmodified
Added
Removed

  • general.ent

    r697cb83f re3fec8f  
    44-->
    55
    6 <!ENTITY day          "14">                   <!-- Always 2 digits -->
     6<!ENTITY day          "15">                   <!-- Always 2 digits -->
    77<!ENTITY month        "08">                   <!-- Always 2 digits -->
    88<!ENTITY year         "2012">
    … …  
    1010<!ENTITY copyholder   "The BLFS Development Team">
    1111<!ENTITY version      "&year;-&month;-&day;">
    12 <!ENTITY releasedate  "August 14th, &year;">
     12<!ENTITY releasedate  "August 15th, &year;">
    1313<!-- <!ENTITY releasedate  "November &day;st, &year;"> -->
    1414<!ENTITY pubdate      "&year;-&month;-&day;"> <!-- metadata req. by TLDP -->
    … …  
    653653<!-- Chapter 22 -->
    654654<!ENTITY db-version                   "5.3.21">
    655 <!ENTITY mysql-version                "5.5.25a">
     655<!ENTITY mysql-version                "5.5.27">
    656656<!ENTITY postgresql-version           "9.1.4">
    657657<!ENTITY sqlite-version               "3.7.13">

  • introduction/welcome/changelog.xml

    r697cb83f re3fec8f  
    4545-->
    4646    <listitem>
     47      <para>August 15th, 2012</para>
     48      <itemizedlist>
     49        <listitem>
     50          <para>[rthomsen] - MySQL 5.5.27. Fixes
     51          <ulink url="&blfs-ticket-root;3492">#3492</ulink>.</para>
     52        </listitem>
     53      </itemizedlist>
     54    </listitem>
     55
     56    <listitem>
    4757      <para>August 14th, 2012</para>
    4858      <itemizedlist>
    … …  
    244254      <itemizedlist>
    245255        <listitem>
    246           <para>[bdubbs] - Updated to bind-9.9.1-P2.  Fixes
     256          <para>[bdubbs] - Updated to bind-9.9.1-P2. Fixes
    247257          <ulink url="&blfs-ticket-root;3416">#3416</ulink>.</para>
    248258        </listitem>
    249259        <listitem>
    250           <para>[bdubbs] - Updated to emacs-23.4.  Fixes
     260          <para>[bdubbs] - Updated to emacs-23.4. Fixes
    251261          <ulink url="&blfs-ticket-root;3409">#3409</ulink>.</para>
    252262        </listitem>

  • server/databases/mysql.xml

    r697cb83f re3fec8f  
    55  %general-entities;
    66
    7   <!ENTITY mysql-download-http "&sources-anduin-http;/m/mysql-&mysql-version;.tar.gz">
    8   <!ENTITY mysql-download-ftp  "&sources-anduin-ftp;/m/mysql-&mysql-version;.tar.gz">
    9   <!ENTITY mysql-md5sum        "0841fbc79872c5f467d8c8842f45257a">
     7  <!ENTITY mysql-download-http "http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-&mysql-version;.tar.gz/from/http://cdn.mysql.com/">
     8  <!ENTITY mysql-download-ftp  " ">
     9  <!ENTITY mysql-md5sum        "82baf46acfced6eef072e9d8a479c86e">
    1010  <!ENTITY mysql-size          "24 MB">
    1111  <!ENTITY mysql-buildsize     "930 MB (additional 170 MB to run the test suite)">
    … …  
    3434    server daemon and many different client programs and libraries.</para>
    3535
    36     <para>There may be a more recent release available from the
    37     <application>MySQL</application> home page. You can check
    38     <ulink url="http://dev.mysql.com/"/> and probably use the
    39     existing BLFS instructions. Note that versions other than the one shown
    40     in the download URLs have not been tested in a BLFS environment.</para>
    41 
    4236    &lfs71_checked;
    4337
    … …  
    6761    <itemizedlist spacing="compact">
    6862      <listitem>
    69         <para>Optional patch: <ulink
    70         url="&patch-root;/mysql-&mysql-version;-embedded-library-shared-1.patch"/></para>
     63        <para>Optional patch (required if building for Amarok): <ulink
     64        url="&patch-root;/mysql-&mysql-version;-embedded_library_shared-1.patch"/></para>
     65      </listitem>
     66      <listitem>
     67        <para>Optional patch (required if building only the client): <ulink
     68        url="&patch-root;/mysql-&mysql-version;-client_only_fix-1.patch"/></para>
    7169      </listitem>
    7270      <listitem>
    … …  
    7674       </listitem>
    7775    </itemizedlist>
    78 
    79     <note><para>The patch is required only if you plan to install <application>
    80     Amarok</application>.</para></note>
    8176   
    8277    <bridgehead renderas="sect3">MySQL Dependencies</bridgehead>
    … …  
    9792
    9893  </sect2>
    99 
     94 
    10095  <sect2 role="installation">
    10196    <title>Installation of MySQL</title>
    10297
     98    <sect3>
     99    <title>Building</title>
     100   
    103101    <para>For security reasons, running the server as an unprivileged user
    104     and group is strongly encouraged:</para>
     102    and group is strongly encouraged. Issue the following (as
     103    <systemitem class="username">root</systemitem>) to create the user and
     104    group:</para>
    105105
    106106<screen role="root"><userinput>groupadd -g 40 mysql &amp;&amp;
    107107useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false -u 40 mysql</userinput></screen>
    108108
    109     <note><para>There are a great many options available to
    110     <userinput>cmake</userinput>.  Check the output of the `<userinput>cmake .
    111     -LH</userinput>` for additional customization options.  See the <ulink
     109    <para>If the MySQL server is not needed, it is possible to build only the
     110    client libraries of MySQL. To do this you need to apply the optional patch,
     111    use the cmake option <parameter>-DWITHOUT_SERVER=ON</parameter> and the
     112    client-only installation instructions below.</para>
     113
     114    <para>MySQL contains an embedded server library which can be enabled with
     115    the cmake option <parameter>-DWITH_EMBEDDED_SERVER=ON</parameter>. By default
     116    this server is built as a statically linked library,
     117    <filename>libmysqld.a</filename>, but by applying the optional patch, a
     118    shared version of this library can be built. The shared library is needed
     119    by certain applications, such as <application>Amarok</application>.</para>
     120   
     121    <para>There are numerous options available to
     122    <userinput>cmake</userinput>. Check the output of the `<userinput>cmake .
     123    -LH</userinput>` for additional customization options. See the <ulink
    112124    url="http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html">MySQL
    113     Documentation</ulink> for a full listing of all options.</para></note>
    114 
    115  <note><para>If you plan to install <application>Amarok</application>, you need to
    116  apply the optional patch, add the cmake option
    117  <userinput>-DWITH_EMBEDDED_SERVER=ON</userinput> and add
    118  <userinput>Embedded</userinput> to the <userinput>SEGMENTS</userinput> variable
    119  below.</para></note>
    120    
    121     <para>Apply the optional patch:</para>
    122    
    123  <screen><userinput>patch -Np1 -i ../mysql-&mysql-version;-embedded-library-shared-1.patch</userinput></screen>   
    124    
    125     <para>Build and install <application>MySQL</application> by
     125    Documentation</ulink> for a full listing of all options.</para>
     126   
     127    <para>If you want the shared version of the embedded server library, apply
     128    the patch:</para>
     129   
     130<screen><userinput>patch -Np1 -i ../mysql-&mysql-version;-embedded_library_shared-1.patch</userinput></screen>
     131
     132     <para>If building the client-only, apply the patch:</para>
     133
     134<screen><userinput>patch -Np1 -i ../mysql-&mysql-version;-client_only_fix-1.patch</userinput></screen>
     135   
     136    <para>Configure and build <application>MySQL</application> by
    126137    running the following commands:</para>
    127138   
    128 <screen><userinput> mkdir build &amp;&amp;                                 \
    129 cd    build &amp;&amp;                                 \
    130 cmake ..                                          \
    131       -DSYSCONFDIR=/etc                           \
    132       -DMYSQL_DATADIR=/srv/mysql                  \
    133       -DINSTALL_MYSQLDATADIR=/srv/mysql           \
    134       -DCMAKE_INSTALL_PREFIX=/usr                 \
    135       -DINSTALL_BINDIR=bin                        \
    136       -DINSTALL_SBINDIR=sbin                      \
    137       -DINSTALL_DOCDIR=share/doc/mysql            \
    138       -DINSTALL_DOCREADMEDIR=share/doc/mysql      \
    139       -DINSTALL_INCLUDEDIR=include/mysql          \
    140       -DINSTALL_INFODIR=share/info                \
    141       -DINSTALL_LIBDIR=lib                        \
    142       -DINSTALL_MANDIR=share/man                  \
    143       -DINSTALL_MYSQLSHAREDIR=share/mysql         \
    144       -DINSTALL_MYSQLTESTDIR=share/mysql-test     \
    145       -DINSTALL_PLUGINDIR=lib/plugin              \
    146       -DINSTALL_SCRIPTDIR=bin                     \
    147       -DINSTALL_SHAREDIR=share/mysql              \
    148       -DINSTALL_SQLBENCHDIR=share/mysql-bench     \
    149       -DINSTALL_SUPPORTFILESDIR=share/mysql/support-files \
    150       -DWITH_ZLIB=system                          \
    151       -DWITH_SSL=system                           \
    152       -DWITH_READLINE=system                      \
    153       -DMYSQL_UNIX_ADDR=/var/run/mysql/mysql.sock \
    154       -DWITH_ARCHIVE_STORAGE_ENGINE=1             \
    155       -DWITH_FEDERATED_STORAGE_ENGINE=1           \
    156       -DWITH_BLACKHOLE_STORAGE_ENGINE=1           \
    157       -DMYSQL_MAINTAINER_MODE=OFF                 \
    158       -DWITH_DEBUG=OFF                            &amp;&amp;
    159 
     139<screen><userinput>mkdir build &amp;&amp;                                      \
     140cd build &amp;&amp;                                         \
     141cmake -DCMAKE_INSTALL_PREFIX=/usr                   \
     142      -DINSTALL_DOCDIR=share/doc/mysql              \
     143      -DINSTALL_DOCREADMEDIR=share/doc/mysql        \
     144      -DINSTALL_INCLUDEDIR=include/mysql            \
     145      -DINSTALL_INFODIR=share/info                  \
     146      -DINSTALL_MANDIR=share/man                    \
     147      -DINSTALL_MYSQLDATADIR=/srv/mysql             \
     148      -DINSTALL_MYSQLSHAREDIR=share/mysql           \
     149      -DINSTALL_MYSQLTESTDIR=share/mysql/test       \
     150      -DINSTALL_PLUGINDIR=lib/mysql                 \
     151      -DINSTALL_SBINDIR=sbin                        \
     152      -DINSTALL_SCRIPTDIR=bin                       \
     153      -DINSTALL_SQLBENCHDIR=share/mysql/bench       \
     154      -DINSTALL_SUPPORTFILESDIR=share/mysql/support \
     155      -DMYSQL_DATADIR=/srv/mysql                    \
     156      -DMYSQL_UNIX_ADDR=/var/run/mysql/mysql.sock   \
     157      -DSYSCONFDIR=/etc                             \
     158      -DWITH_PARTITION_STORAGE_ENGINE=OFF           \
     159      -DWITH_PERFSCHEMA_STORAGE_ENGINE=OFF          \
     160      -DWITH_READLINE=system                        \
     161      -DWITH_SSL=system                             \
     162      .. &amp;&amp;
    160163make</userinput></screen>
    161164
    … …  
    171174    either as a module or built in.</para>
    172175
    173     <note><para>The ssl tests may fail due to expired certifictes.</para></note>
    174 
    175     <para>Now, as the <systemitem class="username">root</systemitem> user:</para>
     176    <note><para>The SSL tests may fail due to expired certificates.</para></note>
     177    </sect3>
     178   
     179    <sect3>
     180      <title>Installation (server and client)</title>
     181   
     182      <para>To install the server and client, issue the following command (as
     183      the <systemitem class="username">root</systemitem> user):</para>
    176184
    177185<screen role="root"><userinput>SEGMENTS="Client Server IniFiles ManPages SharedLibraries"
    … …  
    184192unset SEGMENTS</userinput></screen>
    185193
    186     <tip>
    187       <para>The only documentation shipped in the source tarball are
     194      <note><para>If you built the embedded server library add
     195      <userinput>Embedded</userinput> to the <userinput>SEGMENTS</userinput>
     196      variable above.</para></note>
     197
     198      <tip><para>The only documentation shipped in the source tarball are
    188199      <filename>mysql.info</filename> and man pages. You can download various
    189200      formats of the <application>MySQL</application> Reference Manual
    190       from <ulink url="http://dev.mysql.com/doc/"/>.</para>
    191     </tip>
    192 
    193     <note><para>If you only want to build and install the
    194       <command>mysql</command> client, use:</para>
    195 
    196       <screen><userinput>cmake . &amp;&amp;
    197 make mysqlclient libmysql</userinput></screen>
    198 
    199       <para>Continue as root:</para>
    200 
    201       <screen role="root"><userinput>make install</userinput></screen>
    202     </note>
     201      from <ulink url="http://dev.mysql.com/doc/"/>.</para></tip>
     202
     203    </sect3>
     204
     205    <sect3>
     206      <title>Installation (client only)</title>
     207      <para>If you would like to install the client software only, issue the
     208      following (as <systemitem class="username">root</systemitem>):</para>
     209
     210<screen role="root"><userinput>SEGMENTS="Client ManPages SharedLibraries"
     211SEGMENTS="$SEGMENTS Development Documentation Info Readme"
     212
     213for segment in $SEGMENTS; do
     214   cmake -DCMAKE_INSTALL_COMPONENT=$segment -P cmake_install.cmake
     215done
     216
     217unset SEGMENTS</userinput></screen>
     218
     219    </sect3>
    203220
    204221  </sect2>
    … …  
    207224    <title>Command Explanations</title>
    208225
     226    <para><parameter>-DWITH_&lt;engine&gt;_STORAGE_ENGINE=ON</parameter>: The default
     227    instructions only build the innobase (InnoDB) storage engine. If other
     228    storage engines are desired use this switch to enable them. Valid choices
     229    are ARCHIVE, BLACKHOLE, EXAMPLE, FEDERATED, INNOBASE, NDBCLUSTER,
     230    PARTITION and PERFSCHEMA.</para>
     231
     232    <para><parameter>-DWITHOUT_SERVER=ON</parameter>: Use this switch if you don't
     233    want the server and would like to build the client only.</para>
     234
     235    <para><parameter>-DWITH_EMBEDDED_SERVER=ON</parameter>: Use this switch to build
     236    the embedded server library.</para>
     237   
     238    <para><parameter>-DWITH_SSL=system</parameter>: Use this switch to build
     239    against a system version of SSL.</para>
     240
    209241    <para><command>cmake -DCMAKE_INSTALL_COMPONENT=$segment ...</command>: This
    210     command installs the appropriate portion of the package.  Different
    211     segemnts may be added or deleted as desired.  Valid segments are listed
    212     with `<command>make list_install_components</command>`.  Note that the
    213     'DataFiles' install segment does not honor the -DMYSQL_DATADIR or
    214     -DINSTALL_MYSQLDATADIR statements.</para>
     242    command installs the appropriate portion of the package. Different
     243    segments may be added or deleted as desired.  Valid segments are listed
     244    with `<command>make list_install_components</command>`.
     245    Note that the 'DataFiles' install segment does not honor the
     246    -DMYSQL_DATADIR or -DINSTALL_MYSQLDATADIR statements and installs datafiles
     247    in <filename class="directory">/usr/data</filename>.</para>
    215248
    216249  </sect2>
    … …  
    305338
    306339      <seglistitem>
    307         <seg>comp_err, innochecksum, msql2mysql, my_print_defaults,
    308         myisam_ftdump, myisamchk, myisamlog, myisampack, mysql,
    309         mysql_client_test, mysql_config, mysql_convert_table_format,
    310         mysql_create_system_tables, mysql_explain_log, mysql_find_rows,
    311         mysql_fix_extensions, mysql_fix_privilege_tables, mysql_install_db,
    312         mysql_secure_installation, mysql_setpermission, mysql_tableinfo,
    313         mysql_tzinfo_to_sql, mysql_waitpid, mysql_zap, mysqlaccess, mysqladmin,
     340        <seg>innochecksum, msql2mysql, my_print_defaults, myisam_ftdump,
     341        myisamchk, myisamlog, myisampack, mysql, mysql_client_test,
     342        mysql_config, mysql_convert_table_format, mysql_find_rows,
     343        mysql_fix_extensions, mysql_install_db, mysql_plugin,
     344        mysql_secure_installation, mysql_setpermission, mysql_tzinfo_to_sql,
     345        mysql_upgrade, mysql_waitpid, mysql_zap, mysqlaccess, mysqladmin,
    314346        mysqlbinlog, mysqlbug, mysqlcheck, mysqld, mysqld_multi, mysqld_safe,
    315         mysqldump, mysqldumpslow, mysqlhotcopy, mysqlimport, mysqlmanager,
    316         mysqlshow, mysqltest, mysqltestmanager, mysqltestmanager-pwgen,
    317         mysqltestmanagerc, perror, replace, resolve_stack_dump, and
     347        mysqldump, mysqldumpslow, mysqlhotcopy, mysqlimport, mysqlshow,
     348        mysqlslap, mysqltest, perror, replace, resolve_stack_dump and
    318349        resolveip</seg>
    319         <seg>libdbug.a, libheap.a, libmyisam.a, libmyisammrg.a,
    320         libmysqlclient.{so,a}, libmysqlclient_r.{so,a}, libmystrings.a,
    321         libmysys.a, and libvio.a</seg>
    322         <seg>/srv/mysql, /usr/include/mysql, /usr/lib/plugin, /usr/share/mysql and
     350        <seg>libmysqlclient.{so,a}, libmysqlclient_r.{so,a}, libmysqlservices.a
     351        and several in /usr/lib/mysql</seg>
     352        <seg>/srv/mysql, /usr/include/mysql, /usr/lib/mysql, /usr/share/mysql and
    323353        /var/run/mysql</seg>
    324354      </seglistitem>
    … …  
    330360    pages long. Instead, consult the <filename>mysql.info</filename>
    331361    documentation or the on-line reference manual at <ulink
    332     url="http://dev.mysql.com/doc/refman/5.1/en/index.html"/>.</para>
     362    url="http://dev.mysql.com/doc/refman/5.5/en/index.html"/>.</para>
    333363
    334364    <para>The <application>Perl</application> DBI modules must be installed
Note: See TracChangeset for help on using the changeset viewer.