nixcraft

MySQL is a very fast, multi-threaded, multi-user and robust SQL database server. The latest version is located at /usr/ports/databases/mysql57-server/. MariaDB is a database server that offers drop-in replacement functionality for MySQL1. MariaDB is built by some of the original authors of MySQL, with assistance from the broader community of Free and open source software developers around the world. In addition to the core functionality of MySQL, MariaDB offers a rich set of feature enhancements including alternate storage engines, server optimizations, and patches. The latest version is located at /usr/ports/databases/mariadb55-server/. In this tutorial, you will learn how to install MariaDB server and create a databases, users, and grant sql rights using sql commands on a FreeBSD 10 or 11 server.

=> More info: How To Install MariaDB Databases on a FreeBSD v10/11 Unix Server

If you are getting this error then you probably reset the permissions on your keys:

chmod 0400 ~/.ssh/key
chmod 0700 ~/.ssh/
ssh -i ~/.ssh/key user@server



More info: Fixing ssh error.

Want to ignore SSL warning with curl command on Linux/Unix/MacOS? Try:

curl -k url
curl -k -I url

More info: cURL Ignore SSL Certificate Warnings

The Apache Accumulo database is an open source relaxed consistency database that is widely used for government applications. Accumulo is designed to deliver high performance on unstructured data such as graphs of network data. This paper tests the performance of Accumulo using data from the Graph500 benchmark. The Dynamic Distributed Dimensional Data Model (D4M) software is used to implement the benchmark on a 216-node cluster running the MIT SuperCloud software stack. A peak performance of over 100,000,000 database inserts per second was achieved which is 100x larger than the highest previously published value for any other database. The performance scales linearly with the number of ingest clients,
number of database servers, and data size. The performance was achieved by adapting several supercomputing techniques to this application: distributed arrays, domain decomposition, adaptive load balancing, and single-program-multiple-data programming.

Read More info here {PDF version}

More: Your cable management moment of zen here.

Run the following command:

ssh -t box screen -r
ssh -t box tmux a
ssh -t user@server screen -r
ssh -t user@server tmux a