https://wiki.csgalileo.org/ 2026-04-08T15:30:35+00:00 https://wiki.csgalileo.org/ https://wiki.csgalileo.org/_media/wiki/logo.png text/html 2016-12-17T18:41:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.csgalileo.org/tips/db/mariadb?rev=1482000103&do=diff mariadb cluster * <https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-10-1-on-ubuntu-16-04-servers> Three Ubuntu 16.04 servers install on each node apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 add-apt-repository 'deb [arch=amd64] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial main' apt update apt install mariadb-server rsync text/html 2016-08-12T08:50:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.csgalileo.org/tips/db/mssql?rev=1470991839&do=diff MSSQL * <http://stackoverflow.com/questions/15750711/connecting-to-sql-server-2012-using-sqlalchemy-and-pyodbc> * <https://blog.afoolishmanifesto.com/posts/install-and-configure-the-ms-odbc-driver-on-debian/> Install unixodbc version > 2.3.0 sudo apt-get remove libodbc1 unixodbc unixodbc-dev wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz tar zxvf unixODBC-2.3.4.tar.gz cd unixODBC-2.3.4/ ./configure --enable-gui=no --enable-drivers=no --enable-iconv --with-iconv-char-enc=U… text/html 2019-03-13T08:55:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.csgalileo.org/tips/db/postgres?rev=1552467336&do=diff Postgres Install container xenial 16.04 (optional) lxc image copy images:ubuntu/xenial/amd64 local: --alias xenial lxc launch xenial postgres lxc exec postgres bash sudo apt install postgresql eventually open network for remote connections listen_addresses = '*' text/html 2017-11-07T12:44:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.csgalileo.org/tips/db/redis?rev=1510058672&do=diff redis * from sql to redis * from mysql to redis string type string: store a value [integer, string, ...] belong a key [string] SET connections 10 INCR connections => 11 INCR connections => 12 DEL connections INCR connections => 1 expiring key SET resource:lock "Redis Demo" EXPIRE resource:lock 120