Embedded Files
Percona
Assumptions:
Percona Distribution for MySQL using Percona Server for MySQL 8.0
/var/lib/mysql is created as a distinct mount point sized to hold the expected aggregate size of the database files.
SELinux is enabled and enforcing.
You will use standard locations for files (/var/lib/mysql, /var/log/mysqld.log, /var/run/mysqld/mysqld.pid, /var/lib/mysql/mysql.sock, /var/lib/mysql-files). If you change any of these locations you should change the SELinux File Context appropriately.
Ubuntu Server LTS or Oracle Linux 8+ (Debian, RHEL 8+, AlmaLinux and Rocky also assumed to be ok but not tested)
AMD/Intel X64
percona-release
If your target server is isolated from the internet and you are hosting your own yum server see the Alternate Method belowpercona-release
For Oracle Linux and RHEL...
sudo yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm
OEL8
OEL9
MySQL 8.0
sudo percona-release setup pdps8.0
On RHEL8 systems be sure to disable the dnf mysql module when prompted.(Disabling does this command under the covers: sudo dnf module disable mysql, check status with sudo dnf module list)MySQL 8.4
sudo percona-release setup -y ps-84-lts
OEL8
OEL9
Alternate Method
Alternate Method
If your target server is isolated from the internet and you are hosting your own yum server... download the required rpms from Percona. Note that the Oracle MySQL rpm will clash with the Percona Server rpm; you may have to work around this by keeping the files in distinct repositories that can be enabled/disabled as necessary. You should skip the steps above but you will need to do this..
sudo dnf module disable mysql
and you may need to do this...
sudo yum install compat-openssl10
(EL8)To populate your local yum repository you could use something like this...
Note how you can filter to show only files suitable for a specified point release by chanhing the URL appropriately...
rm index.html
wget http://repo.percona.com/pdps-8.0.28/yum/release/8.0/RPMS/x86_64/
for i in `cat index.html | grep rpm| cut -f2 -d'"' | grep -v debuginfo | grep -v debugsource`
do
rm -rf $i
wget http://repo.percona.com/pdps-8.0.28/yum/release/8.0/RPMS/x86_64/$i
done
Install
Install
The installation creates /etc/logrotate.d/mysql, /etc/my.cnf and /etc/my.cnf.d. It creates several files in /usr/bin, a lot of files in /usr/lib (including /usr/lib/systemd/system/mysqld.service), and a lot of files in /usr/lib64/mysql. It creates mysqld and mysqld-debug in /usr/sbin, and several files in /usr/share/doc, /usr/share/man and /usr/share/percona-server. It also creates /var/lib/mysql, /var/lib/mysql-files, /var/lib/mysql-keyring and /var/run/mysqld.
If you want to have /var/lib/mysql as a separate mount point (recommended) then you should do this before running the yum install.
If you want to have /var/lib/mysql as a separate mount point (recommended) then you should do this before running the yum install.
sudo yum install percona-server-server
Earlier versions have a slightly different naming standard. E.g. for 5.7 you would use...sudo yum install Percona-Server-server-57
OEL8
OEL9
Update Configuration File
Update Configuration File
You can revisit this properly later but, if you have already created any files or subdirectories under /var/lib/mysql then, at a minimum, create a subdirectory called /var/lib/mysql/data and set the datadir configuration variable in /etc/my.cnf to point to it. MySQL will not start if the datadir is not empty.
sudo mkdir -p /var/lib/mysql/data
sudo vi /etc/my.cnf
datadir=/var/lib/mysql/data
As an example, at one company I worked for, we had separate mount points for MySQL Backups and Binary Logs that were created under /var/lib/mysql. It worked well to keep MySQL logically together whilst also keeping backups and binlogs physically separate... but it did stop MySQL from initialising the datadir on first startup, which meant MySQL would not successfully start until I had updated datadir.
As another example, a different database server I worked on had antivirus installed (Sentinel1) which created hidden files (.aaa, .bbb etc) in the top level directory of any mount point. As /var/lib/mysql was configured as a separate mount point these files existed at first startup of MySQL and, as stated above, MySQL will not start (or, more accurately, will not initialise the datadir) if the datadir is not empty.
Start MySQL
Start MySQL
Reset Password
Reset Password
Find out the initial password...
sudo grep 'temporary password' /var/log/mysqld.log
Use it to login...
mysql -u root -p
Enter the password when promptedChange the password (be sure to store it somewhere securely)...
ALTER USER 'root'@'localhost' IDENTIFIED BY RANDOM PASSWORD;
Note that 'BY RANDOM PASSWORD' functionality is not available in versions earlier than MySQL 8User Defined Functions
User Defined Functions
Whilst still connected to MySQL as 'root'...
CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so';
CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so';
CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so';
Next Steps
Next Steps
Bibliography
Bibliography
https://docs.percona.com/percona-software-repositories/repository-location.htmlhttps://www.percona.com/services/policies/percona-software-support-lifecycle#supporthttp://www.percona.com/doc/percona-server/8.0/management/udf_percona_toolkit.htmlhttps://www.percona.com/downloads/Percona-Server-8.0/https://docs.percona.com/percona-server/8.0/installation/yum_repo.htmlhttps://docs.percona.com/percona-server/8.0/apt-repo.htmlhttps://docs.percona.com/percona-software-repositories/percona-release.htmlhttps://docs.percona.com/percona-software-repositories/repository-location.htmlhttps://docs.percona.com/percona-software-repositories/mysql.htmlhttps://repo.percona.com/ps-57/yum/release/8/RPMS/x86_64/https://docs.percona.com/percona-server/8.0/release-notes/release-notes_index.htmlhttps://docs.percona.com/percona-server/8.0/feature-comparison.html
Page updated
Google Sites
Report abuse