Difference between revisions of "IPv6 Database: Percona Server"

From OnnoWiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 24: Line 24:
 
  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==
 
==Referensi==

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


Pranala Menarik