[docs] Switch from MySQL to MariaDB
ClosedPublic
Actions

Authored by ashoat on Jul 19 2022, 1:04 PM.

Details

Reviewers

atul
tomek

Commits

rCOMM2a76b8cc3a0a: [docs] Switch from MySQL to MariaDB

Summary

This updates our dev environment instructions to tell the user to install MariaDB instead of MySQL.

Test Plan

I ran these instructions on my own machine and confirmed things work. I also created this Gist with instructions for migrating

Diff Detail

Repository

rCOMM Comm

Branch

ashoat/mariadb

Lint

No Lint Coverage

Unit

No Test Coverage

Event Timeline

ashoat created this revision.Jul 19 2022, 1:04 PM

Herald added subscribers: • abosh, • adrian. · View Herald TranscriptJul 19 2022, 1:04 PM

ashoat added inline comments.Jul 19 2022, 1:05 PM

docs/dev_environment.md
125	I added a note here to explain why we're still using "mysql" commands
128	This isn't necessary anywhere since the Brew `mariadb` keg isn't "keg-only" like the `mysql@5.7` (versioned ones are usually keg-only, but unversioned usually aren't)

Harbormaster completed remote builds in B10656: Diff 14667.Jul 19 2022, 1:20 PM

ashoat requested review of this revision.Jul 19 2022, 1:20 PM

Was able to switch over from MySQL to MariaDB on my MacBook. I can confirm that TablePlus continues to work with the steps in this doc.

After following the steps, I ran into:

ERROR 1006 (HY000): Can't create database 'comm' (errno: 2 "No such file or directory")

when I tried running:

CREATE DATABASE comm;

After minimal research online, it seemed like it was a permissions-related issue. I decided to restart my computer on a whim (I'd stopped the mysql service and uninstalled and unlinked mysql@5.7, but figured just in case there was something still lingering from the previous mysql installation?), and that seemed to resolve the issue for me.

I realize "restart your computer" isn't a great solution nor does it help determine the root cause... but it got things working for me.

This revision is now accepted and ready to land.Jul 19 2022, 2:44 PM

Realized that something is a bit borked with backup/restore on MariaDB, so holding off on this for now