• 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 August 28, 2018

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. 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 percona vs mariadb , WordPress DB percona VS mariadb , Percona wordpress , percona default innodb , paperuri:(cd8d73e9990bc92a7224fc668c95ef60) , mariadb vs percona wordpress

This Article Has Been Shared 591 Times!

Facebook Twitter Pinterest
Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Orthopaedic 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

  • Install, Configure Brotli On Apache, WordPress, W3TC

    All In One Guide To Install, Configure Brotli On Apache, WordPress, W3TC Running On Ubuntu 16.04 On Dedicated Server, Cloud Server Instance.

  • 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.

  • How to Upgrade Kernel of Ubuntu Server 16.04 (Cloud Server)

    Here is How to Upgrade Kernel of Ubuntu Server 16.04 Cloud Server to Latest. Newer enablement stacks are meant for server including cloud.

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

You can subscribe to our Free Once a Day, Regular Newsletter by clicking the subscribe button below.

Click To Subscribe

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 (21K Followers)
  • Twitter (5.3k 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

  • What is Standard Software February 28, 2021
  • WordPress Link to text Fragment February 27, 2021
  • How to Protect IP Cameras From Hackers February 25, 2021
  • 6 Sectors That Have Undergone Revamps in Digital Landscape February 24, 2021
  • What You Can Control with a Smartwatch and ESP32 February 23, 2021

 

About This Article

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

Source:The Customize Windows, JiMA.in

 

This website uses cookies. If you do not want to allow us to use cookies and/or non-personalized Ads, kindly clear browser cookies after closing this webpage.

Read Cookie Policy.

PC users can consult Corrine Chorney for Security.

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

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

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