ankane / setup-mariadb Goto Github PK

View Code? Open in Web Editor NEW

21.0 3.0 12.0 57 KB

The missing action for MariaDB

License: MIT License

JavaScript 100.00%

setup-mariadb's Introduction

setup-mariadb

The missing action for MariaDB 🎉

Simpler than containers
Works on Linux, Mac, and Windows
Supports different versions

Getting Started

Add it as a step to your workflow

      - uses: ankane/setup-mariadb@v1

Versions

Specify a version

      - uses: ankane/setup-mariadb@v1
        with:
          mariadb-version: "10.11"

Currently supports

Version	`11.2`	`11.1`	`11.0`	`10.11`	`10.6`	`10.5`
`ubuntu-22.04`	✓	✓	✓	default
`ubuntu-20.04`	✓	✓	✓	default	✓	✓
`macos-14`	✓	✓	✓	default	✓	✓
`macos-13`	✓	✓	✓	default	✓	✓
`macos-12`	✓	✓	✓	default	✓	✓
`windows-2022`	✓	✓	✓	default	✓	✓
`windows-2019`	✓	✓	✓	default	✓	✓

Test against multiple versions

    strategy:
      matrix:
        mariadb-version: ["11.2", "11.1", "11.0", "10.11"]
    steps:
      - uses: ankane/setup-mariadb@v1
        with:
          mariadb-version: ${{ matrix.mariadb-version }}

Options

Create a database

      - uses: ankane/setup-mariadb@v1
        with:
          database: testdb

Extra Steps

Run queries

      - run: mysql -D testdb -e 'SELECT VERSION()'

Related Actions

Contributing

Everyone is encouraged to help improve this project. Here are a few ways you can help:

Report bugs
Fix bugs and submit pull requests
Write, clarify, or fix documentation
Suggest or add new features

setup-mariadb's People

Contributors

Stargazers

Watchers

Forkers

r-dbi krlmlr lgraham1 makigumo zhanhb zach2good mariadb-colebusby alexlambson ghuysmans catsandboats

setup-mariadb's Issues

Errors on macOS only

Example: https://github.com/r-dbi/RMariaDB/runs/1795874124?check_suite_focus=true#step:12:60. Any ideas?

Allow caching the downloaded file.

The download from mariadb sometimes fails and takes about 6 seconds.
The downloaded file could be cached (by using actions/cache inside the setup-mariadb action).

2024-03-10T14:19:47.1780788Z curl -Ls -o mariadb.msi https://downloads.mariadb.com/MariaDB/mariadb-10.11.6/winx64-packages/mariadb-10.11.6-winx64.msi
2024-03-10T14:19:53.8303235Z msiexec /i mariadb.msi SERVICENAME=MariaDB /qn
2024-03-10T14:20:29.1565456Z

Socket connection on Linux supported?

https://github.com/r-dbi/RMariaDB/pull/185/checks?check_run_id=1484154324#step:13:160

On Linux I'm seeing with RMariaDB:

Error: Failed to connect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I wonder why mysql commands work, wouldn't they also use the socket by default? Is the socket in a different location?

Per https://mariadb.com/kb/en/missing-mysqldsock-file/#comment_165, do we need

ln -s /tmp/mysql.sock /var/run/mysqld/mysqld.sock

Compare with docker option

The readme might do with some pros and cons compared the docker ways of doing this. Some thoughts:

speed (my tests show this one slightly slower at around 40 seconds compared to 25)
client tools. This approach installs the proper mariadb client executable accessible to the tests
avoid collisions. This approach uninstalls mysql which is already installed in github actions.
socket connections available (haven't tested yet as to whether that will help with speed or reliability)

Need quotes around version?

      with:
        mariadb-version: 11.0

gave me: Invalid MariaDB version: 11 : https://github.com/r-dbi/RMariaDB/actions/runs/5262998831/jobs/9512728749?pr=299#step:7:100

This seems to work:

      with:
        mariadb-version: "11.0"

Action leaves .msi file in checkout directory on Windows

https://github.com/r-dbi/RMariaDB/runs/1483985818?check_suite_focus=true#step:14:89

 Non-standard file/directory found at top level:
    'mariadb.msi'

I can add to .Rbuildignore for now.

Thanks for providing these actions, they save a ton of time!

Support for MariaDB 10.10

Hello, it's me again :) 10.10 is the current stable release now

Ideas

Add database and user inputs

Support for MariaDB 10.9

It's in the title :)