BSD Ports

databases/mysql97-server 9.7.2_3 FreeBSD

Multithreaded SQL database (server)

System
FreeBSD
Repository
FreeBSD ports
Maintainer
[email protected]
Last update
Commit
443408a666
License
GPLv2
Categories
databases
Package size
27842.1 KiB, 193726.6 KiB installed

Description

MySQL is a very fast, multi-threaded, multi-user and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software

Install

Binary package:

pkg install mysql97-server

From the ports tree:

cd /usr/ports/databases/mysql97-server/ && make install clean

To depend on this port in another port's Makefile:

RUN_DEPENDS=	mysql97-server>0:databases/mysql97-server

Packages

The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.

Repositoryaarch64amd64armv6armv7i386
FreeBSD:14:latest9.7.2_39.7.2_3---
FreeBSD:14:quarterly9.7.2_39.7.2_3n/a--
FreeBSD:15:latest9.7.2_39.7.2_3n/a--
FreeBSD:15:quarterly9.7.2_39.7.2_3n/an/an/a
FreeBSD:16:latest9.7.2_39.7.2_3n/an/an/a
FreeBSD:16:quarterlyn/an/an/an/an/a

Dependencies

The Makefile names none itself; they come from USES and USE_*.

The full lists below include those, and their dependencies in turn.

Build dependencies 34
Run dependencies 23

No port depends on this one.

Configuration

No options to configure.

USES
bison:build cmake:noninja cpe groff:run libedit localbase ncurses perl5 pkgconfig shebangfix ssl compiler:c++20-lang
Service scripts
none

Message after installing

There is no initial password for first time use of MySQL.
Keep in mind to reset it to a secure password.

MySQL 9.7 has a default /usr/local/etc/mysql/my.cnf,
remember to replace it with your own
or set `mysql_optfile="$YOUR_CNF_FILE"` in rc.conf.

MySQL Router is part of this package.  It is disabled by default.  To use it:

	cp /usr/local/etc/mysqlrouter/mysqlrouter.conf.sample \
		/usr/local/etc/mysqlrouter/mysqlrouter.conf
	sysrc mysqlrouter_enable=YES
	service mysqlrouter start

The router runs as the user "mysqlrouter" and logs to
/var/log/mysqlrouter/mysqlrouter.log.  Do not add a "pid_file" or a "user"
entry to mysqlrouter.conf, the rc script takes care of both.

When creating a configuration for an InnoDB cluster, run
mysqlrouter_bootstrap --user=mysqlrouter, so that the generated
files below /var/db/mysqlrouter belong to that account.

If the router has to serve many connections, raise "openfiles" for its login
class in /etc/login.conf and point mysqlrouter_login_class in rc.conf at it,
upstream uses 10000.

The MySQL server performs all upgrade tasks itself at startup.
The mysql_upgrade utility does not exist anymore in MySQL 9.x.

This version adds an rc script, a configuration sample and the system user
"mysqlrouter" for MySQL Router.  Nothing is enabled automatically.

If you already run MySQL Router yourself, note:

- An own /usr/local/etc/rc.d/mysqlrouter was renamed to mysqlrouter.pkgsave
  by pkg and is not used anymore.
- An existing /var/log/mysqlrouter, /var/run/mysqlrouter or
  /var/db/mysqlrouter is left untouched, ownership and permissions are not
  changed.  The rc script only creates the directories when they are
  missing.  If your router runs under a different account, set
  mysqlrouter_user and mysqlrouter_group in rc.conf.
- /usr/local/etc/logrotate.d/mysqlrouter works from now on, its
  "create 600 mysqlrouter mysqlrouter" no longer points at a missing user.

Files

Manual pages 17
  • ibd2sdi(1)
  • innochecksum(1)
  • my_print_defaults(1)
  • myisam_ftdump(1)
  • myisamchk(1)
  • myisamlog(1)
  • myisampack(1)
  • mysql.server(1)
  • mysql_secure_installation(1)
  • mysql_tzinfo_to_sql(1)
  • mysqld(8)
  • mysqld_multi(1)
  • mysqld_safe(1)
  • mysqldumpslow(1)
  • mysqlrouter(1)
  • mysqlrouter_passwd(1)
  • mysqlrouter_plugin_info(1)
pkg-plist 314
  • bin/ibd2sdi
  • bin/innochecksum
  • bin/myisam_ftdump
  • bin/myisamchk
  • bin/myisamlog
  • bin/myisampack
  • bin/mysql_client_test
  • bin/mysql_keyring_encryption_test
  • bin/mysql_test_event_tracking
  • bin/mysql_tzinfo_to_sql
  • bin/mysqld_multi
  • bin/mysqld_safe
  • bin/mysqldumpslow
  • bin/mysqlrouter
  • bin/mysqlrouter_bootstrap
  • bin/mysqlrouter_keyring
  • bin/mysqlrouter_mrs_client
  • bin/mysqlrouter_passwd
  • bin/mysqlrouter_plugin_info
  • bin/mysqlxtest
  • bin/mysqltest_safe_process
  • etc/logrotate.d/mysqlrouter
  • @sample etc/mysqlrouter/mysqlrouter.conf.sample
  • etc/mysql97-server/my.cnf.sample
  • lib/mysql/mysqlrouter/rest_host_cache.so
  • lib/mysql/plugin/component_group_replication_elect_prefers_most_updated.so
  • lib/mysql/plugin/component_group_replication_flow_control_stats.so
  • lib/mysql/plugin/component_group_replication_resource_manager.so
  • lib/mysql/plugin/component_replication_applier_metrics.so
  • lib/mysql/plugin/component_telemetry.so
  • lib/mysql/plugin/component_test_telemetry_resource_provider.so
  • lib/mysql/plugin/component_test_telemetry_secret_provider.so
  • lib/mysql/plugin/telemetry_client.so
  • lib/mysql/libmysqlharness.so
  • lib/mysql/libmysqlharness.so.1
  • lib/mysql/libmysqlharness_stdx.so
  • lib/mysql/libmysqlharness_stdx.so.1
  • lib/mysql/libmysqlharness_tls.so
  • lib/mysql/libmysqlharness_tls.so.1
  • lib/mysql/libmysqlrouter.so
  • lib/mysql/libmysqlrouter.so.1
  • lib/mysql/libmysqlrouter_cluster.so
  • lib/mysql/libmysqlrouter_cluster.so.1
  • lib/mysql/libmysqlrouter_connection_pool.so
  • lib/mysql/libmysqlrouter_connection_pool.so.1
  • lib/mysql/libmysqlrouter_destination_status.so
  • lib/mysql/libmysqlrouter_destination_status.so.1
  • lib/mysql/libmysqlrouter_http.so
  • lib/mysql/libmysqlrouter_http.so.1
  • lib/mysql/libmysqlrouter_http_auth_backend.so
  • lib/mysql/libmysqlrouter_http_auth_backend.so.1
  • lib/mysql/libmysqlrouter_http_auth_realm.so
  • lib/mysql/libmysqlrouter_http_auth_realm.so.1
  • lib/mysql/libmysqlrouter_http_client.so
  • lib/mysql/libmysqlrouter_http_client.so.1
  • lib/mysql/libmysqlrouter_http_server.so
  • lib/mysql/libmysqlrouter_http_server.so.1
  • lib/mysql/libmysqlrouter_io_component.so
  • lib/mysql/libmysqlrouter_io_component.so.1
  • lib/mysql/libmysqlrouter_metadata_cache.so
  • lib/mysql/libmysqlrouter_metadata_cache.so.1
  • lib/mysql/libmysqlrouter_mysql.so
  • lib/mysql/libmysqlrouter_mysql.so.1
  • lib/mysql/libmysqlrouter_mysqlclient.so
  • lib/mysql/libmysqlrouter_mysqlclient.so.1
  • lib/mysql/libmysqlrouter_mysqlxclient.so
  • lib/mysql/libmysqlrouter_mysqlxclient.so.1
  • lib/mysql/libmysqlrouter_mysqlxmessages.so
  • lib/mysql/libmysqlrouter_mysqlxmessages.so.1
  • lib/mysql/libmysqlrouter_routing.so
  • lib/mysql/libmysqlrouter_routing.so.1
  • lib/mysql/libmysqlrouter_routing_connections.so
  • lib/mysql/libmysqlrouter_routing_connections.so.1
  • lib/mysql/libmysqlrouter_routing_guidelines.so
  • lib/mysql/libmysqlrouter_utils.so
  • lib/mysql/libmysqlrouter_routing_guidelines.so.1
  • lib/mysql/libmysqlrouter_utils.so.1
  • lib/mysql/libprotobuf.so.24.4.0
  • lib/mysql/mysqlrouter/connection_pool.so
  • lib/mysql/mysqlrouter/destination_status.so
  • lib/mysql/mysqlrouter/host_cache.so
  • lib/mysql/mysqlrouter/http_auth_backend.so
  • lib/mysql/mysqlrouter/http_auth_realm.so
  • lib/mysql/mysqlrouter/http_server.so
  • lib/mysql/mysqlrouter/io.so
  • lib/mysql/mysqlrouter/keepalive.so
  • lib/mysql/mysqlrouter/metadata_cache.so
  • lib/mysql/mysqlrouter/mysql_rest_service.so
  • lib/mysql/mysqlrouter/rest_api.so
  • lib/mysql/mysqlrouter/rest_connection_pool.so
  • lib/mysql/mysqlrouter/rest_metadata_cache.so
  • lib/mysql/mysqlrouter/rest_router.so
  • lib/mysql/mysqlrouter/rest_routing.so
  • lib/mysql/mysqlrouter/router_openssl.so
  • lib/mysql/mysqlrouter/router_protobuf.so
  • lib/mysql/mysqlrouter/routing.so
  • lib/mysql/plugin/adt_null.so
  • lib/mysql/plugin/auth.so
  • lib/mysql/plugin/auth_test_plugin.so
  • lib/mysql/plugin/component_audit_api_message_emit.so

The first 100 are listed.

distinfo 1
FileSizeSHA256
mysql-9.7.2.tar.gz4.29211578e+08e5a676c7cb73738dc6ea33db2093806ebd512b629a139b897fcab68fcd81aaa4
Master sites 1
  • MYSQL/MySQL-9.7

Commit history 8

DateCommitCreditsLog message
443408a666 Alexander Leidinger databases/mysql*-server: make the rc script service jail aware
Set a default of net_basic for the service jail options, so mysqld can use IPv4/IPv6 when it is started in a service jail. The default can be overridden via rc.conf. PR: 279672 Sponsored by: Netzkommune GmbH
1456e7bf4a Jochen Neumeister databases/mysql97-server: Add maintainer note per new ports policy
The maintainer load and port lifecycle policy only excludes a port from the outdated ratio when the reason is documented in the port itself: https://wiki.freebsd.org/Ports/MaintainerLoadAndPortLifecyclePolicy repology merges every MySQL release series into a single project and measures each of them against the newest train upstream ships. At the time of writing it lists 26.7.0 as the newest MySQL and therefore reports this port as outdated, although it carries 9.7.2, the latest release of its own series. The 26.x train is not packaged in the tree at all, so this is a measurement artifact rather than a pending update. No functional change, comment only. Sponsored by: Netzkommune GmbH
3c9444219a Jochen Neumeister databases/mysql{80,84,97}-server: Fix build on CPUs without SSE4.2
The crc32 code declares target("sse4.2"), but the _mm_crc32_* intrinsics require the crc32 feature. With -mno-crc32, as emitted by -march=native on a CPU without the instruction, sse4.2 no longer implies crc32 and the build fails. Declare crc32 instead, including the two flatten wrappers that inline those intrinsics. PR: 275404 Sponsored by: Netzkommune GmbH
3f2328fca5 Jochen Neumeister databases/mysql{80,84,97}-server: Add rc script and user for MySQL Router
All three server ports build and install MySQL Router, but it was never usable out of the box: there is no mysqlrouter user, no rc script, no configuration directory, and no log, runtime or data directory. The only trace of an integration was etc/logrotate.d/mysqlrouter, whose "create 600 mysqlrouter mysqlrouter" refers to an account that no port creates, so logrotate(8) skipped that entry with an error and exited non-zero. Upstream names that account itself: scripts/CMakeLists.txt sets MYSQLROUTER_USER to "mysqlrouter", the built-in help of mysqlrouter suggests --user=mysqlrouter, and the systemd unit shipped for Linux runs the service under it. Add the user and group, an rc script, and a configuration sample in etc/mysqlrouter. mysqlrouter does not detach itself, so it runs under …
b32bea4a27 Jochen Neumeister databases/mysql*-server: Fix plist issue
Move LICENSE.router and README.router from ${PREFIX} to ${DOCSDIR}, where they belong according to hier(7). PR: 290283 Reported by: se Sponsored by: Netzkommune GmbH

The latest 5 of 8 in the history this site was built from.