欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

percona XTRADB Cluster 5.6在ubuntu安装_MySQL

程序员文章站 2022-05-11 08:17:25
...
Ubuntu

installing-perconaXTRADB Cluster 5.6

in-ubuntu-13-10-wheezy

First of all, I would recommend login as root so that you don’t have tosudo every time you hit the command and give the root password.

1. $ su -

$ su -

Now you should be logged in as root. Mine now is

1. root@rajug:~#

root@rajug:~#

Step 1:
First of all lets remove everything that is related to MySQL from the machine.

1. apt-get remove mysql*

2. apt-get purge mysql*

3. apt-get autoremove

apt-get remove mysql*

apt-get purge mysql*

apt-get autoremeve

Step 2: Adding the key
Now lets add the key that is provided by Percona, we have to add this to beallowed to install from Percona server.

1. apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

apt-key adv --keyserverkeys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

Step 3: Adding the repository
Lets add the Percona repository in the sources list in the machine/Ubuntu.

1. vim /etc/apt/sources.list

vim /etc/apt/sources.list

Add the following two lines in the source list:

http://repo.percona.com/apt/dists/

1. deb http://repo.percona.com/apt wheezy main

2. deb-src http://repo.percona.com/apt wheezy main

deb http://repo.percona.com/aptsaucy main

deb-srchttp://repo.percona.com/apt saucy main

Step 4: Apt-Pinning the packages
In some cases you might need to “pin” the selected packages to avoid theupgrades from the distribution repositories. You’ll need to make a new file/etc/apt/preferences.d/00percona.pref and add the following lines in it:

1. vim /etc/apt/preferences.d/00percona.pref

vim/etc/apt/preferences.d/00percona.pref

Add the following line:

1. Package: *

2. Pin: release o=Percona Development Team

3. Pin-Priority: 1001

Package: *

Pin: release o=PerconaDevelopment Team

Pin-Priority: 1001

Step 5: Update

1. $apt-get update

$apt-get update

Step 6: Install Percona Server and Client

1. $ sudo apt-get installpercona-xtradb-cluster-56

$ apt-get installpercona-server-server-5.6 percona-server-client-5.6

Step 7: Install dependencies
If there are any dependencies left, then lets install them

1. $ apt-get install -f

$ apt-get install -f

Step 8: Testing
To make sure if Percona Server is installed in your machine with MySQL simplytry:

1. $ mysql -u root -p

$ mysql -u root -p

And it showed me :

root@rajug:~# mysql -u root -p

1. Enter password:

2. Welcome to the MySQL monitor. Commands end with ; or /g.

3. Your MySQL connection id is 11

4. Server version: 5.6.15-63.0 Percona Server (GPL), Release 63.0

5.

6. Copyright (c) 2009-2013 Percona LLC and/or its affiliates

7. Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

8.

9. Oracle is a registered trademark of Oracle Corporation and/or its

10.affiliates. Other names may be trademarks of their respective

11.owners.

12.

13.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.

14.

mysql>
相关标签: ubuntu