{"id":2175,"date":"2016-07-06T12:24:34","date_gmt":"2016-07-06T16:24:34","guid":{"rendered":"https:\/\/www.globo.tech\/learning-center\/?p=2175"},"modified":"2017-12-12T16:04:22","modified_gmt":"2017-12-12T21:04:22","slug":"install-mariadb-ubuntu-16","status":"publish","type":"post","link":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/","title":{"rendered":"How to Install MariaDB on Ubuntu 16"},"content":{"rendered":"

How to Install MariaDB on Ubuntu 16<\/h1>\n

MariaDB is a backwards-compatible MySQL community fork with many enhancements. For starters, it includes a variety of additional storage engines, including some with NoSQL and graph capabilities. It also features various performance enhancements, along with high availability features that typically make it the superior choice for integrating with MySQL applications. Since it is MySQL-compatible, it can capitalize on the large ecosystem of MySQL extensions and apps, making it a drop-in replacement for MySQL in many circumstances. If you’re in a situation where MySQL is your performance bottleneck, updating to MariaDB may be the perfect solution. Not only might one of its many storage engines be a better fit for your workload, but you may be able to add in additional database instances to horizontally scale performance.<\/p>\n

Getting Started<\/h2>\n

To complete this guide, you will need the following:
\n\u2022 1 Node (Cloud Server<\/a> or Dedicated Server<\/a>) running a clean installation of Ubuntu 16.<\/p>\n

When this installation is complete, you can continue on and install apps or services that depend on MySQL, or can build out your installation by creating additional servers to cluster together.<\/p>\n

Tutorial<\/h2>\n

Begin by updating your Ubuntu installation. We’ll upgrade the list of packages, and will also apply any current security patches and bugfixes. This step should be done regularly to keep your server secure and performant. Neglecting to do so may result in security breaches or other system issues.<\/p>\n

apt-get update && apt-get upgrade -y<\/code><\/p>\n

We’ll now install the MariaDB server package.<\/p>\n

apt-get install mariadb-server -y<\/code><\/p>\n

With MariaDB installed, we must now turn to security. The next step will perform some basic hardening on the newly-installed database server.<\/p>\n

mysql_secure_installation<\/code><\/p>\n

Let’s see if the database server itself is working.<\/p>\n

mysql -u root -p<\/code><\/p>\n

Welcome to the MariaDB monitor. Commands end with ; or \\g.
\nYour MariaDB connection id is 50
\nServer version: 10.0.25-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
\nCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.
\nMariaDB [(none)]><\/code><\/p>\n

Conclusion<\/h2>\n

You now have a single-node, secure instance. It is ready to integrate with any MySQL-compatible apps, or to be clustered with other instances in a highly-available setup. If this guide was helpful to you, kindly share it with others who may also be interested. <\/p>\n","protected":false},"excerpt":{"rendered":"

How to Install MariaDB on Ubuntu 16 MariaDB is a backwards-compatible MySQL community fork with many enhancements. For starters, it includes a variety of additional storage engines, including some with NoSQL and graph capabilities. It also features various performance enhancements, along with high availability features that typically make it the superior choice for integrating with<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61],"tags":[],"class_list":["post-2175","post","type-post","status-publish","format-standard","hentry","category-database","operating_system-ubuntu-16-04"],"yoast_head":"\nHow to Install MariaDB on Ubuntu 16 - Globo.Tech<\/title>\n<meta name=\"description\" content=\"This tutorial will show you how to Install MariaDB on your Ubuntu 16 server. Read now & See if MariaDB is a better fit for your workload!\" \/>\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.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install MariaDB on Ubuntu 16 - Globo.Tech\" \/>\n<meta property=\"og:description\" content=\"This tutorial will show you how to Install MariaDB on your Ubuntu 16 server. Read now & See if MariaDB is a better fit for your workload!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/\" \/>\n<meta property=\"og:site_name\" content=\"Globo.Tech\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-06T16:24:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-12-12T21:04:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2016\/09\/GloboTech-Logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"963\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"GloboTech Communications\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"GloboTech Communications\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-16\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-16\\\/\"},\"author\":{\"name\":\"GloboTech Communications\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#\\\/schema\\\/person\\\/e17784b37f4a4f49b7bc611847912e87\"},\"headline\":\"How to Install MariaDB on Ubuntu 16\",\"datePublished\":\"2016-07-06T16:24:34+00:00\",\"dateModified\":\"2017-12-12T21:04:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-16\\\/\"},\"wordCount\":328,\"commentCount\":0,\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-16\\\/\",\"url\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-16\\\/\",\"name\":\"How to Install MariaDB on Ubuntu 16 - Globo.Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#website\"},\"datePublished\":\"2016-07-06T16:24:34+00:00\",\"dateModified\":\"2017-12-12T21:04:22+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#\\\/schema\\\/person\\\/e17784b37f4a4f49b7bc611847912e87\"},\"description\":\"This tutorial will show you how to Install MariaDB on your Ubuntu 16 server. Read now & See if MariaDB is a better fit for your workload!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-16\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-16\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-16\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install MariaDB on Ubuntu 16\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#website\",\"url\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/\",\"name\":\"Globo.Tech\",\"description\":\"Welcome to the Official Globo.Tech Learning Center\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#\\\/schema\\\/person\\\/e17784b37f4a4f49b7bc611847912e87\",\"name\":\"GloboTech Communications\",\"sameAs\":[\"http:\\\/\\\/www.gtcomm.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install MariaDB on Ubuntu 16 - Globo.Tech","description":"This tutorial will show you how to Install MariaDB on your Ubuntu 16 server. Read now & See if MariaDB is a better fit for your workload!","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.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/","og_locale":"en_US","og_type":"article","og_title":"How to Install MariaDB on Ubuntu 16 - Globo.Tech","og_description":"This tutorial will show you how to Install MariaDB on your Ubuntu 16 server. Read now & See if MariaDB is a better fit for your workload!","og_url":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/","og_site_name":"Globo.Tech","article_published_time":"2016-07-06T16:24:34+00:00","article_modified_time":"2017-12-12T21:04:22+00:00","og_image":[{"width":1920,"height":963,"url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2016\/09\/GloboTech-Logo.png","type":"image\/png"}],"author":"GloboTech Communications","twitter_misc":{"Written by":"GloboTech Communications","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/#article","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/"},"author":{"name":"GloboTech Communications","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"headline":"How to Install MariaDB on Ubuntu 16","datePublished":"2016-07-06T16:24:34+00:00","dateModified":"2017-12-12T21:04:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/"},"wordCount":328,"commentCount":0,"articleSection":["Database"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/","url":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/","name":"How to Install MariaDB on Ubuntu 16 - Globo.Tech","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/#website"},"datePublished":"2016-07-06T16:24:34+00:00","dateModified":"2017-12-12T21:04:22+00:00","author":{"@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"description":"This tutorial will show you how to Install MariaDB on your Ubuntu 16 server. Read now & See if MariaDB is a better fit for your workload!","breadcrumb":{"@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-16\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.globo.tech\/learning-center\/"},{"@type":"ListItem","position":2,"name":"How to Install MariaDB on Ubuntu 16"}]},{"@type":"WebSite","@id":"https:\/\/www.globo.tech\/learning-center\/#website","url":"https:\/\/www.globo.tech\/learning-center\/","name":"Globo.Tech","description":"Welcome to the Official Globo.Tech Learning Center","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87","name":"GloboTech Communications","sameAs":["http:\/\/www.gtcomm.net"]}]}},"_links":{"self":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/2175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/comments?post=2175"}],"version-history":[{"count":4,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/2175\/revisions"}],"predecessor-version":[{"id":4013,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/2175\/revisions\/4013"}],"wp:attachment":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media?parent=2175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/categories?post=2175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/tags?post=2175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}