{"id":5015,"date":"2023-09-13T09:11:42","date_gmt":"2023-09-13T07:11:42","guid":{"rendered":"https:\/\/www.websupport.cz\/blog\/?p=5015"},"modified":"2025-03-11T21:18:30","modified_gmt":"2025-03-11T20:18:30","slug":"mariadb-a-mysql-porovnani-vykon-historie","status":"publish","type":"post","link":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/","title":{"rendered":"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie"},"content":{"rendered":"\n<p>Zdrav\u00e1 konkurence m\u016f\u017ee b\u00fdt i p\u0159\u00ednosn\u00e1. Sta\u010d\u00ed se pod\u00edvat na Apple a Samsung nebo t\u0159eba Burger King a McDonald\u00b4s.\u00a0 <\/p>\n\n\n\n<p>Proto se v minulosti odd\u011blila i MariaDB od MySQL. Jak si z nich vybrat to vhodn\u011bj\u0161\u00ed \u0159e\u0161en\u00ed?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Co je to datab\u00e1ze a jak funguje<\/strong><\/h2>\n\n\n\n<p>Datab\u00e1ze je uspo\u0159\u00e1dan\u00e1 sb\u00edrka dat. M\u016f\u017ee to b\u00fdt jedna \u010di v\u00edce tabulek, ale i v kombinaci s r\u016fzn\u00fdmi dal\u0161\u00edmi objekty. V minulosti jsme poznali pap\u00edrov\u00e9 datab\u00e1ze s po\u0159ada\u010di. Dnes se pou\u017e\u00edvaj\u00ed elektronick\u00e9 a n\u011bkter\u00e9 z nich mohou obsahovat i tis\u00edce r\u016fzn\u00fdch dat.<\/p>\n\n\n\n<p>V tom p\u0159\u00edpad\u011b m\u00e1me dv\u011b mo\u017enosti &#8211; na management dat pou\u017eijeme <strong>tabulkov\u00fd procesor <\/strong>(nap\u0159\u00edklad Excel) nebo pokud je datab\u00e1ze p\u0159\u00edli\u0161 velk\u00e1, jsou tu tzv. <strong>DBMS syst\u00e9my<\/strong> (z anglick\u00e9ho Database Management System), tedy syst\u00e9m pro management datab\u00e1ze.<\/p>\n\n\n\n<p>DBMS pou\u017eijeme i tehdy, pokud chceme:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>jedn\u00edm p\u0159\u00edkazem cel\u00e9 seznamy aktualizovat nebo v nich opravit \u00fadaje,<\/li><li>pracovat i s dal\u0161\u00edmi u\u017eivateli s \u00fadaji najednou,<\/li><li>\u010derpat \u00fadaje z v\u00edcero zdroj\u016f.<\/li><\/ul>\n\n\n\n<p>DBMS umo\u017e\u0148uj\u00ed pracovat s \u00fadaji a zji\u0161\u0165ovat z nich informace. \u010cty\u0159i nej\u010dast\u011bj\u0161\u00ed p\u0159\u00edkazy pro pr\u00e1ci s datab\u00e1z\u00ed jsou <em>insert, search, update a delete<\/em>.<\/p>\n\n\n\n<p>Na vykon\u00e1n\u00ed t\u011bchto p\u0159\u00edkaz\u016f je nutn\u00e9 pou\u017e\u00edt <strong>SQL jazyk<\/strong> (Structured Query Language) a v n\u011bm p\u0159\u00edkaz napsat. Pr\u00e1v\u011b od t\u00e9to zkratky poch\u00e1z\u00ed n\u00e1zev MySQL. N\u00e1zev MariaDB je odvozen\u00fd p\u0159\u00edmo z datab\u00e1ze.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Co je MySQL datab\u00e1ze<\/strong><\/h2>\n\n\n\n<p><a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL<\/a> tvo\u0159\u00ed nejv\u011bt\u0161\u00ed open source datab\u00e1zovou komunitu. MySQL (i MariaDB) je open source rela\u010dn\u00ed datab\u00e1ze.&nbsp;<\/p>\n\n\n\n<p>Open source znamen\u00e1, \u017ee zdrojov\u00fd k\u00f3d je <strong>voln\u011b p\u0159\u00edstupn\u00fd ka\u017ed\u00e9mu<\/strong>. Je mo\u017en\u00e9 jej upravovat podle sv\u00fdch p\u0159edstav \u010di \u0161\u00ed\u0159it sv\u00e9 distribuce d\u00e1le na z\u00e1klad\u011b ve\u0159ejn\u00e9 licence.<\/p>\n\n\n\n<p>Klasick\u00fd DBMS umo\u017e\u0148uje uchov\u00e1vat data jako soubor. <strong>Rela\u010dn\u00ed datab\u00e1ze <\/strong>na druh\u00e9 stran\u011b znamen\u00e1, \u017ee jej\u00ed obsah je strukturovan\u00fd a ulo\u017een\u00fd v tabulk\u00e1ch. Ka\u017ed\u00e1 tabulka obsahuje ur\u010dit\u00fd kone\u010dn\u00fd po\u010det sloupc\u016f \u2013 v nich je takt\u00e9\u017e kone\u010dn\u00fd po\u010det \u0159\u00e1dk\u016f. Rela\u010dn\u00ed datab\u00e1ze tak eliminuje probl\u00e9m s uchov\u00e1v\u00e1n\u00edm nadbyte\u010dn\u00fdch dat, kter\u00fd je \u010dast\u00fd p\u0159i klasick\u00fdch DBMS.<\/p>\n\n\n\n<p>MySQL tak umo\u017e\u0148uje webov\u00fdm v\u00fdvoj\u00e1\u0159\u016fm jednodu\u0161eji pracovat s daty v tabulk\u00e1ch.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/www.websupport.cz\/blog\/wp-content\/uploads\/2023\/09\/logo-mysql-300x207-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.websupport.cz\/blog\/wp-content\/uploads\/2023\/09\/logo-mysql-300x207-1.png\" alt=\"\" class=\"wp-image-5021\" width=\"300\" height=\"207\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Co je MariaDB datab\u00e1ze<\/strong><\/h2>\n\n\n\n<p><a href=\"https:\/\/mariadb.com\" target=\"_blank\" rel=\"noreferrer noopener\">MariaDB<\/a> se jako odno\u017e v minulosti odd\u011blila od MySQL. Tak se rozhodl jeden z b\u00fdval\u00fdch v\u00fdvoj\u00e1\u0159\u016f Oracle a vytvo\u0159il MariaDB na z\u00e1klad\u011b MySQL. Nov\u00e9mu typu open source rela\u010dn\u00ed datab\u00e1ze dal jm\u00e9no po sv\u00e9 dce\u0159i, Marii.<\/p>\n\n\n\n<p>V d\u016fsledku tohoto odd\u011blen\u00ed data i definice tabulek, klientsk\u00e9 protokoly, struktury \u010di API (Application Programming Interface) jsou 100 % kompatibiln\u00ed s p\u016fvodn\u00edmi verzemi MySQL, tedy 5.7 a d\u0159\u00edv\u011bj\u0161\u00edmi.<\/p>\n\n\n\n<p>Tato unik\u00e1tn\u00ed vlastnost zabezpe\u010duje kompatibilitu datab\u00e1z\u00ed p\u0159i migraci z MySQL a do MariaDB i zp\u011bt bez nutnosti cokoliv m\u011bnit.<\/p>\n\n\n\n<p>Je t\u0159eba zd\u016fraznit, \u017ee MariaDB z\u016fstala pln\u011b open source datab\u00e1z\u00ed. Naproti tomu MySQL u\u017e obsahuje moduly, jejich\u017e zdrojov\u00fd k\u00f3d nen\u00ed ve\u0159ejn\u011b p\u0159\u00edstupn\u00fd (closed source).<\/p>\n\n\n\n<p>SQL p\u0159\u00edkazy pro tyto dva typy datab\u00e1z\u00ed jsou toto\u017en\u00e9.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/_Fxb3pkbBAnRwwystbH6a39wH1FPTe5jP7TfHZdTGCTuT1YAZtiIHauOD7xhwmuWib3xTf2OWqk41JOWZQK6WejvPPw8Lj6PjrYCpeNmtTwQ-6e5IwE2zWO2X-FVLdZ-kw4-fewZ7cciKXzf-XbJJRQ\" alt=\"Logo MariaDB\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Jak\u00fd je rozd\u00edl mezi MariaDB a MySQL?<\/strong><\/h2>\n\n\n\n<p>Po odd\u011blen\u00ed MariaDB za\u010dala zdrav\u00e1 konkurence mezi MySQL a MariaDB, kter\u00e1 vedla k \u0161ikovn\u00fdm zlep\u0161en\u00edm. Vzhledem k tomu, \u017ee MySQL je korpor\u00e1tn\u00ed projekt a m\u00e1 dobr\u00e9 finan\u010dn\u00ed z\u00e1zem\u00ed, z\u016fst\u00e1v\u00e1 l\u00eddrem v oblasti datab\u00e1z\u00ed.<\/p>\n\n\n\n<p>MariaDB se sna\u017eila j\u00edt ve stop\u00e1ch MySQL i co se t\u00fd\u010de verz\u00ed. Proto vznikla MariaDB 5.5, kter\u00e1 ve sv\u00e9 podstat\u011b korespondovala s MySQL 5.7. N\u011bkolik verz\u00ed se da\u0159ilo udr\u017eet tento trend, nicm\u00e9n\u011b p\u0159i nejnov\u011bj\u0161\u00edch verz\u00edch u\u017e vid\u00edme rozd\u00edly.<\/p>\n\n\n\n<p>MySQL p\u0159e\u0161la mezi verzemi 5.7 a sou\u010dasnou verz\u00ed 8.x men\u0161\u00edm pokrokem. Nen\u00ed se \u010demu divit. Oracle toti\u017e d\u00e1v\u00e1 p\u0159ednost v\u00fdvoji vlastn\u00edch komer\u010dn\u00edch produkt\u016f, jako je Oracle Database, Oracle Cloud nebo Heatwave. MySQL jako open source proto trochu zaost\u00e1v\u00e1.<\/p>\n\n\n\n<p>Naopak MariaDB d\u00edky sv\u00e9mu nep\u0159etr\u017eit\u00e9mu v\u00fdvoji dos\u00e1hla ji\u017e verze 10.x. Obsahuje v\u0161echny popul\u00e1rn\u00ed open source enginy (zejm\u00e9na pro vyhled\u00e1v\u00e1n\u00ed), n\u011bkter\u00e9 obsahuje nejv\u00fd\u0161e v porovn\u00e1n\u00ed s MySQL. Tak\u00e9 m\u00e1 n\u011bkolik vylep\u0161en\u00ed v oblasti rychlosti a za\u010dala podporovat n\u011bkter\u00e9 dopl\u0148ky, kter\u00e9 nelze do MySQL instalovat. Stejn\u011b tak mnoh\u00e9 dynamick\u00e9 funkce vykon\u00e1van\u00e9 nad polo\u017ekami v tabulk\u00e1ch se daj\u00ed prov\u00e1d\u011bt pouze v MariaDB.<\/p>\n\n\n\n<p>MySQL podporuje nativn\u00ed datov\u00fd typ JSON a standardn\u011b poskytuje SHA-2 autentifika\u010dn\u00ed plugin a plugin <em>validate_password<\/em> defaultn\u011b, zat\u00edmco MariaDB ne.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>A co pr\u00e1vn\u00ed str\u00e1nka?<\/strong><\/h2>\n\n\n\n<p>MariaDB je dodnes p\u0159\u00edstupn\u00e1 na z\u00e1klad\u011b ve\u0159ejn\u00e9 licence (<a href=\"https:\/\/www.gnu.org\/licenses\/gpl-3.0.en.html\" target=\"_blank\" rel=\"noreferrer noopener\">GNU General Public License<\/a>).<\/p>\n\n\n\n<p>MySQL, vzhledem ke sv\u00e9mu korpor\u00e1tn\u00edmu pozad\u00ed, je vyu\u017eiteln\u00e1 na z\u00e1klad\u011b dvou r\u016fzn\u00fdch licenc\u00ed \u2013 na jedn\u00e9 stran\u011b na z\u00e1klad\u011b u\u017e zm\u00edn\u011bn\u00e9 ve\u0159ejn\u00e9 licence, a na druh\u00e9 stran\u011b placen\u00e9 licence hlavn\u011b pro ty, kte\u0159\u00ed necht\u011bj\u00ed, aby zdrojov\u00fd k\u00f3d jejich produktu byl open source.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Komer\u010dn\u00ed podpora<\/strong><\/h2>\n\n\n\n<p>U MySQL je to z\u0159ejm\u00e9. Akvizice datab\u00e1ze firmou Oracle v roce 2010 pokryla i tento aspekt a p\u0159i \u0159e\u0161en\u00ed probl\u00e9m\u016f odpov\u00eddaj\u00ed na ot\u00e1zky v pr\u016fb\u011bhu cel\u00e9ho t\u00fddne p\u0159\u00edmo pracovn\u00edci, experti na tento typ datab\u00e1ze i jej\u00ed v\u00fdvoj\u00e1\u0159i z Oracle.&nbsp;&nbsp;<\/p>\n\n\n\n<p>MariaDB helpdesk se skl\u00e1d\u00e1 \u2013 jak by se dalo \u010dekat \u2013 z expert\u016f na oba druhy datab\u00e1z\u00ed. Nab\u00edzej\u00ed stejn\u011b tak 24\/7 podporu, a dokonce se d\u00e1 koupit i tzv. \u0159e\u0161en\u00ed pro business, kter\u00e9 zabezpe\u010d\u00ed okam\u017eitou pomoc pro kritick\u00e9 projekty. Zakladatel\u00e9 MariaDB v\u011b\u0159\u00ed, \u017ee tento ve\u0159ejn\u00fd model je prosp\u011b\u0161n\u00fd pro v\u00fdvoj, proto\u017ee samotn\u00ed u\u017eivatel\u00e9 mohou nahr\u00e1t (samoz\u0159ejm\u011b po revizi) sv\u00e9 opravy do datab\u00e1ze a p\u0159isp\u011bt tak k vy\u0159e\u0161en\u00ed bezpe\u010dnostn\u00edch probl\u00e9m\u016f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Dokumentace<\/strong><\/h2>\n\n\n\n<p>U MySQL tato povinnost <a href=\"https:\/\/dev.mysql.com\/doc\/\" target=\"_blank\" rel=\"noreferrer noopener\">spad\u00e1 pod Oracle<\/a>. Oracle rozhoduje o v\u00fdvoji a p\u0159ipravuje dokumentaci. Na druh\u00e9 stran\u011b MariaDB je mana\u017eovan\u00fd organizac\u00ed MariaDB Foundation. Je proto v\u00edce otev\u0159en\u00e1 lidem, co\u017e s sebou nese klady i z\u00e1pory. <a href=\"https:\/\/mariadb.com\/kb\/en\/library\/documentation\/\" target=\"_blank\" rel=\"noreferrer noopener\">Dokumentaci<\/a> tvo\u0159\u00ed p\u0159ev\u00e1\u017en\u011b lid\u00e9 z MariaDB Foundation, ale i ostatn\u00ed se mohou pod\u00edlet na tvorb\u011b dokumentace \u010di v\u00fdvoji samotn\u00e9 MariaDB.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Z\u00e1v\u011br, aneb kterou datab\u00e1zi pou\u017e\u00edt&nbsp;<\/strong><\/h2>\n\n\n\n<p>P\u0159i rozhodov\u00e1n\u00ed je pot\u0159eba se v prvn\u00ed \u0159ad\u011b pod\u00edvat na to, pro kter\u00fd typ datab\u00e1ze byla napsan\u00e1 aplikace, kterou chcete pou\u017e\u00edt. Pokud se stane, \u017ee aplikace nevy\u017eaduje pro sv\u016fj chod konkr\u00e9tn\u00ed typ datab\u00e1ze, ot\u00e1zka se vrac\u00ed.<\/p>\n\n\n\n<p>Je t\u0159eba zv\u00e1\u017eit i to, zda vy\u017eadujete funkce obsa\u017een\u00e9 v MySQL. Pokud ne, bude z\u0159ejm\u011b vhodn\u011bj\u0161\u00ed MariaDB, zejm\u00e9na proto, \u017ee na z\u00e1klad\u011b jej\u00edho modelu bude t\u00e9m\u011b\u0159 jist\u011b podporov\u00e1na je\u0161t\u011b dlouhou dobu.<\/p>\n\n\n\n<p>U datab\u00e1ze MySQL a jej\u00edho korpor\u00e1tn\u00edho modelu existuje riziko je\u0161t\u011b v\u011bt\u0161\u00edho zpomalen\u00ed v\u00fdvoje na \u00fakor jejich komer\u010dn\u00ed datab\u00e1ze. Pokud se v\u00e1m l\u00edb\u00ed v\u00edce korpor\u00e1tn\u00ed model MySQL a d\u016fv\u011b\u0159ujete mu, zvolte tuto cestu. Zejm\u00e9na pokud m\u00e1te z\u00e1jem o jejich placenou licenci.<\/p>\n\n\n\n<p>Pokud v\u0161ak v\u011b\u0159\u00edte v s\u00edlu davu spole\u010dn\u011b tvo\u0159\u00edc\u00edho MariaDB, neud\u011bl\u00e1te krok vedle p\u0159i v\u00fdb\u011bru MariaDB 10.5 jako nov\u00e9ho typu va\u0161\u00ed datab\u00e1ze.<\/p>\n\n\n\n<p>Pro dal\u0161\u00ed pr\u00e1ci s datab\u00e1zemi m\u016f\u017eete vyu\u017e\u00edt na\u0161i B\u00e1zi znalost\u00ed, ve kter\u00e9 najdete <a href=\"https:\/\/www.websupport.cz\/podpora\/kb-categories\/databaze\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u0159adu n\u00e1vod\u016f k datab\u00e1z\u00edm<\/a>.<\/p>\n\n\n\n<p>Jakou datab\u00e1zi pou\u017e\u00edv\u00e1te vy a pro\u010d? Dejte n\u00e1m v\u011bd\u011bt v koment\u00e1\u0159\u00edch.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Zdrav\u00e1 konkurence m\u016f\u017ee b\u00fdt i p\u0159\u00ednosn\u00e1. Sta\u010d\u00ed se pod\u00edvat na Apple a Samsung nebo t\u0159eba Burger King a McDonald\u00b4s.\u00a0 Proto se v minulosti odd\u011blila i MariaDB od MySQL. Jak si z nich vybrat to vhodn\u011bj\u0161\u00ed \u0159e\u0161en\u00ed? Co je to datab\u00e1ze a jak funguje Datab\u00e1ze je uspo\u0159\u00e1dan\u00e1 sb\u00edrka dat. M\u016f\u017ee to b\u00fdt jedna \u010di v\u00edce tabulek, [&hellip;]<\/p>\n","protected":false},"author":52,"featured_media":5018,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,767],"tags":[908,228,365,911,46,914,5],"class_list":["post-5015","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technologie","category-vzdelavani","tag-databaze-2","tag-db","tag-historie","tag-mariadb","tag-mysql","tag-porovnani","tag-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie - Websupport.cz Blog<\/title>\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.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie - Websupport.cz Blog\" \/>\n<meta property=\"og:description\" content=\"Zdrav\u00e1 konkurence m\u016f\u017ee b\u00fdt i p\u0159\u00ednosn\u00e1. Sta\u010d\u00ed se pod\u00edvat na Apple a Samsung nebo t\u0159eba Burger King a McDonald\u00b4s.\u00a0 Proto se v minulosti odd\u011blila i MariaDB od MySQL. Jak si z nich vybrat to vhodn\u011bj\u0161\u00ed \u0159e\u0161en\u00ed? Co je to datab\u00e1ze a jak funguje Datab\u00e1ze je uspo\u0159\u00e1dan\u00e1 sb\u00edrka dat. M\u016f\u017ee to b\u00fdt jedna \u010di v\u00edce tabulek, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport.cz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-13T07:11:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-11T20:18:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.cz\/blog\/app\/uploads\/2023\/09\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Websupport Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"Websupport Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/\"},\"author\":{\"name\":\"Websupport Team\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/#\\\/schema\\\/person\\\/a43e75edc087480c464d462cd19c71ed\"},\"headline\":\"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie\",\"datePublished\":\"2023-09-13T07:11:42+00:00\",\"dateModified\":\"2025-03-11T20:18:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/\"},\"wordCount\":1359,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/app\\\/uploads\\\/2023\\\/09\\\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png\",\"keywords\":[\"datab\u00e1ze\",\"db\",\"Historie\",\"MariaDB\",\"MySQL\",\"porovn\u00e1n\u00ed\",\"server\"],\"articleSection\":[\"Technologie\",\"Vzd\u011bl\u00e1v\u00e1n\u00ed\"],\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/\",\"name\":\"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie - Websupport.cz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/app\\\/uploads\\\/2023\\\/09\\\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png\",\"datePublished\":\"2023-09-13T07:11:42+00:00\",\"dateModified\":\"2025-03-11T20:18:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/app\\\/uploads\\\/2023\\\/09\\\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png\",\"contentUrl\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/app\\\/uploads\\\/2023\\\/09\\\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/2023\\\/09\\\/mariadb-a-mysql-porovnani-vykon-historie\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/\",\"name\":\"Websupport.cz Blog\",\"description\":\"Webujte s lehkost\u00ed\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/#organization\",\"name\":\"Websupport.cz Blog\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/app\\\/uploads\\\/2021\\\/06\\\/websupport-logo.svg\",\"contentUrl\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/app\\\/uploads\\\/2021\\\/06\\\/websupport-logo.svg\",\"width\":153,\"height\":48,\"caption\":\"Websupport.cz Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/#\\\/schema\\\/person\\\/a43e75edc087480c464d462cd19c71ed\",\"name\":\"Websupport Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c21b5b2e7e8bc8ec91ca24b033813e79b87399c7458127a45daa9ea14c6450ca?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c21b5b2e7e8bc8ec91ca24b033813e79b87399c7458127a45daa9ea14c6450ca?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c21b5b2e7e8bc8ec91ca24b033813e79b87399c7458127a45daa9ea14c6450ca?s=96&d=mm&r=g\",\"caption\":\"Websupport Team\"},\"url\":\"https:\\\/\\\/www.websupport.cz\\\/blog\\\/author\\\/websupport-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie - Websupport.cz Blog","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.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/","og_locale":"cs_CZ","og_type":"article","og_title":"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie - Websupport.cz Blog","og_description":"Zdrav\u00e1 konkurence m\u016f\u017ee b\u00fdt i p\u0159\u00ednosn\u00e1. Sta\u010d\u00ed se pod\u00edvat na Apple a Samsung nebo t\u0159eba Burger King a McDonald\u00b4s.\u00a0 Proto se v minulosti odd\u011blila i MariaDB od MySQL. Jak si z nich vybrat to vhodn\u011bj\u0161\u00ed \u0159e\u0161en\u00ed? Co je to datab\u00e1ze a jak funguje Datab\u00e1ze je uspo\u0159\u00e1dan\u00e1 sb\u00edrka dat. M\u016f\u017ee to b\u00fdt jedna \u010di v\u00edce tabulek, [&hellip;]","og_url":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/","og_site_name":"Websupport.cz Blog","article_published_time":"2023-09-13T07:11:42+00:00","article_modified_time":"2025-03-11T20:18:30+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/www.websupport.cz\/blog\/app\/uploads\/2023\/09\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png","type":"image\/png"}],"author":"Websupport Team","twitter_card":"summary_large_image","twitter_misc":{"Napsal(a)":"Websupport Team","Odhadovan\u00e1 doba \u010dten\u00ed":"6 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/#article","isPartOf":{"@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/"},"author":{"name":"Websupport Team","@id":"https:\/\/www.websupport.cz\/blog\/#\/schema\/person\/a43e75edc087480c464d462cd19c71ed"},"headline":"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie","datePublished":"2023-09-13T07:11:42+00:00","dateModified":"2025-03-11T20:18:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/"},"wordCount":1359,"commentCount":0,"publisher":{"@id":"https:\/\/www.websupport.cz\/blog\/#organization"},"image":{"@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.cz\/blog\/app\/uploads\/2023\/09\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png","keywords":["datab\u00e1ze","db","Historie","MariaDB","MySQL","porovn\u00e1n\u00ed","server"],"articleSection":["Technologie","Vzd\u011bl\u00e1v\u00e1n\u00ed"],"inLanguage":"cs","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/","url":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/","name":"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie - Websupport.cz Blog","isPartOf":{"@id":"https:\/\/www.websupport.cz\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.cz\/blog\/app\/uploads\/2023\/09\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png","datePublished":"2023-09-13T07:11:42+00:00","dateModified":"2025-03-11T20:18:30+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/#primaryimage","url":"https:\/\/www.websupport.cz\/blog\/app\/uploads\/2023\/09\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png","contentUrl":"https:\/\/www.websupport.cz\/blog\/app\/uploads\/2023\/09\/MariaSQ-a-MySQL-Jaky-je-mezi-nimi-rozdil_1920x1080_BLOG.png","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.cz\/blog\/2023\/09\/mariadb-a-mysql-porovnani-vykon-historie\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.cz\/blog\/"},{"@type":"ListItem","position":2,"name":"MariaDB a MySQL: Porovn\u00e1n\u00ed, v\u00fdkon, historie"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.cz\/blog\/#website","url":"https:\/\/www.websupport.cz\/blog\/","name":"Websupport.cz Blog","description":"Webujte s lehkost\u00ed","publisher":{"@id":"https:\/\/www.websupport.cz\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.cz\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":"Organization","@id":"https:\/\/www.websupport.cz\/blog\/#organization","name":"Websupport.cz Blog","url":"https:\/\/www.websupport.cz\/blog\/","logo":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.websupport.cz\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.websupport.cz\/blog\/app\/uploads\/2021\/06\/websupport-logo.svg","contentUrl":"https:\/\/www.websupport.cz\/blog\/app\/uploads\/2021\/06\/websupport-logo.svg","width":153,"height":48,"caption":"Websupport.cz Blog"},"image":{"@id":"https:\/\/www.websupport.cz\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.websupport.cz\/blog\/#\/schema\/person\/a43e75edc087480c464d462cd19c71ed","name":"Websupport Team","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/secure.gravatar.com\/avatar\/c21b5b2e7e8bc8ec91ca24b033813e79b87399c7458127a45daa9ea14c6450ca?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c21b5b2e7e8bc8ec91ca24b033813e79b87399c7458127a45daa9ea14c6450ca?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c21b5b2e7e8bc8ec91ca24b033813e79b87399c7458127a45daa9ea14c6450ca?s=96&d=mm&r=g","caption":"Websupport Team"},"url":"https:\/\/www.websupport.cz\/blog\/author\/websupport-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/posts\/5015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/comments?post=5015"}],"version-history":[{"count":5,"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/posts\/5015\/revisions"}],"predecessor-version":[{"id":5039,"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/posts\/5015\/revisions\/5039"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/media\/5018"}],"wp:attachment":[{"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/media?parent=5015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/categories?post=5015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.websupport.cz\/blog\/wp-json\/wp\/v2\/tags?post=5015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}