Percona: Instalasi mengganti MySQL - Revision history

Onnowpurbo: /* Step Four — Configuration */

2015-05-27T08:22:52Z

Step Four — Configuration

Onnowpurbo: /* Step Three — Installing Percona Server */

2015-05-27T07:54:09Z

Step Three — Installing Percona Server

Onnowpurbo: /* Step Three — Installing Percona Server */

2015-05-27T07:45:49Z

Step Three — Installing Percona Server

Onnowpurbo: /* Step Three — Installing Percona Server */

2015-05-27T07:34:57Z

Step Three — Installing Percona Server

Onnowpurbo: /* Step Three — Installing Percona Server */

2015-05-27T07:34:12Z

Step Three — Installing Percona Server

Onnowpurbo: /* Step Three — Installing Percona Server */

2015-05-27T07:30:35Z

Step Three — Installing Percona Server

Onnowpurbo: /* Step Three — Installing Percona Server */

2015-05-27T07:29:04Z

Step Three — Installing Percona Server

Onnowpurbo: /* Step Three — Installing Percona Server */

2015-05-27T07:28:21Z

Step Three — Installing Percona Server

Onnowpurbo: /* Step Three — Installing Percona Server */

2015-05-27T07:23:50Z

Step Three — Installing Percona Server

Onnowpurbo at 07:15, 27 May 2015

2015-05-27T07:15:53Z

Show changes

@@ Line 233: / Line 233: @@
   service mysql restart
 If the server fails to start with this config, try reducing innodb-buffer-pool-size to a smaller value and repeating the above command.
@@ Line 243: / Line 247: @@
   Enter password:
   Welcome to the MySQL monitor.  Commands end with ; or \g.
-  Your MySQL connection id is 45
+  Your MySQL connection id is 47
-  Server version: 5.5.38-35.2 Percona Server (GPL), Release 35.2, Revision 674
+  Server version: 5.6.24-72.2 Percona Server (GPL), Release 72.2, Revision 8d0f85b
-  Copyright (c) 2009-2014 Percona LLC and/or its affiliates
+  Copyright (c) 2009-2015 Percona LLC and/or its affiliates
-  Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
+  Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
   Oracle is a registered trademark of Oracle Corporation and/or its
@@ Line 253: / Line 257: @@
   owners.
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   mysql>
@@ Line 261: / Line 265: @@
   SHOW VARIABLES LIKE "version%";
-  +-------------------------+--------------------------------------------------+
+  +-------------------------+------------------------------------------------------+
-  | Variable_name           | Value                                            |
+  | Variable_name           | Value                                                |
-  +-------------------------+--------------------------------------------------+
+  +-------------------------+------------------------------------------------------+
-  | version                 | 5.5.38-35.2                                      |
+  | version                 | 5.6.24-72.2                                          |
-  | version_comment         | Percona Server (GPL), Release 35.2, Revision 674 |
+  | version_comment         | Percona Server (GPL), Release 72.2, Revision 8d0f85b |
-  | version_compile_machine | x86_64                                           |
+  | version_compile_machine | x86_64                                               |
-  | version_compile_os      | debian-linux-gnu                                 |
+  | version_compile_os      | debian-linux-gnu                                     |
-  +-------------------------+--------------------------------------------------+
+  +-------------------------+------------------------------------------------------+
 rows in set (0.00 sec)
@@ Line 281: / Line 285: @@
   ...
-−
-  *************************** 8. row ***************************
+  *************************** 6. row ***************************
         Engine: InnoDB
        Support: DEFAULT
@@ Line 289: / Line 293: @@
             XA: YES
     Savepoints: YES
+  *************************** 7. row ***************************
   ...
-rows in set (0.00 sec)
+rows in set (0.01 sec)
 The comment field within the response shows that the XtraDB engine has been loaded as the engine for InnoDB based tables. As a final check, it is advised that you ensure all of your databases and tables are being read properly in the new server.

@@ Line 151: / Line 151: @@
 (New Only) When installing on a fresh system, your Percona Server root user will not have a password assigned and hence your databases will not be secure. It is therefore highly recommended that you use mysqlsecureinstallation to set up a new password and other security options. When asked to enter the current root password, just press Enter.
- /usr/bin/mysql_secure_installation
+/usr/bin/mysql_secure_installation
 ==Step Four — Configuration==

@@ Line 118: / Line 118: @@
   apt-get update
   apt-get install percona-server-server
 (Replacement) Tergantung versi MySQL atau MariaDB yang kita gunakan. Untuk mengganti versi 5.5 gunakan percona-server-server-5.5 package dan percona-server-server-5.6 untuk 5.6. MariaDB 10.0 digantikan dengan Percona Server 5.6.
@@ Line 128: / Line 131: @@
   /var/log/mysqld.log.
-(New Only) When installing on a fresh system, you may be asked during the installation process to set a root database user password. It is also recommended in this situation to run mysqlsecureinstallation to ensure no obvious security issues remain:
+(New Only) Jika menginstalasi fresh system, kita akan ditanya untuk men-set root database password. Sebaiknya kita menjalankan mysqlsecureinstallation untuk memastikan tidak ada masalah security yang tertinggal,
   /usr/bin/mysql_secure_installation
-With the package now installed, the final installation step is to start the server:
+Setelah semua package di instalasi, langkah terakhir yang perlu kita lakukan adalah menjalankan server,
   service mysql start

@@ Line 124: / Line 124: @@
   apt-get install percona-server-server-5.6
-Jika perintah ini berhasil diselesaikan tanpa error, Percona server dapat di instalasi dan berjalan dengan baik. Akan tetapi, jika kita memperoleh error saat instalasi, pastikan kita mempunyai memory yag cukup. Informasi lebih lanjut tentang error saat menjalankan Percona dapat dilihat di log file
+Jika perintah ini berhasil diselesaikan tanpa error, Percona server dapat di instalasi dan berjalan dengan baik. Akan tetapi, jika kita memperoleh error saat instalasi, pastikan kita mempunyai memory yang cukup. Informasi lebih lanjut tentang error saat menjalankan Percona dapat dilihat di log file
-If this command completes without errors, Percona Server will be installed and successfully running. However, if you get errors during installation, ensure that you have sufficient free memory, as per the prerequisites section above. More information about any startup errors may be found in Percona Server's log file at /var/log/mysqld.log.
 (New Only) When installing on a fresh system, you may be asked during the installation process to set a root database user password. It is also recommended in this situation to run mysqlsecureinstallation to ensure no obvious security issues remain:

← Older revision		Revision as of 07:34, 27 May 2015
Line 124:		Line 124:
	apt-get install percona-server-server-5.6		apt-get install percona-server-server-5.6

		+	Jika perintah ini berhasil diselesaikan tanpa error, Percona server dapat di instalasi dan berjalan dengan baik. Akan tetapi, jika kita memperoleh error saat instalasi, pastikan kita mempunyai memory yag cukup. Informasi lebih lanjut tentang error saat menjalankan Percona dapat dilihat di log file
	If this command completes without errors, Percona Server will be installed and successfully running. However, if you get errors during installation, ensure that you have sufficient free memory, as per the prerequisites section above. More information about any startup errors may be found in Percona Server's log file at /var/log/mysqld.log.		If this command completes without errors, Percona Server will be installed and successfully running. However, if you get errors during installation, ensure that you have sufficient free memory, as per the prerequisites section above. More information about any startup errors may be found in Percona Server's log file at /var/log/mysqld.log.

← Older revision		Revision as of 07:30, 27 May 2015
Line 129:		Line 129:

	/usr/bin/mysql_secure_installation		/usr/bin/mysql_secure_installation
−
−	~~CentOS (Yum)~~
−
−	~~Only CentOS versions 5 and 6 are currently supported by Percona. At the time of writing, CentOS 7 is not supported.~~
−
−	~~The first step for CentOS systems is the installation of the Percona repository packages to yum.~~
−
−	~~For 64-bit CentOS systems:~~
−
−	~~yum install http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm~~
−
−	~~For 32-bit CentOS systems:~~
−
−	~~yum install http://www.percona.com/downloads/percona-release/percona-release-0.0-1.i386.rpm~~
−
−	~~Once this is complete, we can then install the correct version of the Percona Server package.~~
−
−	~~(New Only) When installing from scratch, it is recommended you use the Percona Server 5.6 package:~~
−
−	~~yum install Percona-Server-client-56 Percona-Server-server-56~~
−
−	(Replacement Only) When replacing a previous installation, use the version number found in the version check section above to choose the correct corresponding package of Percona-Server-server-55 or Percona-Server-server-56. MariaDB 10.0 should be replaced with Percona Server 5.6.
−
−	~~yum install Percona-Server-client-56 Percona-Server-server-56~~
−
−	You will be asked to accept the packages and then accept the package signing key –agree to both of these. After a short while the installation should complete without any errors. If you receive transaction errors during the installation, ensure that you have completely removed any MySQL/MariaDB packages before retrying.

	With the package now installed, the final installation step is to start the server:		With the package now installed, the final installation step is to start the server:

@@ Line 116: / Line 116: @@
 (New) kita dapat menginstalasi,
-  apt-get upated
+  apt-get update
   apt-get install percona-server-server

@@ Line 86: / Line 86: @@
 Edit sources.list
-  nano /etc/apt/sources.list
+  vi /etc/apt/sources.list
 Tambahkan kalimat berikut dibagian bawah file, pastikan DIST kita ganti dengan nama distribusi yang kita gunakan (dalam hal ini trusty)
@@ Line 98: / Line 98: @@
   deb-src http://repo.percona.com/apt trusty main
-Once you have saved the sources file, the Percona packages should next be pinned to ensure that the packages from Percona will always be prioritized over any packages from your distribution's default repositories. To do this, we first create a new preference file for APT:
+ touch /etc/apt/preferences.d/00percona.pref
-  touch /etc/apt/preferences.d/00percona.pref
+Edit
 Now open this file at /etc/apt/preferences.d/00percona.pref with your chosen text editor (Vim, nano, etc.), add the following lines, and save:
@@ Line 109: / Line 114: @@
   Pin-Priority: 1001
-Finally, once the sources are added and pinned, the package list can be updated and we can install the Percona Server package.
+(New) kita dapat menginstalasi,
-  apt-get update
+  apt-get upated
   apt-get install percona-server-server
-(Replacement Only) Refer to the MySQL or MariaDB version you located earlier. For replacing version 5.5 use the percona-server-server-5.5 package and percona-server-server-5.6 for 5.6. MariaDB 10.0 should be replaced with Percona Server 5.6.
+(Replacement) Tergantung versi MySQL atau MariaDB yang kita gunakan. Untuk mengganti versi 5.5 gunakan percona-server-server-5.5 package dan percona-server-server-5.6 untuk 5.6. MariaDB 10.0 digantikan dengan Percona Server 5.6.
   apt-get update

@@ Line 59: / Line 59: @@
 ==Step Three — Installing Percona Server==
-Percona Server is likely not in your Linux distribution's default repositories, as Percona manage their own repos to ensure updates are pushed to users as quickly as possible. Therefore, we will need to manually add the Percona APT or yum repositories before installation. Follow the instructions below for your server's OS.
+Percona memanage repo-nya sendiri. Kemungkinan besar tidak ada di distribusi Ubuntu / Debian anda. kita perlu menambahkan secara manual ke repo kita.
-The Debian and Ubuntu packages released by Percona are signed, meaning APT needs to be informed of the new signing key:
+===Debian and Ubuntu (Apt)===
   apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
-Before we take the next step, make sure you know the distribution you are currently using. For Debian, this will be one of:
+Akan keluar
-    squeeze
+ Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --homedir /tmp/tmp.kcVwtwI8A0 --no-auto-check-trustdb --trust-model always --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
-    wheezy
+ gpg: requesting key CD2EFD2A from hkp server keys.gnupg.net
-Likewise, for Ubuntu the supported distributions are:
+Untuk Ubuntu dan Debian, cek versi-nya menggunakan perintah
-    lucid
+ lsb_release -c
-If you're uncertain which distribution version you are using, you can execute the following command:
+misalnya keluar
-  lsb_release -c
+  Codename:	trusty
-Once you are sure which distribution you are running, we can add the new Percona repositories by appending the following lines to the /etc/apt/sources.list file:
+Edit sources.list
   nano /etc/apt/sources.list
-Add these lines at the bottom of the file, making sure to replace DIST with your distribution name (that is, you would replace DIST with wheezy or trusty, etc.):
+Tambahkan kalimat berikut dibagian bawah file, pastikan DIST kita ganti dengan nama distribusi yang kita gunakan (dalam hal ini trusty)
   deb http://repo.percona.com/apt DIST main
   deb-src http://repo.percona.com/apt DIST main
 Once you have saved the sources file, the Percona packages should next be pinned to ensure that the packages from Percona will always be prioritized over any packages from your distribution's default repositories. To do this, we first create a new preference file for APT: