{"id":12704,"date":"2025-12-20T11:57:41","date_gmt":"2025-12-20T06:27:41","guid":{"rendered":"https:\/\/www.youstable.com\/blog\/?p=12704"},"modified":"2025-12-24T16:17:44","modified_gmt":"2025-12-24T10:47:44","slug":"what-is-mariadb-on-linux-server","status":"publish","type":"post","link":"https:\/\/www.youstable.com\/blog\/what-is-mariadb-on-linux-server","title":{"rendered":"What is MariaDB on Linux Server? Step-by-Step Setup and Backup Guide"},"content":{"rendered":"\n<p><strong>MariaDB on Linux server<\/strong> is an open-source relational database used to store and query application data, built as a drop-in replacement for MySQL. On Linux, you install it via your distro\u2019s packages, secure it with mysql_secure_installation, manage it with systemd, and optimize via my.cnf for performance, security, and backups.<\/p>\n\n\n\n<p>Understanding MariaDB on Linux server starts with the basics: what it is, how it differs from MySQL, and how to install, secure, tune, back up, and monitor it in production. <\/p>\n\n\n\n<p>This guide provides a step-by-step, beginner-friendly path with practical commands, real-world tips, and proven configurations I use when deploying databases on Linux for high uptime and performance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"what-is-mariadb-and-why-run-it-on-linux\"><strong>What is MariaDB and Why Run it on Linux?<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>MariaDB is a community-driven fork of MySQL offering enhanced performance, open development, and long-term stability. On Linux, it benefits from robust package repositories, systemd service control, first-class security tooling (SELinux\/AppArmor), and high-performance filesystems, making it an ideal foundation for WordPress, ecommerce, and SaaS workloads.<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"1168\" height=\"784\" src=\"https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/What-Is-MariaDB-and-Why-Run-It-on-Linux.png\" alt=\"What Is MariaDB and Why Run It on Linux?\" class=\"wp-image-13169 size-full\" srcset=\"https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/What-Is-MariaDB-and-Why-Run-It-on-Linux.png 1168w, https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/What-Is-MariaDB-and-Why-Run-It-on-Linux-150x101.png 150w\" sizes=\"auto, (max-width: 1168px) 100vw, 1168px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"mariadb-vs-mysql-key-differences\"><strong>MariaDB vs MySQL: Key Differences<\/strong><\/h2>\n\n\n\n<p>MariaDB aims for compatibility with MySQL but often ships performance features sooner and keeps components fully open source. For most web apps, using MariaDB is seamless. Still, always test version-specific behavior, plugins, and replication between MariaDB and MySQL before production migrations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"use-cases-for-mariadb-on-a-linux-server\"><strong>Use Cases for MariaDB on a Linux Server<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>WordPress, WooCommerce, and CMS sites needing reliable InnoDB storage<\/li>\n\n\n\n<li>Transactional web apps and APIs requiring ACID compliance<\/li>\n\n\n\n<li>Read-heavy workloads leveraging caching and replicas<\/li>\n\n\n\n<li>High availability with replication or Galera Cluster<\/li>\n\n\n\n<li>Cost-optimized hosting where open-source and performance matter<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"install-mariadb-on-popular-linux-distributions\"><strong>Install MariaDB on Popular Linux Distributions<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"ubuntu-debian\"><strong>Ubuntu\/Debian<\/strong><\/h3>\n\n\n\n<p>Ubuntu and Debian include MariaDB in official repos. Use the distro LTS version for stability or MariaDB.org repositories if you need newer features.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Update packages\nsudo apt update\n\n# <a href=\"https:\/\/www.youstable.com\/blog\/install-mariadb-on-linux-server\/\">Install MariaDB server<\/a> and client\nsudo apt install -y mariadb-server mariadb-client\n\n# Enable and start the service\nsudo systemctl enable mariadb\nsudo systemctl start mariadb\n\n# Check status\nsystemctl status mariadb<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"rhel-centos-almalinux-rocky-linux\"><strong>RHEL\/CentOS\/AlmaLinux\/Rocky Linux<\/strong><\/h3>\n\n\n\n<p>On RHEL family distributions, install via DNF\/YUM. Consider MariaDB\u2019s official repo for newer LTS versions.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Install server\nsudo dnf install -y mariadb-server\n\n# Enable and start\nsudo systemctl enable mariadb\nsudo systemctl start mariadb\n\n# Status\nsystemctl status mariadb<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"opensuse\"><strong>openSUSE<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo zypper refresh\nsudo zypper install mariadb\nsudo systemctl enable mariadb\nsudo systemctl start mariadb<\/code><\/pre>\n\n\n\n<p>Note: If you use the MariaDB.org repository, follow their instructions to add the repo and GPG key before installation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"secure-the-initial-setup\"><strong>Secure the Initial Setup<\/strong><\/h3>\n\n\n\n<p>Run the built-in hardening script, then enforce least privilege, firewall rules, and encrypted connections. This is essential for any public-facing Linux server.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Initial hardening\nsudo mysql_secure_installation\n# Prompts will guide you to:\n# - Set the root password\n# - Remove anonymous users\n# - Disallow remote root login\n# - Remove test database\n# - Reload privilege tables<\/code><\/pre>\n\n\n\n<p>Restrict network exposure. For single-host applications, bind to localhost; otherwise, allow only required interfaces and firewall the port (3306).<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Example: bind to local interface only (edit my.cnf or 50-server.cnf)\n&#91;mysqld]\nbind-address = 127.0.0.1\n\n# UFW (Ubuntu\/Debian)\nsudo ufw allow from &lt;APP-SERVER-IP&gt; to any port 3306 proto tcp\n\n# firewalld (RHEL family)\nsudo firewall-cmd --add-port=3306\/tcp --permanent\nsudo firewall-cmd --reload<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"create-databases-and-users\"><strong>Create Databases and Users<\/strong><\/h3>\n\n\n\n<p>Use separate users per application, restrict host access, and grant only required privileges.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Login as root (password or socket, depending on distro)\nsudo mariadb\n\n-- Create a database\nCREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;\n\n-- Create least-privileged user from a specific host\nCREATE USER 'appuser'@'10.0.0.10' IDENTIFIED BY 'Strong_Passw0rd!';\n\n-- Grant minimal privileges\nGRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER ON appdb.* TO 'appuser'@'10.0.0.10';\n\nFLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"service-management-and-logs\"><strong>Service Management and Logs<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Start\/Stop:<\/strong> sudo systemctl start|stop mariadb<\/li>\n\n\n\n<li><strong>Enable on boot: <\/strong>sudo systemctl enable mariadb<\/li>\n\n\n\n<li><strong>Logs: <\/strong>sudo journalctl -u mariadb, and MariaDB error log (path varies by distro)<\/li>\n\n\n\n<li><strong>Check listening: <\/strong>sudo ss -tulpn | grep 3306<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"performance-tuning-basics-safe-defaults\"><strong>Performance Tuning Basics (Safe Defaults)<\/strong><\/h2>\n\n\n\n<p>Right-size MariaDB for available RAM and workload. For most small to medium WordPress or app servers, InnoDB is the focus. Avoid guesswork; measure and iterate.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Innodb_buffer_pool_size:<\/strong> 50\u201370% of RAM on dedicated DB servers<\/li>\n\n\n\n<li><strong>Innodb_log_file_size:<\/strong> larger logs reduce checkpoints on write-heavy loads<\/li>\n\n\n\n<li><strong>Thread_cache_size and max_connections:<\/strong> match concurrency needs<\/li>\n\n\n\n<li><strong>Slow query log:<\/strong> identify inefficient queries and missing indexes<\/li>\n\n\n\n<li>Disable deprecated query cache on newer versions; use application-level caching<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code># Example: \/etc\/my.cnf or \/etc\/mysql\/mariadb.conf.d\/50-server.cnf\n&#91;mysqld]\n# Networking\nbind-address = 0.0.0.0\nmax_connections = 200\n\n# InnoDB core\ninnodb_buffer_pool_size = 4G\ninnodb_buffer_pool_instances = 4\ninnodb_log_file_size = 1G\ninnodb_flush_method = O_DIRECT\ninnodb_flush_log_at_trx_commit = 1\n\n# Logging\nslow_query_log = 1\nslow_query_log_file = \/var\/log\/mariadb\/slow.log\nlong_query_time = 1\nlog_error = \/var\/log\/mariadb\/mariadb.err\n\n# Charset\ncharacter-set-server = utf8mb4\ncollation-server = utf8mb4_general_ci\n\n# After changes:\n# sudo systemctl restart mariadb<\/code><\/pre>\n\n\n\n<p>Adjust values to your RAM and workload; the sample fits a <a href=\"https:\/\/www.youstable.com\/blog\/secure-dedicated-server\/\">dedicated server<\/a> with \u22658 GB RAM. Always benchmark before and after changes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"backups-and-restores\"><strong>Backups and Restores<\/strong><\/h2>\n\n\n\n<p>Backups are non-negotiable. Use logical dumps for portability and physical backups for speed and consistency. Test restores regularly.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"logical-backup-with-mysqldump\"><strong>Logical backup with mysqldump<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Single database\nmysqldump -u root -p --single-transaction --routines --triggers appdb | gzip &gt; appdb-$(date +%F).sql.gz\n\n# All databases\nmysqldump -u root -p --all-databases --single-transaction | gzip &gt; all-$(date +%F).sql.gz\n\n# Restore\ngunzip &lt; appdb-2025-01-01.sql.gz | mysql -u root -p<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"physical-backup-with-mariabackup\"><strong>Physical backup with Mariabackup<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Install mariabackup (package name may be mariadb-backup)\nsudo apt install -y mariadb-backup || sudo dnf install -y MariaDB-backup\n\n# Full backup\nmariabackup --backup --target-dir=\/backups\/full\/$(date +%F) --user=root --password=***\n\n# Prepare (apply logs)\nmariabackup --prepare --target-dir=\/backups\/full\/2025-01-01\n\n# Restore (service must be stopped)\nsudo systemctl stop mariadb\nsudo rm -rf \/var\/lib\/mysql\/*\nsudo mariabackup --copy-back --target-dir=\/backups\/full\/2025-01-01\nsudo chown -R mysql:mysql \/var\/lib\/mysql\nsudo systemctl start mariadb<\/code><\/pre>\n\n\n\n<p>For point-in-time recovery, enable binary logs (log_bin) and replay from the last full backup.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"replication-and-high-availability\"><strong>Replication and High Availability<\/strong><\/h2>\n\n\n\n<p>Start with asynchronous primary\u2013replica replication for reads and backups. For higher uptime and multi-writer scenarios, use Galera Cluster (MariaDB\u2019s synchronous clustering) and a proxy layer (e.g., HAProxy) to route traffic.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Primary\u2013Replica:<\/strong> Simple, effective read scaling and offloading backups<\/li>\n\n\n\n<li><strong>Galera Cluster:<\/strong> Synchronous multi-master; needs low latency between nodes<\/li>\n\n\n\n<li><strong>Proxy: <\/strong>HAProxy\/ProxySQL to manage failover and connection routing<\/li>\n<\/ul>\n\n\n\n<p>If you prefer a hands-off deployment, YouStable offers managed VPS and cloud servers with pre-optimized MariaDB, automated backups, and 24\/7 monitoring, so your stack stays fast and recoverable.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"monitoring-and-observability\"><strong>Monitoring and Observability<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enable slow query logging and review regularly<\/li>\n\n\n\n<li>Use performance_schema and sys schema views for query insights<\/li>\n\n\n\n<li>Export metrics via MariaDB Exporter for Prometheus\/Grafana<\/li>\n\n\n\n<li><strong>System metrics: <\/strong>CPU, RAM, I\/O, disk latency must be tracked alongside DB metrics<\/li>\n\n\n\n<li>Set alerts on replication lag, <a href=\"https:\/\/www.youstable.com\/blog\/check-disk-space-files-in-linux\/\">disk space<\/a>, and connection spikes<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"security-best-practices\"><strong>Security Best Practices<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use strong passwords or key-based auth; avoid remote root access<\/li>\n\n\n\n<li>Restrict users by host and grant least privileges<\/li>\n\n\n\n<li>Enable TLS for remote connections; rotate certificates<\/li>\n\n\n\n<li><strong>Harden OS:<\/strong> keep kernel and packages updated; enable SELinux\/AppArmor profiles<\/li>\n\n\n\n<li>Isolate the DB on a private network and restrict port 3306 at the firewall<\/li>\n\n\n\n<li>Regularly patch MariaDB to address CVEs and security advisories<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"troubleshooting-common-issues\"><strong>Troubleshooting Common Issues<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"mariadb-wont-start\"><strong>MariaDB won\u2019t start<\/strong><\/h3>\n\n\n\n<p>Check the error log and systemd journal for configuration or permission errors. Configuration typos in my.cnf are a frequent cause.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo journalctl -u mariadb -b\nsudo tail -n 100 \/var\/log\/mariadb\/mariadb.err\nsudo mysqld --verbose --help | less  # validate options<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"cannot-connect-remotely\"><strong>Cannot connect remotely<\/strong><\/h3>\n\n\n\n<p>Verify bind-address, user host permissions, and firewall rules. Test with:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -h &lt;DB-IP&gt; -u appuser -p -e \"SELECT VERSION();\"\nsudo ss -tulpn | grep 3306<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"authentication-plugin-mismatch\"><strong>Authentication plugin mismatch<\/strong><\/h3>\n\n\n\n<p>Some distros default root to unix_socket. If needed for external tooling, create a new admin user with a password-based plugin.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'admin'@'%' IDENTIFIED BY 'Strong_Pass!';\nGRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;\nFLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"real-world-tips-from-production\"><strong>Real-World Tips from Production<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Keep OS and database on separate disks where possible; use SSD\/NVMe<\/li>\n\n\n\n<li>Size swap reasonably but avoid swapping the buffer pool<\/li>\n\n\n\n<li>Pin major version in production; test upgrades in staging<\/li>\n\n\n\n<li>Regularly run ANALYZE TABLE and OPTIMIZE for fragmented tables (off-peak)<\/li>\n\n\n\n<li>Back up before schema changes; use pt-online-schema-change for large tables<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"faqs-mariadb-on-linux-server\"><strong>FAQs: MariaDB on Linux Server<\/strong><\/h2>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1765772018960\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"is-mariadb-a-drop-in-replacement-for-mysql-on-linux\"><strong>Is MariaDB a drop-in replacement for MySQL on Linux?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>In most cases, yes. MariaDB maintains broad compatibility with MySQL clients, protocols, and data files. Still, test application-specific features, plugins, and replication before switching in production.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765772034108\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-do-i-install-mariadb-on-ubuntu\"><strong>How do I install MariaDB on Ubuntu?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Run: sudo apt update, then sudo apt install -y mariadb-server. Start and enable with systemctl, and run mysql_secure_installation to harden the instance. Use the MariaDB.org repo if you need a newer LTS than the Ubuntu repo provides.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765772052370\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"what-are-the-most-important-performance-settings\"><strong>What are the most important performance settings?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Focus on innodb_buffer_pool_size, innodb_log_file_size, max_connections, and enabling the slow query log. Tune based on RAM and workload, then profile queries and add proper indexes.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765772064223\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-should-i-back-up-mariadb\"><strong>How should I back up MariaDB?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Use mysqldump for portable logical backups and Mariabackup for fast, consistent physical backups. Store offsite copies and test restores regularly. Enable binary logs for point-in-time recovery.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765772075487\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-do-i-secure-mariadb-on-a-public-linux-server\"><strong>How do I secure MariaDB on a public Linux server?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Run mysql_secure_installation, restrict port 3306 via UFW\/firewalld, use TLS for remote connections, enforce least privilege on users, keep the OS and MariaDB updated, and enable SELinux\/AppArmor where supported.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>MariaDB on Linux server is an open-source relational database used to store and query application data, built as a drop-in [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":15594,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[350,1195],"tags":[],"class_list":["post-12704","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-knowledgebase","category-blogging"],"acf":[],"featured_image_src":"https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/What-is-MariaDB-on-Linux-Server-Step-by-Step-Setup-and-Backup-Guide.jpg","author_info":{"display_name":"Sanjeet Chauhan","author_link":"https:\/\/www.youstable.com\/blog\/author\/sanjeet"},"_links":{"self":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/12704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/comments?post=12704"}],"version-history":[{"count":10,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/12704\/revisions"}],"predecessor-version":[{"id":15595,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/12704\/revisions\/15595"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/media\/15594"}],"wp:attachment":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/media?parent=12704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/categories?post=12704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/tags?post=12704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}