| layout | title |
|---|---|
default |
Database Setup |
This guide will help you setup databases and data-related services for your project. Every build is executed in its very own virtual machine that comes pre-installed with the following:
SQLite3 comes pre-installed.
MySQL is configured to start automatically at address 127.0.0.1, port 3306, username root and blank password.
Example command to create a database:
mysql -u root -e 'create database test;'
Example command to load a SQL file and generate your schema:
mysql -u root -D test < schema.sql
Postgres is configured to start automatically at address 127.0.0.1, port 5432, username postgres and no password.
Example command to create a database:
psql -c 'create database test;' -U postgres
Mongodb must be started manually, as part of your build script. You can start Mongodb by executing the following command:
sudo start mongodb
sleep 10
Redis must be started manually, as part of your build script. You can start Redis by executing the following command:
sudo start redis
sleep 10
Memcahce is configured to start automatically at address 127.0.0.1 and port 11211 using default configurations.
Neo4j must be started manually, as part of your build script. You can start Neo4j by executing the following command:
neo4j start
sleep 5
Elastic Search must be started manually, as part of your build script. You can start Elastic Search by executing the following command:
sudo start elasticsearch
sleep 5
CouchDB must be started manually, as part of your build script. You can start CouchDB by executing the following command:
sudo /etc/init.d/couchdb start
sleep 5