MySQL Installation - Revision history

Boiarino: /* RHEL9 */

2026-05-27T15:00:05Z

RHEL9

← Older revision		Revision as of 11:00, 27 May 2026
Line 41:		Line 41:
	chown mysql:mysql /database/run		chown mysql:mysql /database/run

	Modify settings in ''/etc/my.cnf.d/mysql-server.cnf'' ([mysqld] section) as following:		Modify settings in ''/etc/my.cnf.d/mysql-server.cnf'' ([mysqld] section) as following (example from clondb1 27-May-2026):

	[mysqld]		[mysqld]
			##datadir=/var/lib/mysql
	datadir=/database		datadir=/database
	socket=/var/lib/mysql/mysql.sock		socket=/var/lib/mysql/mysql.sock
	log-error=/database/~~logs~~/mysqld.log		##socket=/database/run/mysql.sock
	##pid-file=/~~database~~/~~run~~/mysqld.pid		##log-error=/var/log/mysql/mysqld.log
	pid-file=/run~~/mysqld~~/mysqld.pid		log-error=/database/log/mysqld.log
			##pid-file=/run/mysqld/mysqld.pid
			pid-file=/database/run/mysqld.pid

			###
			# sergey: following some of Marty's settings
			###

	# Tuning parameters		# Tuning parameters
	~~open_files_limit~~ = 1040400		open-files-limit = 1040400
	max_connections = 1024		max_connections = 1024

Line 57:		Line 64:
	max_connect_errors = 1000		max_connect_errors = 1000

	#		###key_buffer = 256M
	max_allowed_packet = 64M		max_allowed_packet = 64M
			###query_cache_size = 64M
			###query_cache_type = On
			###table_cache = 512
			###sort_buffer = 1M
	myisam_sort_buffer_size = 64M		myisam_sort_buffer_size = 64M
			###thread_cache = 16
	tmp_table_size = 64M		tmp_table_size = 64M
	max_heap_table_size = 64M		max_heap_table_size = 64M
Line 66:		Line 78:
	innodb_data_home_dir = data		innodb_data_home_dir = data
	innodb_data_file_path = ibdata1:10M:autoextend		innodb_data_file_path = ibdata1:10M:autoextend
			###innodb_log_group_home_dir = data
	innodb_undo_directory = data		innodb_undo_directory = data

	# You can set .._buffer_pool_size up to 50 - 80 %		# You can set .._buffer_pool_size up to 50 - 80 %
	# of RAM but beware of setting memory usage too high		# of RAM but beware of setting memory usage too high
	innodb_buffer_pool_size = 256M		#innodb_buffer_pool_size = 256M
			innodb_buffer_pool_size = 4G
			###innodb_additional_mem_pool_size = 20M

	# Set .._log_file_size to 25 % of buffer pool size		# Set .._log_file_size to 25 % of buffer pool size
Line 77:		Line 92:
	innodb_flush_log_at_trx_commit = 1		innodb_flush_log_at_trx_commit = 1
	innodb_lock_wait_timeout = 50		innodb_lock_wait_timeout = 50
			###innodb_use_sys_malloc = On

	# Configure as a replication master for replication to externally visible slave, but also		# Configure as a replication master for replication to externally visible slave, but also
Line 84:		Line 100:
	binlog-format = ROW		binlog-format = ROW
	sync_binlog = 1		sync_binlog = 1
	expire_logs_days = 14		##expire_logs_days = 14
			binlog_expire_logs_seconds = 604800

			#sergey: added 2 following lines on Jason Cooper request 30-apr-2026
			binlog-row-value-options = ""
			binlog_transaction_compression = 0

			#sergey: trying to make mariadb replica happy ...
			character-set-server = utf8mb3
			collation-server = utf8mb3_general_ci
			skip-character-set-client-handshake

	# Configure as a slave if necessary...		# Configure as a slave if necessary...
	#skip_slave_start = 0		skip_slave_start = 0
	#report-host = ~~clondb2~~.jlab.org		#read-only = 0
			#relay-log = mysql-relay-bin
			report-host = clondb1.jlab.org
			###replicate-do-db = clas12

	# Diagnostic Logging configuration		# Diagnostic Logging configuration
Line 96:		Line 125:
	slow_query_log = 1		slow_query_log = 1
	slow_query_log_file = /database/log/mysqld-slow-queries.log		slow_query_log_file = /database/log/mysqld-slow-queries.log

			#sergey: ???
			#[isamchk]
			#key_buffer = 128M
			#sort_buffer = 128M
			#read_buffer = 2M
			#write_buffer = 2M

			#sergey: ???
			#[myisamchk]
			#key_buffer = 128M
			#sort_buffer = 128M
			#read_buffer = 2M
			#write_buffer = 2M



	'''NOTE:''' during reboot, directory ''/run/mysqld'' was not created by ''systemd-tmpfiles-setup.service'', although corresponding file ''/usr/lib/tmpfiles.d/mysqld.conf'' contains line ''d /run/mysqld 0755 mysql mysql -'', error message from tmpfiles service is following:		'''NOTE:''' during reboot, directory ''/run/mysqld'' was not created by ''systemd-tmpfiles-setup.service'', although corresponding file ''/usr/lib/tmpfiles.d/mysqld.conf'' contains line ''d /run/mysqld 0755 mysql mysql -'', error message from tmpfiles service is following:

Boiarino: /* RHEL9 */

2026-05-27T14:52:23Z

RHEL9

← Older revision		Revision as of 10:52, 27 May 2026
Line 16:		Line 16:


	Installation on clondb2 (or any new server).		'''Installation on clondb2 (or any new server).'''

	Build server using options H and B; on formatting stage, create directory ''/database''.		Build server using options H and B; on formatting stage, create directory ''/database''.

Boiarino: /* RHEL9 */

2026-05-27T14:52:04Z

RHEL9

← Older revision		Revision as of 10:52, 27 May 2026
Line 11:		Line 11:
	dnf module enable mariadb:10.11		dnf module enable mariadb:10.11

			To go back to default, run

			dnf module disable mariadb:10.11

Boiarino: /* RHEL9 */

2026-05-27T14:49:50Z

RHEL9

← Older revision		Revision as of 10:49, 27 May 2026
Line 2:		Line 2:
	== RHEL9 ==		== RHEL9 ==

	'''NOTE:''' RHEL9's yum offers mariadb10.5 by default. To see newer alternatives available, run		'''NOTE:''' RHEL9's yum offers mariadb10.5 and mysql8.0 by default. To see newer alternatives available, run

	dnf module list mariadb		dnf module list mariadb
			dnf module list mysql

	If you want to ~~make~~ for example version 10.11 ~~default~~, run		If you want to use for example mariadb version 10.11 instead of 10.5, run

	dnf module enable mariadb:10.11		dnf module enable mariadb:10.11

Boiarino: /* RHEL9 */

2026-05-27T14:32:00Z

RHEL9

← Older revision		Revision as of 10:32, 27 May 2026
Line 2:		Line 2:
	== RHEL9 ==		== RHEL9 ==

	'''NOTE:''' RHEL9's yum offers mariadb10.5 by default; to ~~get newer~~ version, do		'''NOTE:''' RHEL9's yum offers mariadb10.5 by default. To see newer alternatives available, run

			dnf module list mariadb

			If you want to make for example version 10.11 default, run

	dnf module enable mariadb:10.11		dnf module enable mariadb:10.11



	Installation on clondb2 (or any new server).		Installation on clondb2 (or any new server).

Boiarino: /* RHEL9 */

2026-05-27T13:59:14Z

RHEL9

← Older revision		Revision as of 09:59, 27 May 2026
Line 1:		Line 1:

	== RHEL9 ==		== RHEL9 ==

			'''NOTE:''' RHEL9's yum offers mariadb10.5 by default; to get newer version, do

			dnf module enable mariadb:10.11

	Installation on clondb2 (or any new server).		Installation on clondb2 (or any new server).

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-25T19:22:53Z

Installation of the older MariaDB on RHEL9 from source

@@ Line 192: / Line 192: @@
   scripts/mysql_install_db --user=mysql --basedir=/root/mysql --datadir=/database
-It will print following instructions:
+Start the MariaDB server manually to make sure it is running:
   ./bin/mysqld_safe
-and then send it to background.
+Import everything from the old clondb3's sql file:
   ./bin/mysql -u root
   MariaDB [mysql]> SET GLOBAL log_bin_trust_function_creators = 1;
@@ Line 245: / Line 203: @@
   MariaDB [mysql]> SOURCE /root/clondb3_full_backup.sql;
-In case of ''root'' access problems, run it with following flags:
+'''NOTE:''' in case of ''root'' access problems, run it with following flags:
   ./bin/mysqld_safe --skip-grant-tables --skip-networking
 To run it as systemd service, create file ''/usr/lib/systemd/system/mariadb.service'' with following content:
@@ Line 266: / Line 226: @@
   [Install]
   WantedBy=multi-user.target
 == RHEL7 ==

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-25T19:14:13Z

Installation of the older MariaDB on RHEL9 from source

@@ Line 163: / Line 163: @@
   make
   make install
 Make sure 'mysql:27' user and 'mysql:27' group exists.

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-25T19:07:28Z

Installation of the older MariaDB on RHEL9 from source

← Older revision		Revision as of 15:07, 25 January 2026
Line 160:		Line 160:
	mkdir build		mkdir build
	cd build		cd build
	~~###cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/root/mysql/data -DSYSCONFDIR=/root/mysql/etc -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE~~
	cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/database -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE		cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/database -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE
	make		make

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-24T15:48:17Z

Installation of the older MariaDB on RHEL9 from source

← Older revision		Revision as of 11:48, 24 January 2026
Line 229:		Line 229:

	./bin/mysqld_safe --skip-grant-tables --skip-networking		./bin/mysqld_safe --skip-grant-tables --skip-networking

			To run it as systemd service, create file ''/usr/lib/systemd/system/mariadb.service'' with following content:

			[Unit]
			Description=Mariadb 5.5
			After=network.target

			[Service]
			Type=forking
			PrivateTmp=true
			User=mysql
			Group=mysql
			ExecStart=/root/mysql/support-files/mysql.server start
			ExecStop=/root/mysql/support-files/mysql.server stop
			Restart=on-abort

			[Install]
			WantedBy=multi-user.target

	== RHEL7 ==		== RHEL7 ==