IPv6 Database: Percona Server

From OnnoWiki
Revision as of 06:58, 4 February 2019 by Onnowpurbo (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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


Pranala Menarik