Hi Joe,
Percona-Server is indeed a drop-in replacement for Community MySQL. We have hundreds of thousands of installations world-wide. If it wasn’t easy, if it wasn’t drop-in, we wouldn’t be as popular as we are. I quickly spun up a CentOS7 VM and installed/setup PS5.7 using binary installation (like you) without any changes to the default config (ie: my install used jemalloc without issue) and it worked like a charm.
I see libc versions 2.5, 2.6, and 2.12 in your file list. 2.12 is usually associated with CentOS 6.5. Is that what you are running? If you cannot upgrade to libc2.14, I would suggest disabling jemalloc to get things working.
[drmac@othala modules]$ cd $HOME
[drmac@othala ~]$ mkdir joetest
[drmac@othala ~]$ cd $_
[drmac@othala joetest]$ vagrant init centos/7
...
[drmac@othala joetest]$ vagrant up
...
[drmac@othala joetest]$ vagrant ssh
[vagrant@localhost ~]$
[vagrant@localhost ~]$ sudo -i
[root@localhost ~]# cd /opt/
[root@localhost opt]#
[root@localhost opt]# curl -O https://www.percona.com/downloads/Percona-Server-LATEST/Percona-Server-5.7.23-23/binary/tarball/Percona-Server-5.7.23-23-Linux.x86_64.ssl101.tar.gz
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 416M 100 416M 0 0 2112k 0 0:03:21 0:03:21 --:--:-- 2906k
[root@localhost opt]#
[root@localhost opt]# tar -xzf Percona-Server-5.7.23-23-Linux.x86_64.ssl101.tar.gz
[root@localhost opt]#
[root@localhost opt]# groupadd mysql
[root@localhost opt]# useradd -r -g mysql -s /bin/false mysql
[root@localhost opt]# ln -s /opt/Percona-Server-5.7.23-23-Linux.x86_64.ssl101 mysql
[root@localhost opt]# cd mysql/
[root@localhost mysql]#
[root@localhost mysql]# ls -la
total 140
drwxrwxr-x. 10 root root 4096 Sep 12 18:14 .
drwxr-xr-x. 3 root root 130 Oct 23 21:39 ..
drwxrwxr-x. 2 root root 4096 Sep 12 18:14 bin
-rw-r--r--. 1 root root 17987 Sep 3 18:20 COPYING
-rw-r--r--. 1 root root 34520 Sep 3 18:43 COPYING.AGPLv3
-rw-r--r--. 1 root root 17987 Sep 3 18:43 COPYING.GPLv2
-rw-rw-r--. 1 root root 1703 Sep 12 18:14 COPYING-jemalloc
-rw-r--r--. 1 root root 17987 Sep 3 18:20 COPYING-test
drwxr-xr-x. 2 root root 101 Sep 12 18:14 docs
drwxrwxr-x. 3 root root 4096 Sep 12 18:14 include
drwxrwxr-x. 5 root root 240 Sep 12 18:14 lib
drwxrwxr-x. 4 root root 30 Sep 12 18:14 man
drwxrwxr-x. 10 root root 4096 Sep 12 18:14 mysql-test
-rw-r--r--. 1 root root 2211 Sep 3 18:43 PATENTS
-rw-r--r--. 1 root root 4118 Sep 3 18:43 README.md
-rw-r--r--. 1 root root 2478 Sep 3 18:20 README.MySQL
-rw-r--r--. 1 root root 353 Sep 3 18:20 README-test
drwxrwxr-x. 28 root root 4096 Sep 12 18:14 share
drwxrwxr-x. 2 root root 90 Sep 12 18:14 support-files
[root@localhost mysql]#
[root@localhost mysql]# bin/mysqld --initialize --user=mysql
2018-10-23T21:40:25.529080Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-10-23T21:40:25.529588Z 0 [ERROR] Can't find error-message file '/usr/local/Percona-Server-5.7.23-23-Linux.x86_64.ssl101/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2018-10-23T21:40:25.977462Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-10-23T21:40:26.123375Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-10-23T21:40:26.207939Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 40d4fae8-d70c-11e8-9221-525400c9c704.
2018-10-23T21:40:26.209493Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-10-23T21:40:26.392716Z 0 [Warning] CA certificate ca.pem is self signed.
2018-10-23T21:40:26.426367Z 1 [Note] A temporary password is generated for root@localhost: Sagty-Hkq0ei
[root@localhost mysql]#
[root@localhost mysql]# ls -la /var/lib/mysql/
total 110668
drwxr-x---. 5 mysql mysql 4096 Oct 23 21:40 .
drwxr-xr-x. 29 root root 4096 Oct 23 21:40 ..
-rw-r-----. 1 mysql mysql 56 Oct 23 21:40 auto.cnf
-rw-------. 1 mysql mysql 1680 Oct 23 21:40 ca-key.pem
-rw-r--r--. 1 mysql mysql 1120 Oct 23 21:40 ca.pem
-rw-r--r--. 1 mysql mysql 1120 Oct 23 21:40 client-cert.pem
-rw-------. 1 mysql mysql 1680 Oct 23 21:40 client-key.pem
-rw-r-----. 1 mysql mysql 423 Oct 23 21:40 ib_buffer_pool
-rw-r-----. 1 mysql mysql 12582912 Oct 23 21:40 ibdata1
-rw-r-----. 1 mysql mysql 50331648 Oct 23 21:40 ib_logfile0
-rw-r-----. 1 mysql mysql 50331648 Oct 23 21:40 ib_logfile1
drwxr-x---. 2 mysql mysql 4096 Oct 23 21:40 mysql
drwxr-x---. 2 mysql mysql 8192 Oct 23 21:40 performance_schema
-rw-------. 1 mysql mysql 1676 Oct 23 21:40 private_key.pem
-rw-r--r--. 1 mysql mysql 452 Oct 23 21:40 public_key.pem
-rw-r--r--. 1 mysql mysql 1120 Oct 23 21:40 server-cert.pem
-rw-------. 1 mysql mysql 1676 Oct 23 21:40 server-key.pem
drwxr-x---. 2 mysql mysql 8192 Oct 23 21:40 sys
[root@localhost mysql]#
[root@localhost mysql]# bin/mysql_ssl_rsa_setup
[root@localhost mysql]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
log-error=/var/log/mysql/mysqld.log
pid-file=/var/run/mysql/mysql.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[root@localhost mysql]#
[root@localhost mysql]# mkdir /var/log/mysql
[root@localhost mysql]# mkdir /var/run/mysql
[root@localhost mysql]# chown mysql:mysql /var/log/mysql /var/run/mysql
[root@localhost mysql]#
[root@localhost mysql]# bin/mysqld_safe --user=mysql
mysqld_safe Adding '/opt/Percona-Server-5.7.23-23-Linux.x86_64.ssl101/lib/mysql/libjemalloc.so.1' to LD_PRELOAD for mysqld
Logging to '/var/log/mysql/mysqld.log'.
2018-10-23T21:42:12.428177Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
^Z
[1]+ Stopped bin/mysqld_safe --user=mysql
[root@localhost mysql]# bg
[1]+ bin/mysqld_safe --user=mysql &
[root@localhost mysql]#
[root@localhost mysql]# bin/mysql -uroot -p -S /var/lib/mysql/mysql.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.23-23
Copyright (c) 2009-2018 Percona LLC and/or its affiliates
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> set password = 'Sagty-Hkq0ei11';
Query OK, 0 rows affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql> SHUTDOWN;
Query OK, 0 rows affected (0.00 sec)
mysql> Bye
[root@localhost mysql]# 2018-10-23T21:43:24.898203Z mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
[1]+ Done bin/mysqld_safe --user=mysql
[root@localhost mysql]#
[root@localhost mysql]#
[root@localhost mysql]# cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)
[root@localhost mysql]#
[root@localhost mysql]# uname -a
Linux localhost.localdomain 3.10.0-862.2.3.el7.x86_64 #1 SMP Wed May 9 18:05:47 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost mysql]#
[root@localhost mysql]# ldd --version
ldd (GNU libc) 2.17