Mysql: Difference between revisions
imported>Onny Initial page |
m links to mysql and mariadb and second example to differentiate between both engines |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
MySQL | [https://www.mysql.com MySQL] and [https://mariadb.org MariaDB] are installed via the same services.mysql configuration. | ||
* MySQL is a widely used open source relational database management system (RDBMS) that offers various features, tools, and services for data warehousing, analytics, machine learning, and more. | |||
* MariaDB is a popular and stable fork of MySQL that is compatible with MySQL and has additional enhancements and features. | |||
Setup and enable Mysql (MariaDB | = Setup MySQL = | ||
Setup and enable Mysql database daemon (in this example: latest stable version in nixpkgs) | |||
<syntaxhighlight lang="nix"> | |||
services.mysql = { | |||
enable = true; | |||
package = pkgs.mysql; | |||
}; | |||
</syntaxhighlight> | |||
= Setup MariaDB = | |||
Setup and enable MariaDB database daemon (in this example: version 11.0) | |||
<syntaxhighlight lang="nix"> | <syntaxhighlight lang="nix"> | ||
services.mysql | services.mysql = { | ||
enable = true; | |||
package = pkgs.mariadb_110; | |||
}; | |||
</syntaxhighlight> | </syntaxhighlight> | ||