How to Install MySQL 5.6 on Ubuntu 13 x64 / Debian Linux

Standard

Tutorial for : Installing MySQL 5.6 on Ubuntu 13 x64 Debian Linux

This post should help you to understand how to Install MySQL 5.6 on Ubuntu 13.10 x64 / Debian Linux. As I always say, its very simple process to install it. First head over to MySQL Downloads page and get the 64 bit Debian package for MySQL. Current version out there for general available release is [Note this may change as and when they release minors, so pick what ever is latest from this site at the time of your  installation and modify the commands according to your filename]: mysql-5.6.15-debian6.0-x86_64.deb. Make sure you select Debian Linux from the select platform drop down. Make a note of the md5sum to verify that its legit file after we download it. In our case its 409a79231afb46473f8280a108c9dfdd which is right below download button as shown in the picture below.

Facebooktwitterredditpinterestlinkedinmail

Running Multiple MySQL 5.6 Instances on one server in CentOS 6/RHEL 6/Fedora

Standard

There are numerous advantages to run multiple database instances on the save physical server. Here are some reasons that I would like to point out :

1. Utilize existing hardware properly

2. Long lead times to provide physical hardware

3. Reduce Licensing Hardware / OS costs

4. Smaller/manageable data center foot print

5. Reduced overhead

To run multiple instances using MySQL we need to have a couple of things separate from the initial install on MySQL like data directory, init script and config file. It is quite that simple and here is how we do it, I will subscript 2 for all the files/directories that I am going to create to indicate this new second instance:

1. Create a new data directory [/var/lib/mysql2] and make mysql user own it.

mkdir /var/lib/mysql2
chown mysql.mysql /var/lib/mysql2/

msql_5_6_multiple_1

Facebooktwitterredditpinterestlinkedinmail

Setup replication with MySQL 5.6 Server on CentOS 6/Redhat EL6/Fedora

Standard

To start off since you are reading this post, I am assuming that you have at-least two MySQL 5.6 servers for establishing replication between those two MySQL 5.6 servers. If you don’t have experience installing MySQL 5.6 on CentOS or Redhat please read my other blog post here on how to install MySQL 5.6 server and get it up and running in no time. No matter how you want to leverage replication in your environment, here are some of the ways you can implement/use replication:

Facebooktwitterredditpinterestlinkedinmail

Passwordless authentication using mysql_config_editor with MySQL 5.6

Standard

This post elaborates how to use passwordless authentication using mysql_config_editor with MySQL 5.6. The mysql_config_editor utility is available for production use as of MySQL 5.6.6 [Technically 5.6.10 since its first cut GA of MySQL 5.6 server]. This utility enables you to store authentication credentials in an encrypted login file named .mylogin.cnf. Running this utility creates a file named .mylogin.cnf file in %APPDATA%\MySQL directory on Windows and the current user’s home directory on non-Windows systems such as Redhat EL6/CentOS/Fedora/Ubuntu. The file is read later by MySQL client programs to obtain authentication credentials for connecting to MySQL Server.mysql_config_editor encrypts .mylogin.cnf unlike its predecessor .my.cnf file so it cannot be read as clear text and supposedly contents after decrypted are only used in memory. If you have access to the system where you have stored these passwords then you can print them, except password is not visible.

Facebooktwitterredditpinterestlinkedinmail

How to Install MySQL 5.6 on CentOS 6.3/RedHat EL6/Fedora

Standard

First head over here and download MySQL 5.6.14 rpm’s under Oracle & Redhat Linux 6 section of rpm’s.

You want to download these rpm’s to your CentOS 6 server [As we will install 64bit version on MySQL 5.6] :

  1. Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package – MySQL Server : MySQL-server-5.6.14-1.el6.x86_64.rpm
  2. Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package – Shared components : MySQL-shared-5.6.14-1.el6.x86_64.rpm
  3. Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package – Client Utilities : MySQL-client-5.6.14-1.el6.x86_64.rpm

To download on command line [Make sure that you have wget utility installed, if not install it :

Facebooktwitterredditpinterestlinkedinmail