{"id":6392,"date":"2013-03-04T09:47:03","date_gmt":"2013-03-04T15:47:03","guid":{"rendered":"http:\/\/blog.cpanel.net\/?p=6392"},"modified":"2013-03-04T09:47:03","modified_gmt":"2013-03-04T15:47:03","slug":"replacing-mysql-with-percona-in-11-36","status":"publish","type":"post","link":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/","title":{"rendered":"How to replace MySQL with Percona in 11.36"},"content":{"rendered":"<div class=\"note\"><a name=\"important\"><\/a><strong>Important: <\/strong>This setup is considered to be unsupported by the cPanel\/WHM team. Please note that once cPanel\/WHM no longer maintains MySQL on your system it is on the Systems Administrator to manage and maintain any updates and maintenance on the database software. \u00a0We recommend only experienced systems administrators perform the above and we are not responsible for any possible data loss.<\/div>\n<p>Below you will find some steps on how to affectively stop cPanel\/WHM from maintaining MySQL and begin utilizing Percona for any and all database activity on your server. You can find the Percona website at <a href=_-2010.html>www.percona.com<\/a>.The guide found below is based around utilizing the new RPM tools we provide in 11.36. <!--more--><br \/>\nYou will find that the steps provided here are similar to that of my last weeks blog <a href=_-2011.html target=\"_blank\" rel=\"noopener\">Replacing MySQL with MariaDB in 11.36<\/a>. <!--more--><br \/>\n<strong>Important Links<\/strong><\/p>\n<p><a href=_-2012.html>Percona versus MySQL Benchmarks<br \/>\n<\/a><a href=_-2013.html target=\"_blank\" rel=\"noopener\">Percona versus MySQL Features<\/a><\/p>\n<p><a href=_-1413.html target=\"_blank\" rel=\"noopener\"><em>Documentation on the RPM system provided by cPanel &amp; WHM<\/em><\/a><\/p>\n<p><strong>Step 1: Backup existing MySQL data<\/strong><\/p>\n<p>Make sure to save all existing data just in case there are any issues.<\/p>\n<pre>cp -Rf \/var\/lib\/mysql \/var\/lib\/mysql-old\nmv \/etc\/my.cnf \/etc\/my.cnf-old<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 2: Disable the targets so cPanel no longer handles MySQL updates<\/strong><\/p>\n<p><strong><\/strong>The following will mark the versions of MySQL we distribute as uninstalled so they are no longer maintained by cPanel\/WHM<\/p>\n<pre>\/scripts\/update_local_rpm_versions --edit target_settings.MySQL50 uninstalled\n\/scripts\/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled\n\/scripts\/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 3: Remove existing MySQL RPM\u2019s so theres a clean slate for MariaDB<\/strong><\/p>\n<div class=\"note\"><a name=\"important\"><\/a><strong>Important:<\/strong> The below command will uninstall the MySQL RPM\u2019s! <strong><\/strong><\/div>\n<pre>\/scripts\/check_cpanel_rpms --fix --targets=MySQL50,MySQL51,MySQL55<\/pre>\n<pre>[20130218.235953]    \n[20130218.235953]   The following RPMs are unneeded on your system and should be uninstalled:\n[20130218.235953]   MySQL51-devel.5.1.68-1.cp1136\n[20130218.235953]   MySQL51-test.5.1.68-1.cp1136\n[20130218.235953]   MySQL51-shared.5.1.68-1.cp1136\n[20130218.235953]   MySQL51-client.5.1.68-1.cp1136\n[20130218.235953]   MySQL51-server.5.1.68-1.cp1136\n[20130218.235953]   Removing 0 broken rpms: \n[20130218.235953]   rpm: no packages given for erase\n[20130218.235953]   No new RPMS needed for install\n[20130218.235953]   Uninstalling unneeded rpms: MySQL51-devel MySQL51-test MySQL51-shared MySQL51-client MySQL51-server\n[20130219.000004]   Shutting down MySQL........ SUCCESS!<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 4: Create a yum repository for MariaDB<\/strong><\/p>\n<pre>vi \/etc\/yum.repos.d\/percona.repo<\/pre>\n<p>place the following inside of it (it will recognize your OS\/arch);<\/p>\n<pre>[percona]\nname = CentOS $releasever - Percona\nbaseurl=http:\/\/repo.percona.com\/centos\/$releasever\/os\/$basearch\/\nenabled = 1\ngpgkey = http:\/\/www.percona.com\/redir\/downloads\/percona-release\/RPM-GPG-KEY-percona\ngpgcheck = 1<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 5: Remove php<\/strong> <strong>from the \/etc\/yum.conf file then run the following commands <\/strong><\/p>\n<pre>yum install Percona-Server-client-55 Percona-Server-server-55 Percona-Server-devel-55\n\/etc\/init.d\/mysql start\nmysql_upgrade\n\/etc\/init.d\/mysql restart<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 5: Add\u00a0<em>php<\/em>\u00a0back to the \/etc\/yum.conf file to ensure future php updates don&#8217;t get clobbered<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Final Step: Rebuild easyapache\/php to ensure modules are intact\/working<\/strong><\/p>\n<pre>\/scripts\/easyapache --build<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Important: This setup is considered to be unsupported by the cPanel\/WHM team. Please note that once cPanel\/WHM no longer maintains MySQL on your system it is on the Systems Administrator to manage and maintain any updates and maintenance on the database software. \u00a0We recommend only experienced systems administrators perform the above and we are not [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[61],"tags":[565,569,573,577,581,585],"class_list":["post-6392","post","type-post","status-publish","format-standard","hentry","category-tips-and-tricks","tag-migrate-from-mysql-to-percona","tag-mysql-percona","tag-mysql-to-percona","tag-percona","tag-percona-mysql","tag-perconadb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to replace MySQL with Percona in 11.36 | cPanel<\/title>\n
<!-- Mirrored from cpanel.net/wp-json/wp/v2/posts/6392/ by HTTrack Website Copier/3.x [XR&CO'2014], Fri, 06 Sep 2024 09:52:03 GMT -->
<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=_-2014.html \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to replace MySQL with Percona in 11.36 | cPanel\" \/>\n<meta property=\"og:description\" content=\"Important: This setup is considered to be unsupported by the cPanel\/WHM team. Please note that once cPanel\/WHM no longer maintains MySQL on your system it is on the Systems Administrator to manage and maintain any updates and maintenance on the database software. \u00a0We recommend only experienced systems administrators perform the above and we are not [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/\" \/>\n<meta property=\"og:site_name\" content=\"cPanel\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/cpanel\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-04T15:47:03+00:00\" \/>\n<meta name=\"author\" content=\"cPanel Community\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cPanel\" \/>\n<meta name=\"twitter:site\" content=\"@cPanel\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"cPanel Community\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/\",\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/\",\"name\":\"How to replace MySQL with Percona in 11.36 | cPanel\",\"isPartOf\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\"},\"datePublished\":\"2013-03-04T15:47:03+00:00\",\"dateModified\":\"2013-03-04T15:47:03+00:00\",\"author\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\"},\"breadcrumb\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/devel.www.cpanel.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to replace MySQL with Percona in 11.36\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\",\"url\":\"https:\/\/devel.www.cpanel.net\/\",\"name\":\"cPanel\",\"description\":\"Hosting Platform of Choices\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devel.www.cpanel.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\",\"name\":\"cPanel Community\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"caption\":\"cPanel Community\"},\"description\":\"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.\",\"sameAs\":[\"https:\/\/cpanel.net\"],\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to replace MySQL with Percona in 11.36 | cPanel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/","og_locale":"en_US","og_type":"article","og_title":"How to replace MySQL with Percona in 11.36 | cPanel","og_description":"Important: This setup is considered to be unsupported by the cPanel\/WHM team. Please note that once cPanel\/WHM no longer maintains MySQL on your system it is on the Systems Administrator to manage and maintain any updates and maintenance on the database software. \u00a0We recommend only experienced systems administrators perform the above and we are not [&hellip;]","og_url":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/","og_site_name":"cPanel","article_publisher":"https:\/\/www.facebook.com\/cpanel\/","article_published_time":"2013-03-04T15:47:03+00:00","author":"cPanel Community","twitter_card":"summary_large_image","twitter_creator":"@cPanel","twitter_site":"@cPanel","twitter_misc":{"Written by":"cPanel Community","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/","url":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/","name":"How to replace MySQL with Percona in 11.36 | cPanel","isPartOf":{"@id":"https:\/\/devel.www.cpanel.net\/#website"},"datePublished":"2013-03-04T15:47:03+00:00","dateModified":"2013-03-04T15:47:03+00:00","author":{"@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8"},"breadcrumb":{"@id":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/replacing-mysql-with-percona-in-11-36\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devel.www.cpanel.net\/"},{"@type":"ListItem","position":2,"name":"How to replace MySQL with Percona in 11.36"}]},{"@type":"WebSite","@id":"https:\/\/devel.www.cpanel.net\/#website","url":"https:\/\/devel.www.cpanel.net\/","name":"cPanel","description":"Hosting Platform of Choices","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devel.www.cpanel.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8","name":"cPanel Community","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","caption":"cPanel Community"},"description":"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.","sameAs":["https:\/\/cpanel.net"],"url":"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/6392"}],"collection":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/comments?post=6392"}],"version-history":[{"count":0,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/6392\/revisions"}],"wp:attachment":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/media?parent=6392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/categories?post=6392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/tags?post=6392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}