If you have MySQL installed on an Ubuntu (12.10) server and are looking to migrate to MariaDB , here are the steps to migrate over to MariaDB 10.
MariaDB is a drop-in replacement for MySQL - you don’t need to export then import your databases - it just works
Remove MySQL
sudo apt-get install software-properties-common sudo apt-get remove mysql-server sudo apt-get remove mysql-server-5.5 sudo apt-get remove mysql-server-core-5.5
Add MariaDB repository
mysql Ver 15.1 Distrib 10.0.3-MariaDB, for debian-linux-gnu (i686) using readline 5.1
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db sudo add-apt-repository 'deb http://mirror.aarnet.edu.au/pub/MariaDB/repo/10.0/ubuntu quantal main' sudo apt-get update sudo apt-get install mariadb-server
Check that its worked
mysql --version
If the migration was a success it’ll says the distribution of mysql is MariaDB - similar to below
mysql Ver 15.1 Distrib 10.0.3-MariaDB, for debian-linux-gnu (i686) using readline 5.1
服务器测试结果,
用MYSQL时CPU使用情况
top | grep mysql
写道
11644 mysql 20 0 16.5g 9.2g 7844 S 8.6 29.2 5207:00 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 66.5 29.2 5207:02 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 9.6 29.2 5207:02 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.0 29.2 5207:02 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.0 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.6 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.7 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 22.3 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.3 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 4.7 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.3 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.0 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.0 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.7 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.3 29.2 5207:05 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 101.5 29.2 5207:08 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 24.6 29.2 5207:09 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 43.3 29.2 5207:10 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 35.0 29.2 5207:11 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 23.0 29.2 5207:12 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 16.3 29.2 5207:12 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 13.6 29.2 5207:12 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.6 29.2 5207:13 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 13.0 29.2 5207:13 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.3 29.2 5207:13 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.7 29.2 5207:14 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.0 29.2 5207:14 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.6 29.2 5207:14 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 14.0 29.2 5207:14 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.3 29.2 5207:15 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.3 29.2 5207:15 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.7 29.2 5207:15 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 12.0 29.2 5207:15 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 4.7 29.2 5207:16 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 3.7 29.2 5207:16 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 13.3 29.2 5207:16 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.3 29.2 5207:16 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 9.6 29.2 5207:17 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 9.3 29.2 5207:17 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 4.6 29.2 5207:17 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.6 29.2 5207:17 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.6 29.2 5207:18 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.3 29.2 5207:18 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 5.0 29.2 5207:18 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 5.7 29.2 5207:18 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 11.3 29.2 5207:19 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.6 29.2 5207:19 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.0 29.2 5207:19 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.6 29.2 5207:19 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.7 29.2 5207:20 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 5.7 29.2 5207:20 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 11.3 29.2 5207:20 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 9.3 29.2 5207:20 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.3 29.2 5207:21 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.0 29.2 5207:21 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 66.5 29.2 5207:02 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 9.6 29.2 5207:02 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.0 29.2 5207:02 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.0 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.6 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.7 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 22.3 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.3 29.2 5207:03 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 4.7 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.3 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.0 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.0 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.7 29.2 5207:04 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.3 29.2 5207:05 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 101.5 29.2 5207:08 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 24.6 29.2 5207:09 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 43.3 29.2 5207:10 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 35.0 29.2 5207:11 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 23.0 29.2 5207:12 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 16.3 29.2 5207:12 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 13.6 29.2 5207:12 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.6 29.2 5207:13 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 13.0 29.2 5207:13 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.3 29.2 5207:13 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.7 29.2 5207:14 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.0 29.2 5207:14 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.6 29.2 5207:14 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 14.0 29.2 5207:14 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.3 29.2 5207:15 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.3 29.2 5207:15 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 6.7 29.2 5207:15 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 12.0 29.2 5207:15 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 4.7 29.2 5207:16 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 3.7 29.2 5207:16 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 13.3 29.2 5207:16 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.3 29.2 5207:16 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 9.6 29.2 5207:17 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 9.3 29.2 5207:17 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 4.6 29.2 5207:17 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.6 29.2 5207:17 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 7.6 29.2 5207:18 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.3 29.2 5207:18 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 5.0 29.2 5207:18 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 5.7 29.2 5207:18 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 11.3 29.2 5207:19 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.6 29.2 5207:19 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.0 29.2 5207:19 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.6 29.2 5207:19 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.7 29.2 5207:20 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 5.7 29.2 5207:20 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 11.3 29.2 5207:20 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 9.3 29.2 5207:20 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 10.3 29.2 5207:21 mysqld
11644 mysql 20 0 16.5g 9.2g 7844 S 8.0 29.2 5207:21 mysqld
使用MariaDB之后
写道
4159 mysql 20 0 13.2g 1.3g 10m S 7.0 4.1 0:26.66 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 6.3 4.1 0:26.85 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.6 4.1 0:27.08 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 6.0 4.1 0:27.26 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 3.3 4.2 0:27.36 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.3 4.2 0:27.58 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 5.3 4.2 0:27.74 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.3 4.2 0:27.96 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.0 4.2 0:28.17 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 4.3 4.2 0:28.30 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.3 4.2 0:28.52 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 4.7 4.2 0:28.66 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 5.3 4.2 0:28.82 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 6.0 4.2 0:29.00 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 4.7 4.2 0:29.14 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 5.3 4.2 0:29.30 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 6.7 4.2 0:29.50 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 8.3 4.2 0:29.75 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 5.0 4.2 0:29.90 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 4.3 4.2 0:30.03 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.3 4.2 0:30.25 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 6.3 4.1 0:26.85 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.6 4.1 0:27.08 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 6.0 4.1 0:27.26 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 3.3 4.2 0:27.36 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.3 4.2 0:27.58 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 5.3 4.2 0:27.74 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.3 4.2 0:27.96 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.0 4.2 0:28.17 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 4.3 4.2 0:28.30 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.3 4.2 0:28.52 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 4.7 4.2 0:28.66 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 5.3 4.2 0:28.82 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 6.0 4.2 0:29.00 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 4.7 4.2 0:29.14 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 5.3 4.2 0:29.30 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 6.7 4.2 0:29.50 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 8.3 4.2 0:29.75 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 5.0 4.2 0:29.90 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 4.3 4.2 0:30.03 mysqld
4159 mysql 20 0 13.2g 1.3g 10m S 7.3 4.2 0:30.25 mysqld
可见用MariaDB的CPU使用率很平稳, 使用率也低了一些
相关推荐
Let the author’s experience in migrating a financial firm to MariaDB inform your own efforts, helping you to develop a road map for both technical and political success within your own organization ...
The PHP required is taught in context within each project so you can quickly learn how PHP integrates with MariaDB and MySQL to create powerful database-driven websites. Each project is fully ...
提供mysql移植到oracle的方案 实践过程描述
The PHP required is taught in context within each project so you can quickly learn how PHP integrates with MariaDB and MySQL to create powerful database-driven websites. Each project is fully ...
Paragon.Migrate.OS.to.SSD.v4.0.x64.HAPPY.NEW.YEAR-DVT
What You Will Learn Build a secure database-driven website using PHP 7, MySQL 8, and MariaDB Create a product catalog Write a message board ... Migrate to Oracle’s MySQL 8 Server platform
With the rapid growth of MySQL in the database market, many corporations, government agencies, educational institutions, and others have begun to migrate away from their expensive and proprietary ...
西门子_How do you migrate a project integrated in STEP 7 from WinCC flexible to WinCC (TIA Portal)pdf,
Upgrade, Migrate & Consolidate to Oracle Database 12c: Strategies, General Preparation Steps, Upgrade & Migration Cases; Fallback Strategies; New Features in Oracle 12c; Performance Management.
Reasons_to_migrate_to_Delphi_XE2_White_Paper_Final.pdf
MySQL的 db-migrate mysql驱动程序
It provides great details on how to migrate mysql to ms sqlserver 2005.
This book summarizes the steps needed to migrate a non-Oracle database to Oracle database.
28119_white_paper_reasons_to_migrate_to_delphi_xe.ZIP.zip
If you've already worked with MySQL before and are looking to migrate your application to MySQL 8, this book will also show you how to do that. The book also contains recipes on efficient MySQL ...
If you’ve already worked with MySQL before and are looking to migrate your application to MySQL 8, this book will also show you how to do that. The book also contains recipes on efficient MySQL ...
This book summarizes the steps of migrating from oracle 9i database RAC to 10g database RAC.
migrate - 在Golang中的数据库迁移处理,支持MySQL,PostgreSQL,Cassandra 和 SQLite