LoginSignup
9

More than 5 years have passed since last update.

CentOS 6.xでMySQL環境(CentOS -> Community)の入れ替え手順のメモ

Last updated at Posted at 2014-02-26

MySQL Community Release のYum Repositoryを使う(thanks to @ngyuki)

既存のMySQLをアンインストールしなくても大丈夫。

$ sudo yum localinstall http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
$ sudo yum install mysql-community-client mysql-community-devel mysql-community-server

Chef recipeバージョン

default.rb
default['mysql']['file_name']  = "mysql-community-release-el6-5.noarch.rpm"
default['mysql']['remote_uri'] = "http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm"

default['mysql']['packages'] = %w[
  mysql-community-client
  mysql-community-devel
  mysql-community-server
]
mysql.rb
remote_file "/tmp/#{node['mysql']['file_name']}" do
  source "#{node['mysql']['remote_uri']}"
end

package "mysql-community-release" do
  action :install
  provider Chef::Provider::Package::Rpm
  source "/tmp/#{node['mysql']['file_name']}"
end

node['mysql']['packages'].each do |package|
  package package do
    action :install
  end
end

service "mysqld" do
  supports :status => true, :restart => true, :reload => true
  action [ :enable, :start ]
end

以前使っていた手順


# 標準のMySQL関連のRPMを削除
sudo rpm -e mysql-server mysql mysql-devel 
# mysql-libs と libmysqlclient に依存しているRPMを全部削除
sudo rpm -e mysql-libs perl-DBD-MySQL postfix php-mysql cronie cronie-anacron crontabs
# Community server のRPMをインストール
sudo rpm -ivh MySQL-*.rpm
# mysql-libs以外のRPMは念のため元に戻しておく(厳密には別バージョンになってしまうがこの場合はあまり気にしなかった)
sudo yum install perl-DBD-MySQL postfix php-mysql cronie cronie-anacron crontabs

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
9