IPv6 Database: Percona Server: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) No edit summary |
Onnowpurbo (talk | contribs) No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Percona adalah MySQL server yang non-Oracle, tampaknya mempunyai kemampuan yang lebih baik dari MySQL. | 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== | ==Instalasi== | ||
| Line 7: | Line 22: | ||
sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb | sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb | ||
sudo apt update | 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 | |||
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== | ==Referensi== | ||
* https://www.percona.com/doc/percona-server/5.7/installation/apt_repo.html | * https://www.percona.com/doc/percona-server/5.7/installation/apt_repo.html | ||
==Pranala Menarik== | ==Pranala Menarik== | ||
* [[IPv6]] | * [[IPv6]] | ||
Latest revision as of 23:58, 3 February 2019
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
