Changeset 648b2c0
- Timestamp:
- 09/13/2024 07:16:47 PM (3 weeks ago)
- Branches:
- trunk
- Children:
- 6f58853
- Parents:
- 612a60b
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
general.ent
r612a60b r648b2c0 127 127 <!-- End LFS versions --> 128 128 129 <!ENTITY blfs-bootscripts-version "20240 416">129 <!ENTITY blfs-bootscripts-version "20240913"> 130 130 <!ENTITY systemd-units-version "20240801"> 131 131 -
introduction/welcome/changelog.xml
r612a60b r648b2c0 43 43 <itemizedlist> 44 44 <listitem> 45 <para>[bdubbs] - Update to mariadb-11.4.3. Fixes 46 <ulink url="&blfs-ticket-root;20344">#20344</ulink>.</para> 47 </listitem> 48 <listitem> 45 49 <para>[bdubbs] - Update to sentry_sdk-2.14.0 (Python module). Fixes 46 50 <ulink url="&blfs-ticket-root;20343">#20343</ulink>.</para> -
postlfs/config/users.xml
r612a60b r648b2c0 98 98 <row><entry>kdm </entry><entry>37</entry><entry>37</entry></row> 99 99 <row><entry>fetchmail</entry><entry>38</entry><entry> </entry></row> 100 <row><entry>m ysql</entry><entry>40</entry><entry>40</entry></row>100 <row><entry>mariadb </entry><entry>40</entry><entry>40</entry></row> 101 101 <row><entry>postgres</entry><entry>41</entry><entry>41</entry></row> 102 102 <row><entry>dovecot </entry><entry>42</entry><entry>42</entry></row> -
server/databases/mariadb.xml
r612a60b r648b2c0 8 8 <!ENTITY mariadb-download-http "https://downloads.mariadb.org/interstitial/mariadb-&mariadb-version;/source/mariadb-&mariadb-version;.tar.gz"> 9 9 <!ENTITY mariadb-download-ftp " "> 10 <!ENTITY mariadb-md5sum " ba7abfae7947893c5a5343180808b0cb">11 <!ENTITY mariadb-size " 96MB">12 <!ENTITY mariadb-buildsize " 1.9 GB (415MB installed)">13 <!ENTITY mariadb-time " 4.8 SBU (with parallelism=8, add 0.3SBU for tests)">10 <!ENTITY mariadb-md5sum "c19f97dc1ea3165fb282a8384155dc0a"> 11 <!ENTITY mariadb-size "103 MB"> 12 <!ENTITY mariadb-buildsize "2.1 GB (741 MB installed)"> 13 <!ENTITY mariadb-time "3.3 SBU (with parallelism=8, add 0.5 SBU for tests)"> 14 14 ]> 15 15 … … 71 71 <note> 72 72 <para> 73 The installed size of MariaDB is 7 25MB, but this can be74 reduced by about 26 5MB, if desired, by removing the <filename75 class="directory">/usr/share/m ysql/test</filename>73 The installed size of MariaDB is 741 MB, but this can be 74 reduced by about 263 MB, if desired, by removing the <filename 75 class="directory">/usr/share/mariadb/test</filename> 76 76 directory after installation. 77 77 </para> … … 121 121 <ulink url="https://mariadb.com/kb/en/myrocks/">MyRocks</ulink>, 122 122 <ulink url="https://github.com/google/snappy">Snappy</ulink>, and 123 <!--<ulink url="https://mariadb.com/kb/en/mariadb/tokudb/">TokuDB</ulink>, and-->124 123 <ulink url="https://zeromq.org/">ZeroMQ</ulink> 125 124 </para> 126 127 125 128 126 </sect2> … … 145 143 </para> 146 144 147 <screen role="root"><userinput>groupadd -g 40 mysql && 148 useradd -c "MySQL Server" -d /srv/mysql -g mysql -s /bin/false -u 40 mysql</userinput></screen> 149 <!-- 150 <para> 151 Fix a stack smashing error introduced by openssl-3: 152 </para> 153 154 <screen><userinput remap="pre">patch -Np1 -i ../mariadb-&mariadb-version;-openssl3_fix-1.patch</userinput></screen> 155 --> 145 <screen role="root"><userinput>groupadd -g 40 mariadb && 146 useradd -c "MySQL Server" -d /srv/mariadb -g mariadb -s /bin/false -u 40 mariadb</userinput></screen> 147 156 148 <para> 157 149 Install <application>MariaDB</application> by running the … … 168 160 -D INSTALL_DOCREADMEDIR=share/doc/mariadb-&mariadb-version; \ 169 161 -D INSTALL_MANDIR=share/man \ 170 -D INSTALL_MYSQLSHAREDIR=share/m ysql\171 -D INSTALL_MYSQLTESTDIR=share/m ysql/test\162 -D INSTALL_MYSQLSHAREDIR=share/mariadb \ 163 -D INSTALL_MYSQLTESTDIR=share/mariadb/test \ 172 164 -D INSTALL_PAMDIR=lib/security \ 173 165 -D INSTALL_PAMDATADIR=/etc/security \ 174 -D INSTALL_PLUGINDIR=lib/m ysql/plugin\166 -D INSTALL_PLUGINDIR=lib/mariadb/plugin \ 175 167 -D INSTALL_SBINDIR=sbin \ 176 168 -D INSTALL_SCRIPTDIR=bin \ 177 -D INSTALL_SQLBENCHDIR=share/m ysql/bench\178 -D INSTALL_SUPPORTFILESDIR=share/m ysql\179 -D MYSQL_DATADIR=/srv/m ysql\180 -D MYSQL_UNIX_ADDR=/run/m ysqld/mysqld.sock\169 -D INSTALL_SQLBENCHDIR=share/mariadb/bench \ 170 -D INSTALL_SUPPORTFILESDIR=share/mariadb \ 171 -D MYSQL_DATADIR=/srv/mariadb \ 172 -D MYSQL_UNIX_ADDR=/run/mariadb/mariadb.sock \ 181 173 -D WITH_EXTRA_CHARSETS=complex \ 182 174 -D WITH_EMBEDDED_SERVER=ON \ … … 188 180 <para> 189 181 To test the results, issue: <command>make test</command>. 190 One test, test-connect, isknown to fail.182 Two tests, my_tzinfo and test-connect, are known to fail. 191 183 </para> 192 184 … … 262 254 263 255 <para> 264 <filename>/etc/m ysql/my.cnf</filename> and256 <filename>/etc/mariadb/my.cnf</filename> and 265 257 <filename>~/.my.cnf</filename> 266 258 </para> … … 271 263 272 264 <indexterm zone="mariadb mariadb-config"> 273 <primary sortas="e-etc-m ysql-my.cnf">/etc/mysql/my.cnf</primary>265 <primary sortas="e-etc-mariadb-my.cnf">/etc/mariadb/my.cnf</primary> 274 266 </indexterm> 275 267 … … 280 272 281 273 <para> 282 Create a basic <filename>/etc/m ysql/my.cnf</filename>274 Create a basic <filename>/etc/mariadb/my.cnf</filename> 283 275 file using the following command as the <systemitem 284 276 class="username">root</systemitem> user: 285 277 </para> 286 278 287 <screen role="root"><userinput>install -v -dm 755 /etc/m ysql&&288 cat > /etc/m ysql/my.cnf << "EOF"289 <literal># Begin /etc/m ysql/my.cnf279 <screen role="root"><userinput>install -v -dm 755 /etc/mariadb && 280 cat > /etc/mariadb/my.cnf << "EOF" 281 <literal># Begin /etc/mariadb/my.cnf 290 282 291 283 # The following options will be passed to all MySQL clients … … 293 285 #password = your_password 294 286 port = 3306 295 socket = /run/m ysqld/mysqld.sock287 socket = /run/mariadb/mariadb.sock 296 288 297 289 # The MySQL server 298 [m ysqld]290 [mariadb] 299 291 port = 3306 300 socket = /run/m ysqld/mysqld.sock301 datadir = /srv/m ysql292 socket = /run/mariadb/mariadb.sock 293 datadir = /srv/mariadb 302 294 skip-external-locking 303 295 key_buffer_size = 16M … … 318 310 319 311 # InnoDB tables are now used by default 320 innodb_data_home_dir = /srv/m ysql321 innodb_log_group_home_dir = /srv/m ysql312 innodb_data_home_dir = /srv/mariadb 313 innodb_log_group_home_dir = /srv/mariadb 322 314 # All the innodb_xxx values below are the default ones: 323 315 innodb_data_file_path = ibdata1:12M:autoextend 324 316 # You can set .._buffer_pool_size up to 50 - 80 % 325 317 # of RAM but beware of setting memory usage too high 326 innodb_buffer_pool_size = 128M<!-- 327 This variable has been removed in version 10.2.2: 328 innodb_additional_mem_pool_size = 2M--> 318 innodb_buffer_pool_size = 128M 329 319 innodb_log_file_size = 48M 330 320 innodb_log_buffer_size = 16M … … 332 322 innodb_lock_wait_timeout = 50 333 323 334 [m ysqldump]324 [mariadbdump] 335 325 quick 336 326 max_allowed_packet = 16M 337 327 338 [m ysql]328 [mariadb] 339 329 no-auto-rehash 340 330 # Remove the next comment character if you are not familiar with SQL … … 353 343 write_buffer = 2M 354 344 355 [m ysqlhotcopy]345 [mariadbhotcopy] 356 346 interactive-timeout 357 347 358 # End /etc/m ysql/my.cnf</literal>348 # End /etc/mariadb/my.cnf</literal> 359 349 EOF</userinput></screen> 360 350 … … 365 355 </para> 366 356 367 <screen role="root"><userinput>m ysql_install_db --basedir=/usr --datadir=/srv/mysql --user=mysql&&368 chown -R m ysql:mysql /srv/mysql</userinput></screen>357 <screen role="root"><userinput>mariadb-install-db --basedir=/usr --datadir=/srv/mariadb --user=mariadb && 358 chown -R mariadb:mariadb /srv/mariadb</userinput></screen> 369 359 370 360 <para> … … 375 365 </para> 376 366 377 <screen role="root"><userinput>install -v -m755 -o m ysql -g mysql -d /run/mysqld&&378 m ysqld_safe --user=mysql2>&1 >/dev/null &</userinput></screen>367 <screen role="root"><userinput>install -v -m755 -o mariadb -g mariadb -d /run/mariadb && 368 mariadbd-safe --user=mariadb 2>&1 >/dev/null &</userinput></screen> 379 369 380 370 <para> … … 384 374 </para> 385 375 386 <screen role="root"><userinput>m ysqladmin -u root password</userinput></screen>376 <screen role="root"><userinput>mariadb-admin -u root password</userinput></screen> 387 377 388 378 <para> … … 392 382 </para> 393 383 394 <screen role="root"><userinput>m ysqladmin -p shutdown</userinput></screen>384 <screen role="root"><userinput>mariadb-admin -p shutdown</userinput></screen> 395 385 396 386 </sect3> … … 402 392 <para> 403 393 Install the 404 <phrase revision="sysv"><filename>/etc/rc.d/init.d/m ysql</filename> init394 <phrase revision="sysv"><filename>/etc/rc.d/init.d/mariadb</filename> init 405 395 script</phrase> 406 <phrase revision="systemd"><filename>m ysqld.service</filename>396 <phrase revision="systemd"><filename>mariadb.service</filename> 407 397 unit</phrase> included in the 408 398 <xref linkend="bootscripts" revision="sysv"/> … … 413 403 414 404 <indexterm zone="mariadb mariadb-init"> 415 <primary sortas="f-m ysql">mysql</primary>405 <primary sortas="f-mariadb">mariadb</primary> 416 406 </indexterm> 417 407 418 <screen role="root" revision="sysv"><userinput>make install-m ysql</userinput></screen>419 420 <screen role="root" revision="systemd"><userinput>make install-m ysqld</userinput></screen>408 <screen role="root" revision="sysv"><userinput>make install-mariadb</userinput></screen> 409 410 <screen role="root" revision="systemd"><userinput>make install-mariadb</userinput></screen> 421 411 422 412 <note> … … 463 453 </seg> 464 454 <seg> 465 libmariadbclient.a, libmariadb.so, libmariadbd.so, libmysqlclient.a, 466 libmysqlclient_r.a (symbolic links to libmariadbclient.a), 467 libmysqld.{so,a}, libmysqlservices.a, 468 and several under /usr/lib/mysql/plugin/ 455 libmariadb.a (symlink to libmariadbclient.a), 456 libmariadb.so (symlink to libmariadb.so.3), 457 libmariadbclient.a, 458 libmariadbd.a, 459 libmariadbd.so (symlik to libmariadbd.so.19), 460 libmariadbd.so.19, 461 libmariadb.so.3, 462 libmysqlclient.a (symlik to libmariadbclient.a), 463 libmysqlclient.so (symlik to libmariadb.so.3), 464 libmysqlclient_r.a (symlik to libmariadbclient.a), 465 libmysqlclient_r.so (symlik to libmariadbclient.a), 466 libmysqld.a (symlink to libmariadbd.a), 467 libmysqld.so (symlink to libmariadbd.so.19), 468 libmysqlservices.a, and 469 about 70 modules under /usr/lib/mysql/plugin/ 469 470 </seg> 470 471 <seg> 471 /etc/mysql,472 472 /usr/{include,lib,share}/mysql, 473 /usr/share/groonga{ -normalizer-mysql}, and473 /usr/share/groonga{,-normalizer-mysql}, and 474 474 /usr/share/doc/mariadb-&mariadb-version; 475 475 </seg> … … 703 703 <para> 704 704 is used for testing aspects of the MySQL client API that cannot be 705 tested using m ysqltest and its test language705 tested using mariadb-test and its test language 706 706 </para> 707 707 <indexterm zone="mariadb mariadb-client-test-mariadb"> … … 752 752 <listitem> 753 753 <para> 754 is designed to manage several m ysqldprocesses that listen for754 is designed to manage several mariadb processes that listen for 755 755 connections on different Unix socket files and TCP/IP ports 756 756 </para> … … 765 765 <listitem> 766 766 <para> 767 is the recommended way to start a m ysqldserver on Unix767 is the recommended way to start a mariadb server on Unix 768 768 and NetWare 769 769 </para> … … 981 981 <listitem> 982 982 <para> 983 is similar to the <command>m ysqltest</command> command but is built984 with support for the libm ysqld embedded server983 is similar to the <command>mariadb-test</command> command but is built 984 with support for the libmariadbd embedded server 985 985 </para> 986 986 <indexterm zone="mariadb mariadb-test-embedded-mariadb"> … … 994 994 <listitem> 995 995 <para> 996 loads the time zone tables in the m ysqldatabase996 loads the time zone tables in the mariadb database 997 997 </para> 998 998 <indexterm zone="mariadb mariadb-tzinfo-to-sql-mariadb">
Note:
See TracChangeset
for help on using the changeset viewer.