{"id":2486,"date":"2013-02-27T07:04:44","date_gmt":"2013-02-27T07:04:44","guid":{"rendered":"http:\/\/178.62.14.192\/?p=2486"},"modified":"2013-02-27T07:04:44","modified_gmt":"2013-02-27T07:04:44","slug":"percona-sql-server-on-the-raspberrypi","status":"publish","type":"post","link":"https:\/\/www.recantha.co.uk\/blog\/?p=2486","title":{"rendered":"Percona SQL Server on the #RaspberryPi"},"content":{"rendered":"<p>Arch Linux users have the opportunity to install a MySQL drop-in replacement called Percona on their Raspberry Pi. Alledgedly, Percona is faster than MySQL<\/p>\n<p><a href=\"http:\/\/www.mysqlperformanceblog.com\/2013\/02\/25\/percona-server-on-the-raspberry-pi-your-own-database-server-for-under-80\/\">Percona Server on the Raspberry Pi: Instructions<\/a><\/p>\n<p>I&#8217;m not terribly sure why you&#8217;d want to, but I daresay this comes as welcome news to some people!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Arch Linux users have the opportunity to install a MySQL drop-in replacement called Percona on their Raspberry Pi. Alledgedly, Percona is faster than MySQL Percona Server on the Raspberry Pi: Instructions I&#8217;m not terribly sure why you&#8217;d want to, but&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"https:\/\/www.recantha.co.uk\/blog\/?p=2486\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[49,51],"tags":[],"class_list":["post-2486","post","type-post","status-publish","format-standard","hentry","category-software","category-tutorials"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Percona SQL Server on the #RaspberryPi - Raspberry Pi Pod<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.recantha.co.uk\/blog\/?p=2486\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Percona SQL Server on the #RaspberryPi - Raspberry Pi Pod\" \/>\n<meta property=\"og:description\" content=\"Arch Linux users have the opportunity to install a MySQL drop-in replacement called Percona on their Raspberry Pi. Alledgedly, Percona is faster than MySQL Percona Server on the Raspberry Pi: Instructions I&#8217;m not terribly sure why you&#8217;d want to, but&hellip;Read more &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.recantha.co.uk\/blog\/?p=2486\" \/>\n<meta property=\"og:site_name\" content=\"Raspberry Pi Pod\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/recantha\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-27T07:04:44+00:00\" \/>\n<meta name=\"author\" content=\"Michael Horne\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@recantha\" \/>\n<meta name=\"twitter:site\" content=\"@recantha\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Horne\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=2486#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=2486\"},\"author\":{\"name\":\"Michael Horne\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/c27c4ef2ee1c18b130f1fcd5dcdbb263\"},\"headline\":\"Percona SQL Server on the #RaspberryPi\",\"datePublished\":\"2013-02-27T07:04:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=2486\"},\"wordCount\":58,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#organization\"},\"articleSection\":[\"Software\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.recantha.co.uk\/blog\/?p=2486#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=2486\",\"url\":\"https:\/\/www.recantha.co.uk\/blog\/?p=2486\",\"name\":\"Percona SQL Server on the #RaspberryPi - Raspberry Pi Pod\",\"isPartOf\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#website\"},\"datePublished\":\"2013-02-27T07:04:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=2486#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.recantha.co.uk\/blog\/?p=2486\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=2486#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.recantha.co.uk\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Percona SQL Server on the #RaspberryPi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#website\",\"url\":\"https:\/\/www.recantha.co.uk\/blog\/\",\"name\":\"Raspberry Pi Pod\",\"description\":\"Experiences with the Raspberry Pi micro computer and microcontroller\",\"publisher\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.recantha.co.uk\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#organization\",\"name\":\"Raspberry Pi Pod\",\"url\":\"https:\/\/www.recantha.co.uk\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2016\/03\/cropped-PiPod-Logo-v3.png?fit=800%2C337&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2016\/03\/cropped-PiPod-Logo-v3.png?fit=800%2C337&ssl=1\",\"width\":800,\"height\":337,\"caption\":\"Raspberry Pi Pod\"},\"image\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/recantha\/\",\"https:\/\/x.com\/recantha\",\"https:\/\/www.linkedin.com\/in\/recantha\/\",\"https:\/\/www.youtube.com\/channel\/UCK4F9blabxzmk8Inzhs8tpg\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/c27c4ef2ee1c18b130f1fcd5dcdbb263\",\"name\":\"Michael Horne\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/479778b0677caadde0ceb54c4129804ef674914607e3ed0998808148357d10d8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/479778b0677caadde0ceb54c4129804ef674914607e3ed0998808148357d10d8?s=96&d=mm&r=g\",\"caption\":\"Michael Horne\"},\"url\":\"https:\/\/www.recantha.co.uk\/blog\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Percona SQL Server on the #RaspberryPi - Raspberry Pi Pod","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:\/\/www.recantha.co.uk\/blog\/?p=2486","og_locale":"en_US","og_type":"article","og_title":"Percona SQL Server on the #RaspberryPi - Raspberry Pi Pod","og_description":"Arch Linux users have the opportunity to install a MySQL drop-in replacement called Percona on their Raspberry Pi. Alledgedly, Percona is faster than MySQL Percona Server on the Raspberry Pi: Instructions I&#8217;m not terribly sure why you&#8217;d want to, but&hellip;Read more &rarr;","og_url":"https:\/\/www.recantha.co.uk\/blog\/?p=2486","og_site_name":"Raspberry Pi Pod","article_publisher":"https:\/\/www.facebook.com\/recantha\/","article_published_time":"2013-02-27T07:04:44+00:00","author":"Michael Horne","twitter_card":"summary_large_image","twitter_creator":"@recantha","twitter_site":"@recantha","twitter_misc":{"Written by":"Michael Horne"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.recantha.co.uk\/blog\/?p=2486#article","isPartOf":{"@id":"https:\/\/www.recantha.co.uk\/blog\/?p=2486"},"author":{"name":"Michael Horne","@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/c27c4ef2ee1c18b130f1fcd5dcdbb263"},"headline":"Percona SQL Server on the #RaspberryPi","datePublished":"2013-02-27T07:04:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.recantha.co.uk\/blog\/?p=2486"},"wordCount":58,"commentCount":1,"publisher":{"@id":"https:\/\/www.recantha.co.uk\/blog\/#organization"},"articleSection":["Software","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.recantha.co.uk\/blog\/?p=2486#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.recantha.co.uk\/blog\/?p=2486","url":"https:\/\/www.recantha.co.uk\/blog\/?p=2486","name":"Percona SQL Server on the #RaspberryPi - Raspberry Pi Pod","isPartOf":{"@id":"https:\/\/www.recantha.co.uk\/blog\/#website"},"datePublished":"2013-02-27T07:04:44+00:00","breadcrumb":{"@id":"https:\/\/www.recantha.co.uk\/blog\/?p=2486#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.recantha.co.uk\/blog\/?p=2486"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.recantha.co.uk\/blog\/?p=2486#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.recantha.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Percona SQL Server on the #RaspberryPi"}]},{"@type":"WebSite","@id":"https:\/\/www.recantha.co.uk\/blog\/#website","url":"https:\/\/www.recantha.co.uk\/blog\/","name":"Raspberry Pi Pod","description":"Experiences with the Raspberry Pi micro computer and microcontroller","publisher":{"@id":"https:\/\/www.recantha.co.uk\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.recantha.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.recantha.co.uk\/blog\/#organization","name":"Raspberry Pi Pod","url":"https:\/\/www.recantha.co.uk\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2016\/03\/cropped-PiPod-Logo-v3.png?fit=800%2C337&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2016\/03\/cropped-PiPod-Logo-v3.png?fit=800%2C337&ssl=1","width":800,"height":337,"caption":"Raspberry Pi Pod"},"image":{"@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/recantha\/","https:\/\/x.com\/recantha","https:\/\/www.linkedin.com\/in\/recantha\/","https:\/\/www.youtube.com\/channel\/UCK4F9blabxzmk8Inzhs8tpg"]},{"@type":"Person","@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/c27c4ef2ee1c18b130f1fcd5dcdbb263","name":"Michael Horne","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/479778b0677caadde0ceb54c4129804ef674914607e3ed0998808148357d10d8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/479778b0677caadde0ceb54c4129804ef674914607e3ed0998808148357d10d8?s=96&d=mm&r=g","caption":"Michael Horne"},"url":"https:\/\/www.recantha.co.uk\/blog\/?author=1"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2RsaV-E6","jetpack-related-posts":[{"id":6174,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=6174","url_meta":{"origin":2486,"position":0},"title":"WordPress for #RaspberryPi using Nginx and MySQL","author":"Michael Horne","date":"28 September 2013","format":false,"excerpt":"I'm just setting up a new blog for the Cambridge Raspberry Jam. :-) I've managed to install Wordpress on a rev 1 256mb Raspberry Pi using Nginx as the web server and MySQL as the back end. This was accomplished by following the tutorial on CNXSoft:\u00a0Wordpress for Raspberry Pi using\u2026","rel":"","context":"In &quot;Software&quot;","block_context":{"text":"Software","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=49"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16937,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=16937","url_meta":{"origin":2486,"position":1},"title":"Model lighting controller using a Raspberry Pi and loads of relays","author":"Michael Horne","date":"20 June 2017","format":false,"excerpt":"Mathieu Bonte has written a great Instructable in which he creates a model house and then wires up a Raspberry Pi to various lamps to light the model. In the Instructable, he takes you through wiring it all up, via relays so you can transfer it to a 'real' house\u2026","rel":"","context":"In &quot;Home automation&quot;","block_context":{"text":"Home automation","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=25"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2017\/06\/pi-house.jpg?fit=1024%2C687&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2017\/06\/pi-house.jpg?fit=1024%2C687&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2017\/06\/pi-house.jpg?fit=1024%2C687&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2017\/06\/pi-house.jpg?fit=1024%2C687&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":451,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=451","url_meta":{"origin":2486,"position":2},"title":"Adding MySQL to your Raspberry Pi webserver (reblog)","author":"Michael Horne","date":"1 November 2012","format":false,"excerpt":"The Frustrated IT engineer has blogged a simple how-to for getting MySQL up and running on your Pi. Adding Mysql to your Raspberry Pi webserver \u00ab Frustrated IT Engineer.","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1878,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=1878","url_meta":{"origin":2486,"position":3},"title":"MySQL for Beginners on the #RaspberryPi","author":"Michael Horne","date":"5 February 2013","format":false,"excerpt":"If you know nothing about databases, except that you know you want to\u00a0use\u00a0them, this video tutorial is for you. Richard Wenner has posted an excellent, very comprehensive tutorial on MySQL for the Raspberry Pi on YouTube. This 40-minute video covers installation of MySQL and using it on the command line\u2026","rel":"","context":"In &quot;Databases&quot;","block_context":{"text":"Databases","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=14"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":12390,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=12390","url_meta":{"origin":2486,"position":4},"title":"Use WordPress to host your own website on the Raspberry Pi","author":"Michael Horne","date":"13 April 2015","format":false,"excerpt":"Instructables user\u00a0dbrad5683\u00a0has\u00a0written a tutorial that shows you how to install PHP, Apache, MySQL and Wordpress so that you can host your own\u00a0website on the Pi. It's pretty straightforward. I wouldn't personally use Apache or MySQL as they're a bit heavy for the Pi, but I guess on a Pi 2\u2026","rel":"","context":"In &quot;Software&quot;","block_context":{"text":"Software","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=49"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mitchtech.net\/wp-content\/uploads\/2012\/06\/pi-wordpress-300x183.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":13666,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=13666","url_meta":{"origin":2486,"position":5},"title":"Host a WordPress site on your Raspberry Pi","author":"Michael Horne","date":"8 November 2015","format":false,"excerpt":"Here's a nice beginners' tutorial that tells you how to install Wordpress and MySQL to enable you to host a blog website on your Raspberry Pi. Read it here.","rel":"","context":"In &quot;Software&quot;","block_context":{"text":"Software","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=49"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/raspberrypituts.com\/wp-content\/uploads\/2015\/11\/Install-WordPress-on-Your-Raspberry-Pi-WordPress.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/raspberrypituts.com\/wp-content\/uploads\/2015\/11\/Install-WordPress-on-Your-Raspberry-Pi-WordPress.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/raspberrypituts.com\/wp-content\/uploads\/2015\/11\/Install-WordPress-on-Your-Raspberry-Pi-WordPress.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/raspberrypituts.com\/wp-content\/uploads\/2015\/11\/Install-WordPress-on-Your-Raspberry-Pi-WordPress.png?resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2486"}],"version-history":[{"count":0,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2486\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}