• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
You are here: Home » MariaDB Vs Percona For WordPress Installation

By Abhishek Ghosh August 28, 2018 3:15 am Updated on January 29, 2022

MariaDB Vs Percona For WordPress Installation

Advertisement

Regular visitors of this website probably noticed we preferentially use Percona MySQL in our tutorials and scripts. Whereas, most of the sysadmin related websites and guides for installation of WordPress uses MariaDB. Here is a Practical Comparison of MariaDB Vs Percona For WordPress Installation. Do we have any special reason to prefer Percona MySQL? Yes. We are long term users of Percona. We are more used with tools and stuffs of Percona. MariaDB and Percona probably does not have any difference. This also applies to the use of their complementary tools, for example, most of the MariaDB GUI also supports Percona. Indeed, MariaDB is suitable for some non-WordPress database works. Many articles on the web may tend to point towards either wrong things or outdated things.

WordPress stores all data except images in MySQL database. The MySQL server returns the result of that query, and the PHP continues to execute the WordPress PHP files. WordPress uses default MySQL database engine. Which before MySQL version 5.5 was MyISAM. MyISAM has performance issues. InnoDB is practical choice as database engine and that is the reason 4 years back we had guides like MyISAM vs Innodb MySQL Engine.

MariaDB Vs Percona For WordPress Installation

 

MariaDB Vs Percona For WordPress Installation

 

Most people using MariaDB today probably consider it is just legal fork of original MySQL and Percona probably some proprietary. Not that. Percona Server full GNU GPL.

Advertisement

---

Percona XtraDB is a storage engine both for the MariaDB and Percona Server databases, intended as a drop-in replacement to InnoDB. MariaDB onced used Percona’s XtraDB as the default storage engine as InnoDB. MariaDB from version 10.2, again InnoDB engine is the default engine. For InnoDB, with Percona we are getting XtraDB as default engine. MariaDB cherry-picked MySQL features, they does not guarantee any drop-in compatibility with original MySQL. WordPress tends to be heavily weighted toward read-only queries where InnoDB should give good benefit as it caches data pages as well as indexes. Improvements in XtraDB are designed to help as the number of Threads_running gets higher, or the buffer pool gets larger.

Most of the sysadmin issues with Percona (like currently Ubuntu 18.04 has problem with auto-restart, we pointed a fix in our installation guide) actually gets fixed following original MySQL or MariaDB. Percona of course has more tools for optimization. Newer Percona server usually enough tweaked to power smaller sized WordPress site. No extra tweak more than we do needed. Percona Server will offer minimum advantage out of improvements even to low traffic sites.

For us, Percona is easier to use Percona our tutorials and scripts. We will rather give the readers the options to decide whether after through research they need to use MariaDB. Percona claims that their MySQL server is better. We are talking about using dedicated servers.

Although MariaDB and Percona not hugely different up to medium sized sites, one must treat them as different. Switching may invite minor troubles at front-end.

Tagged With wordpress mariadb optimization , mariadb storage engines , wordpress mariadb optimization language:en , percona vs mariadb , WordPress DB percona VS mariadb , wordpress and percona , Percona wordpress , percona default innodb , paperuri:(cd8d73e9990bc92a7224fc668c95ef60) , WordPress percona xtradb

This Article Has Been Shared 177 Times!

Facebook Twitter Pinterest

Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to MariaDB Vs Percona For WordPress Installation

  • Best Tools For Web Server Log Processing & Statistics Running WordPress

    Commonly We Run One Server One WordPress Website Setup. Here Are Some Best Tools For Web Server Log Processing & Statistics Running WordPress Which Are Self-Hosted.

  • How To Set Up rsnapshot For Backup Of WordPress on Cloud Server/VPS

    rsnapshot Once Set, Can Automatically Incrementally Backup. Here is How To Set Up rsnapshot For Backup Of WordPress on Cloud Server/VPS.

  • Fail2Ban For Web Hosts Without Root Access (PHP Port of Fail2Ban)

    It is Possible to Use Fail2Ban For Web Hosts Without Root Access on Shared Servers of PasS. There is PHP Port of Fail2Ban.

  • Autostart MySQL After a Crash : Solve WordPress Database Connection Error

    WordPress Error establishing a database connection is a frequent problem. Here is one fallback way to autostart MySQL after a crash.

  • WordPress Security : Apache2 Module to Log HTTP POST Method

    Technically We Should Log HTTP Request Methods. Here is How to Apache Module to Log HTTP POST Method, As Example For WordPress Installation.

Additionally, performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

Get new posts by email:

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (24.3K Followers)
  • Twitter (5.8k Followers)
  • Facebook (5.7k Followers)
  • LinkedIn (3.7k Followers)
  • YouTube (1.3k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • Four Foolproof Tips To Never Run Out Of Blog Ideas For Your Website March 28, 2023
  • The Interactive Entertainment Serving as a Tech Proving Ground March 28, 2023
  • Is it Good to Run Apache Web server and MySQL Database on Separate Cloud Servers? March 27, 2023
  • Advantages of Cloud Server Over Dedicated Server for Hosting WordPress March 26, 2023
  • Get Audiophile-Grade Music on Your Smartphone March 25, 2023

About This Article

Cite this article as: Abhishek Ghosh, "MariaDB Vs Percona For WordPress Installation," in The Customize Windows, August 28, 2018, March 29, 2023, https://thecustomizewindows.com/2018/08/mariadb-vs-percona-for-wordpress-installation/.

Source:The Customize Windows, JiMA.in

PC users can consult Corrine Chorney for Security.

Want to know more about us? Read Notability and Mentions & Our Setup.

Copyright © 2023 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT