How To Set Up Laravel, Nginx, and MySQL with Docker Compose
O autor selecionou A FreeBSD Foundation para receber uma doação como parte do programa Write for DOnations. Ao longo dos últimos anos, o Docker…
How To Use Foreign Keys in SQL
When working on a large SQL project, you must maintain the accuracy and consistency of data across all tables using foreign keys. This is where referential integrity comes into play. Referential integrity ensures all data references are valid in SQL and prevents inconsistent entries or orphaned records. In this tutorial, you’ll enforce referential integrity with foreign keys on your database.
How To Use the LAMP 1-Click Install on the cloud provider
LAMP stack is a solution stack that employs a specific group of software to host web applications on a server. This term is an acronym which represents the Linux operating system with the Apache web server. The site data is stored in a MySQL database, and dynamic content is processed by PHP. This tutorial will guide you through spinning up a cloud servers with LAMP stack pre-installed, using the the cloud provider LAMP 1-Click App.
Installing and Configuring Bacula on an Ubuntu 12.04 VPS
In this article, we will install and configure Bacula on an Ubuntu 12.04 Virtual Private Server instance. Bacula is a powerful backup solution that offers flexibility and scaleability by relying on a client-server model.
SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems
This article compares and contrasts three of the most widely implemented open-source RDBMSs: SQLite, MySQL, and PostgreSQL. Specifically, it explores the data types that each RDBMS uses, their advantages and disadvantages, and situations where they are best optimized.
¿Cómo Instalar Linux, Nginx, MySQL, PHP (LEMP stack) in Ubuntu 16.04?
LEMP es un grupo de software que se puede utilizar para servir páginas web dinámicas y aplicaciones web. Este es un acrónimo que describe un sistema operativo Linux, con un servidor web Nginx. Los datos del backend se almacenan en la base de datos MySQL y el procesamiento…
How To Add NoSQL Queries to MySQL with memcached on Ubuntu 14.04
Memcached as a standalone server works as an intermediary in front of the MySQL client access layer and manages information only in the memory without an option to store it persistently. This makes it suitable for tasks such as caching the results of duplicate MySQL queries. In this article, memcached will be installed as a MySQL plugin and tightly integrated into MySQL. It will provide a NoSQL style access layer for managing information directly in regular MySQL InnoDB tables.
How To Configure a Galera Cluster with MySQL 5.6 on Ubuntu 16.04
Clustering adds high availability to your database by distributing changes to different servers. In the event that one of the instances fails, others are already available to continue serving. Clusters come in two general…
How To Create a Multi-Node MySQL Cluster on Ubuntu 16.04
MySQL cluster is a software technology which provides high availability and throughput. In short, there is one or more management nodes which control the data nodes (where data is stored). After consulting with the management node, clients (MySQL clients, servers, or native APIs) connect directly to the data nodes.
How To Deploy Elixir-Phoenix Applications with MySQL on Ubuntu 16.04
In the tutorial How to Automate Elixir Phoenix Deployment with Distillery and edeliver, you created a Phoenix application without a…
