Author: sandervanderburg
Date: Fri Jan 20 10:43:18 2012
New Revision: 31732
URL: https://nixos.org/websvn/nix/?rev=31732&sc=1
Log:
Added MySQL 5.5 NixOS service
Added:
nixos/trunk/modules/services/databases/mysql55.nix
Modified:
nixos/trunk/modules/module-list.nix
Modified: nixos/trunk/modules/module-list.nix
==============================================================================
--- nixos/trunk/modules/module-list.nix Fri Jan 20 00:50:16 2012 (r31731)
+++ nixos/trunk/modules/module-list.nix Fri Jan 20 10:43:18 2012 (r31732)
@@ -62,6 +62,7 @@
./services/databases/4store.nix
./services/databases/mongodb.nix
./services/databases/mysql.nix
+ ./services/databases/mysql55.nix
./services/databases/openldap.nix
./services/databases/postgresql.nix
./services/databases/virtuoso.nix
Added: nixos/trunk/modules/services/databases/mysql55.nix
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ nixos/trunk/modules/services/databases/mysql55.nix Fri Jan 20 10:43:18
2012 (r31732)
@@ -0,0 +1,231 @@
+{ config, pkgs, ... }:
+
+with pkgs.lib;
+
+let
+
+ cfg = config.services.mysql55;
+
+ mysql = cfg.package;
+
+ pidFile = "${cfg.pidDir}/mysqld.pid";
+
+ mysqldOptions =
+ "--user=${cfg.user} --datadir=${cfg.dataDir} " +
+ "--log-error=${cfg.logError} --pid-file=${pidFile}";
+
+ myCnf = pkgs.writeText "my.cnf"
+ ''
+ [mysqld]
+ ${optionalString (cfg.replication.role == "master" || cfg.replication.role
== "slave") "log-bin=mysql-bin"}
+ ${optionalString (cfg.replication.role == "master" || cfg.replication.role
== "slave") "server-id = ${toString cfg.replication.serverId}"}
+ '';
+
+in
+
+{
+
+ ###### interface
+
+ options = {
+
+ services.mysql55 = {
+
+ enable = mkOption {
+ default = false;
+ description = "
+ Whether to enable the MySQL server.
+ ";
+ };
+
+ package = mkOption {
+ default = pkgs.mysql55;
+ description = "
+ Which MySQL derivation to use.
+ ";
+ };
+
+ port = mkOption {
+ default = "3306";
+ description = "Port of MySQL";
+ };
+
+ user = mkOption {
+ default = "mysql";
+ description = "User account under which MySQL runs";
+ };
+
+ dataDir = mkOption {
+ default = "/var/mysql"; # !!! should be /var/db/mysql
+ description = "Location where MySQL stores its table files";
+ };
+
+ logError = mkOption {
+ default = "/var/log/mysql_err.log";
+ description = "Location of the MySQL error logfile";
+ };
+
+ pidDir = mkOption {
+ default = "/var/run/mysql";
+ description = "Location of the file which stores the PID of the MySQL
server";
+ };
+
+ initialDatabases = mkOption {
+ default = [];
+ description = "List of database names and their initial schemas that
should be used to create databases on the first startup of MySQL";
+ example = [
+ { name = "foodatabase"; schema = ./foodatabase.sql; }
+ { name = "bardatabase"; schema = ./bardatabase.sql; }
+ ];
+ };
+
+ initialScript = mkOption {
+ default = null;
+ description = "A file containing SQL statements to be executed on the
first startup. Can be used for granting certain permissions on the database";
+ };
+
+ rootPassword = mkOption {
+ default = null;
+ description = "Path to a file containing the root password, modified
on the first startup. Not specifying a root password will leave the root
password empty.";
+ };
+
+ replication = {
+ role = mkOption {
+ default = "none";
+ description = "Role of the MySQL server instance. Can be either:
master, slave or none";
+ };
+
+ serverId = mkOption {
+ default = 1;
+ description = "Id of the MySQL server instance. This number must be
unique for each instance";
+ };
+
+ masterHost = mkOption {
+ description = "Hostname of the MySQL master server";
+ };
+
+ masterUser = mkOption {
+ description = "Username of the MySQL replication user";
+ };
+
+ masterPassword = mkOption {
+ description = "Password of the MySQL replication user";
+ };
+
+ masterPort = mkOption {
+ default = 3306;
+ description = "Port number on which the MySQL master server runs";
+ };
+ };
+ };
+
+ };
+
+
+ ###### implementation
+
+ config = mkIf config.services.mysql55.enable {
+
+ users.extraUsers = singleton
+ { name = "mysql";
+ description = "MySQL server user";
+ };
+
+ environment.systemPackages = [mysql];
+
+ jobs.mysql =
+ { description = "MySQL server";
+
+ startOn = "filesystem";
+
+ preStart =
+ ''
+ if ! test -e ${cfg.dataDir}/mysql; then
+ mkdir -m 0700 -p ${cfg.dataDir}
+ chown -R ${cfg.user} ${cfg.dataDir}
+ ${mysql}/bin/mysql_install_db ${mysqldOptions}
+ touch /tmp/mysql_init
+ fi
+
+ mkdir -m 0700 -p ${cfg.pidDir}
+ chown -R ${cfg.user} ${cfg.pidDir}
+
+ ${mysql}/bin/mysqld --defaults-extra-file=${myCnf}
${mysqldOptions} &
+
+ # Wait until the MySQL server is available for use
+ count=0
+ while [ ! -e /tmp/mysql.sock ]
+ do
+ if [ $count -eq 30 ]
+ then
+ echo "Tried 30 times, giving up..."
+ exit 1
+ fi
+
+ echo "MySQL daemon not yet started. Waiting for 1 second..."
+ count=$((count++))
+ sleep 1
+ done
+
+ if [ -f /tmp/mysql_init ]
+ then
+ ${concatMapStrings (database:
+ ''
+ # Create initial databases
+ if ! test -e "${cfg.dataDir}/${database.name}"; then
+ echo "Creating initial database: ${database.name}"
+ ( echo "create database ${database.name};"
+ echo "use ${database.name};"
+
+ if [ -f "${database.schema}" ]
+ then
+ cat ${database.schema}
+ elif [ -d "${database.schema}" ]
+ then
+ cat ${database.schema}/mysql-databases/*.sql
+ fi
+ ) | ${mysql}/bin/mysql -u root -N
+ fi
+ '') cfg.initialDatabases}
+
+ ${optionalString (cfg.replication.role == "slave")
+ ''
+ # Set up the replication master
+
+ ( echo "stop slave;"
+ echo "change master to
master_host='${cfg.replication.masterHost}',
master_user='${cfg.replication.masterUser}',
master_password='${cfg.replication.masterPassword}';"
+ echo "start slave;"
+ ) | ${mysql}/bin/mysql -u root -N
+ ''}
+
+ ${optionalString (cfg.initialScript != null)
+ ''
+ # Execute initial script
+ cat ${cfg.initialScript} | ${mysql}/bin/mysql -u root -N
+ ''}
+
+ ${optionalString (cfg.rootPassword != null)
+ ''
+ # Change root password
+
+ ( echo "use mysql;"
+ echo "update user set Password=password('$(cat
${cfg.rootPassword})') where User='root';"
+ echo "flush privileges;"
+ ) | ${mysql}/bin/mysql -u root -N
+ ''}
+
+ rm /tmp/mysql_init
+ fi
+ '';
+
+ postStop = "${mysql}/bin/mysqladmin ${optionalString (cfg.rootPassword
!= null) "--user=root --password=\"$(cat ${cfg.rootPassword})\""} shutdown";
+
+ # !!! Need a postStart script to wait until mysqld is ready to
+ # accept connections.
+
+ extraConfig = "kill timeout 60";
+ };
+
+ };
+
+}
_______________________________________________
nix-commits mailing list
[email protected]
http://lists.science.uu.nl/mailman/listinfo/nix-commits
