<story><title>Migrating Facebook to MySQL 8.0</title><url>https://engineering.fb.com/2021/07/22/data-infrastructure/mysql/</url></story><parent_chain><item><author>lucideer</author><text>That was the expectation but the Oracle camp surprised everyone by actually giving it some attention, and meanwhile MariaDB&amp;#x27;s promise of being a &amp;quot;100% compatible drop-in replacement&amp;quot; came with more and more caveats with each release (as is to be entirely expected with any fork).&lt;p&gt;When you consider the network effect of all the stacks already heavily invested in MySQL, all Oracle really needed to do was put in a modicum of effort to MySQL to stave off the MariaDB migrations (and from my understanding they&amp;#x27;ve put in quite a bit more than a modicum).&lt;p&gt;Lastly, Postgres is an interesting player. Migrating from MySQL to Postgres might be a scarier prospect than to MariaDB, but since the Oracle acquisition a lot of MySQL-veterans were looking for something non-MySQL for &lt;i&gt;new&lt;/i&gt; projects and in that I get the sense Postgres beat out MariaDB.</text></item><item><author>takeda</author><text>Perhaps it&amp;#x27;s due to me being in the PostgreSQL camp, but what happened to MariaDB? I was convinced that&amp;#x27;s where MySQL developers went and that&amp;#x27;s where development proceeded, while MySQL was just half dead, because Oracle did not care about it.</text></item></parent_chain><comment><author>munk-a</author><text>I carried out a (quite ill-advised in retrospect) migration from MySQL to Postgres on a mature codebase with absolutely no automated test coverage and it went pretty smoothly.  We had some bumpy performance directly after the production migration but we were able to reach parity after about two months of observing and adding targeted indices.&lt;p&gt;I absolutely adore Postgres&amp;#x27;s tweaks to the SQL language, that dialect is amazing and has served us extremely well.  And, since we passed pg10 a while back, the performance tuning you can do on it is pretty amazing.</text></comment>
<story><title>Migrating Facebook to MySQL 8.0</title><url>https://engineering.fb.com/2021/07/22/data-infrastructure/mysql/</url></story><parent_chain><item><author>lucideer</author><text>That was the expectation but the Oracle camp surprised everyone by actually giving it some attention, and meanwhile MariaDB&amp;#x27;s promise of being a &amp;quot;100% compatible drop-in replacement&amp;quot; came with more and more caveats with each release (as is to be entirely expected with any fork).&lt;p&gt;When you consider the network effect of all the stacks already heavily invested in MySQL, all Oracle really needed to do was put in a modicum of effort to MySQL to stave off the MariaDB migrations (and from my understanding they&amp;#x27;ve put in quite a bit more than a modicum).&lt;p&gt;Lastly, Postgres is an interesting player. Migrating from MySQL to Postgres might be a scarier prospect than to MariaDB, but since the Oracle acquisition a lot of MySQL-veterans were looking for something non-MySQL for &lt;i&gt;new&lt;/i&gt; projects and in that I get the sense Postgres beat out MariaDB.</text></item><item><author>takeda</author><text>Perhaps it&amp;#x27;s due to me being in the PostgreSQL camp, but what happened to MariaDB? I was convinced that&amp;#x27;s where MySQL developers went and that&amp;#x27;s where development proceeded, while MySQL was just half dead, because Oracle did not care about it.</text></item></parent_chain><comment><author>sltkr</author><text>I was curious so I looked up the differences here:&lt;p&gt;&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;mariadb.com&amp;#x2F;kb&amp;#x2F;en&amp;#x2F;mariadb-vs-mysql-compatibility&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;mariadb.com&amp;#x2F;kb&amp;#x2F;en&amp;#x2F;mariadb-vs-mysql-compatibility&amp;#x2F;&lt;/a&gt;&lt;p&gt;It doesn&amp;#x27;t sound too bad. The incompabilities seem to be mostly stuff like not being able to generally use replication from MySQL to MariaDB or vice versa. But I would guess that&amp;#x27;s not a very common case anyway: most users are either developers that want their software to work with both MariaDB and MySQL (which can be achieved by sticking to the very large intersection of supported features), or they are users that want to switch from MySQL to MariaDB (which seems well-supported). Running a mix of MariaDB and MySQL servers and expecting to be able to replicate between them seems like a particularly uncommon setup (though maybe it&amp;#x27;s useful during a migration).</text></comment>