IPv6 Database: Percona Server
Jump to navigation
Jump to search
Percona adalah MySQL server yang non-Oracle, tampaknya mempunyai kemampuan yang lebih baik dari MySQL.
source.list
Edit /etc/apt/sources.list pastikan
deb http://archive.ubuntu.com/ubuntu bionic main universe multiverse deb http://archive.ubuntu.com/ubuntu bionic-security main universe multiverse deb http://archive.ubuntu.com/ubuntu bionic-updates main universe multiverse
cek libmecab2
apt-cache search libmecab2
pastikan ada ..
Instalasi
wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb sudo apt update sudo apt install percona-server-server-5.7
Masukan root password percona jika di tanya. Asumsi password root = 123456.
Jika dibutuhkan, install useful UDF (User Defined Function) dari Percona Toolkit
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'" -u root -p123456 mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'" -u root -p123456 mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'" -u root -p123456
Cek IPv6
Masuk ke localhost ::1
mysql -u root -h ::1 -p123456
Akan keluar
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.7.24-27 Percona Server (GPL), Release '27', Revision 'bd42700' 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>
Referensi