MySQL

How To Use Foreign Keys in SQL — step-by-step Linux tutorial on Progressive Robot

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.

Read more
How To Use the LAMP 1-Click Install on the cloud provider — step-by-step Linux tutorial on Progressive Robot

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.

Read more
How To Add NoSQL Queries to MySQL with memcached on Ubuntu 14.04 — step-by-step Linux tutorial on Progressive Robot

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.

Read more
How To Create a Multi-Node MySQL Cluster on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

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.

Read more
CHAT