{"id":28186,"date":"2017-11-06T14:33:34","date_gmt":"2017-11-06T12:33:34","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=28186"},"modified":"2017-11-06T14:33:34","modified_gmt":"2017-11-06T12:33:34","slug":"mysql-vs-mariadb-reality-check","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2017\/11\/06\/mysql-vs-mariadb-reality-check\/","title":{"rendered":"MySQL vs. MariaDB: Reality Check"},"content":{"rendered":"\n

Percona Database Performance Blog<\/a> runs this post –\u00a0MySQL vs. MariaDB: Reality Check<\/a> – comparing the MySQL, MariaDB and the Percona Server for MySQL.\u00a0 I think that most people using MySQL or MariaDB today consider them to be pretty much identical (a fork for legal reasons or something along those lines).\u00a0 \u00a0This blog post shows that there are quite a few significant differences.<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n

Percona Database Performance Blog runs this post –\u00a0MySQL vs. MariaDB: Reality Check – comparing the MySQL, MariaDB and the Percona Server for MySQL.\u00a0 I think that most people using MySQL or MariaDB today consider them to be pretty much identical (a fork for legal reasons or something along those lines).\u00a0 \u00a0This blog post shows that … Continue reading MySQL vs. MariaDB: Reality Check<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"MySQL vs. MariaDB: Reality Check #WebDev #MySQL #databases #comparison","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},"_links_to":"","_links_to_target":""},"categories":[1,18,133,62,1334],"tags":[3324,1559,3066,1330],"keyring_services":[],"class_list":["post-28186","post","type-post","status-publish","format-standard","hentry","category-general","category-programming","category-sysadmin","category-technology","category-web-work","tag-comparison","tag-databases","tag-mysql","tag-web-development"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":28909,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/11\/04\/mycli-mysql-command-line-client-with-auto-completion\/","url_meta":{"origin":28186,"position":0},"title":"mycli – MySQL command line client with auto-completion","author":"Leonid Mamchenkov","date":"November 4, 2018","format":false,"excerpt":"mycli is a MySQL \/ MariaDB \/ Pecona database command line client with syntax highlighting and auto-completion.\u00a0 Have a look at some of the screenshots and documentation for features. Found via this StackOverflow discussion.","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/11\/mycli-500x181.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":42747,"url":"https:\/\/mamchenkov.net\/wordpress\/2019\/06\/27\/calculating-distance-using-mysql\/","url_meta":{"origin":28186,"position":1},"title":"Calculating distance using MySQL","author":"Leonid Mamchenkov","date":"June 27, 2019","format":false,"excerpt":"\"Calculating distance using MySQL\" is a very useful blog post for everyone who works with geographical location data and MySQL. It shows a simple example of how to calculate the distance between two coordinates on a sphere (Earth in particular) within the MySQL itself. SELECT ST_Distance_Sphere( point(-87.6770458, 41.9631174), point(-73.9898293, 40.7628267)\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2019\/06\/mysql-distance.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2019\/06\/mysql-distance.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2019\/06\/mysql-distance.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2019\/06\/mysql-distance.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2019\/06\/mysql-distance.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2019\/06\/mysql-distance.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":27094,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/12\/10\/taking-the-pain-out-of-mysql-schema-changes\/","url_meta":{"origin":28186,"position":2},"title":"Taking the Pain Out of MySQL Schema Changes","author":"Leonid Mamchenkov","date":"December 10, 2016","format":false,"excerpt":"\"Taking the Pain Out of MySQL Schema Changes\" covers the following approaches to deploying MySQL schema changes: Schema Change in Downtime Role Swap (cluster setup) pt-online-schema-change The last one is the usage of\u00a0pt-online-schema-change tool developed by Percona guys, as part of their Percona Toolkit - an Open Source set of\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28263,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/11\/30\/change-sql-mode-for-mariadb-in-fedora-27\/","url_meta":{"origin":28186,"position":3},"title":"Change SQL mode for MariaDB in Fedora 27","author":"Leonid Mamchenkov","date":"November 30, 2017","format":false,"excerpt":"After I upgraded my laptop to Fedora 27, I started experiencing some weird issues with most of the projects I am developing locally.\u00a0 Trying to save anything into the database that involves dates, started throwing the following errors: A quick look around showed that Fedora 27 ships MariaDB v10.2, while\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26925,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/11\/21\/fixing-innodb-error-log-file-ib_logfile0-is-of-different-size\/","url_meta":{"origin":28186,"position":4},"title":"Fixing “InnoDB: Error: log file .\/ib_logfile0 is of different size”","author":"Leonid Mamchenkov","date":"November 21, 2016","format":false,"excerpt":"For the last few days I've been moving MySQL databases around at work. \u00a0Being a bit in a rush and overconfident (I have backups!), \u00a0I was simply detaching the \/var\/lib\/mysql volume on one host (running Amazon AMI and MySQL) and attaching it to another host (running CentOS 7 and MariaDB).\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":18039,"url":"https:\/\/mamchenkov.net\/wordpress\/2013\/04\/19\/fedora-19-alpha-is-a-go\/","url_meta":{"origin":28186,"position":5},"title":"Fedora 19 alpha is a Go","author":"Leonid Mamchenkov","date":"April 19, 2013","format":false,"excerpt":"Fedora 19 alpha version will be released next Tuesday. \u00a0I've been busy with other things recently, so that was a surprising announcement for me. Is it that time of the year again? \u00a0Apparently. \u00a0We are still a good three month away from the final release, but it's still good to\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/28186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=28186"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/28186\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=28186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=28186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=28186"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=28186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}