Difference between revisions of "IPv6 Database: Percona Server"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| (4 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 8: | Line 23: | ||
sudo apt update | sudo apt update | ||
sudo apt install percona-server-server-5.7 | 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== | ||
| + | |||
| + | * https://www.percona.com/doc/percona-server/5.7/installation/apt_repo.html | ||
| + | |||
| + | |||
| + | ==Pranala Menarik== | ||
| + | |||
| + | * [[IPv6]] | ||
Latest revision as of 06:58, 4 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