percona XTRADB Cluster 5.6在ubuntu安装_MySQL
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>
Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

It is a very common problem these days that Ubuntu does not allow its users to open the terminal. If you receive a similar issue and don’t know what to do next, learn about five fixes on how to resolve this “Ubuntu cannot open terminal” issue on your Linux device. Without further ado, let’s dive into what causes it and the solutions available to it. Why can't Ubuntu open the terminal on it? This mainly happens when you install some defective software or modify the terminal configuration. In addition to this, new applications or games that interact with locales and corrupt them can cause similar problems. Some users reported a fix for this issue when searching for Terminal in Ubuntu's activity menu. This shows that

In the Ubuntu system, we often encounter folders with a lock shape on the top. This file often cannot be edited or moved. This is because there is no permission to edit the file, so we need to modify its permissions. How to remove the lock in the lower right corner? Let’s take a look at the detailed tutorial below. 1. Right-click on the locked folder--Properties. 2. Select the permissions option in the window. 3. Select everything inside to create and delete files. 4. Then select Change the permissions of the included files at the bottom, which are also set to create and delete files. Finally, remember to click Change in the upper right corner. 5. If the above lock is still not removed, or the options are grayed out and cannot be operated, you can right-click inside - open the terminal. 6. make

In Ubuntu systems, the root user is usually disabled. To activate the root user, you can use the passwd command to set a password and then use the su- command to log in as root. The root user is a user with unrestricted system administrative rights. He has permissions to access and modify files, user management, software installation and removal, and system configuration changes. There are obvious differences between the root user and ordinary users. The root user has the highest authority and broader control rights in the system. The root user can execute important system commands and edit system files, which ordinary users cannot do. In this guide, I'll explore the Ubuntu root user, how to log in as root, and how it differs from a normal user. Notice

Ubuntu24.04LTS, codenamed "NobleNumbat" will be released soon! If you are using a non-LTS version such as Ubuntu 23.10, sooner or later you will need to consider upgrading. For those using Ubuntu20.04LTS or Ubuntu22.04LTS, it is worth thinking about whether to upgrade. Canonical has announced that Ubuntu 24.04LTS will provide update support for up to 12 years, broken down as follows: As an LTS version, it will have 5 years of regular maintenance and security updates. If you subscribe to Ubuntu Pro, you can enjoy an additional 5 years of support. Currently, this additional support period has been extended to 7 years, which means you will get up to 12

There are many software icons listed in the Ubuntu system start menu. There are many uncommon icons. If you want to delete them, how should you delete them? Let’s take a look at the detailed tutorial below. 1. First enter the ubuntu desktop and click on the start menu under the left panel. 2. You can find a text editor icon inside, we need to delete it. 3. Now we return to the desktop and right-click the mouse to open the terminal. 4. Use the command to open the application list directory. sudonautilus/usr/share/applicationssudonautilus~/.local/share/applications5. Find the corresponding text editor icon inside. 6. Then go straight

OBS is open source software developed by volunteer contributors around the world in their free time. A video live recording software, mainly used for video recording and live streaming. Please note that when installing Ubuntu/Mint, OBSStudio cannot fully work on ChromeOS, and functions such as screen and window capture cannot be used. It is recommended to use xserver-xorg1.18.4 or newer version to avoid potential performance issues with certain features in OBS, such as full-screen projectors. FFmpeg is required. If you don't have FFmpeg installed (if you're not sure, you probably don't), you can get it with: sudoaptinstallffmpeg I already have it installed here

snap is a software packaging and deployment system developed by Canonical for operating systems that use the Linux kernel and systemdinit system. These packages, known as snaps, and the tool that uses them, snapd, are available across a range of Linux distributions and allow upstream software developers to publish their applications directly to users. With snap, users can easily install Linux applications. By default, snapd will check for updates four times a day and automatically update snap applications to the latest version. While there are many ways to control when and how often updates are installed, users cannot completely turn off automatic updates for security reasons. Although the original intention of snap is good, many people use it to

Angular.js is a freely accessible JavaScript platform for creating dynamic applications. It allows you to express various aspects of your application quickly and clearly by extending the syntax of HTML as a template language. Angular.js provides a range of tools to help you write, update and test your code. Additionally, it provides many features such as routing and form management. This guide will discuss how to install Angular on Ubuntu24. First, you need to install Node.js. Node.js is a JavaScript running environment based on the ChromeV8 engine that allows you to run JavaScript code on the server side. To be in Ub
