Databases Checkpoint
This checkpoint is intended to help you assess what you learned from our introductory articles to Databases, where we defined databases and introduced common database management systems.
Deploy Coreflux MQTT Broker with Managed Databases
Deploy Coreflux MQTT broker with PostgreSQL, MongoDB, MySQL, or OpenSearch on the cloud provider for IoT automation
How To Install and Use Memcache on Ubuntu 14.04
Memcached is an in-memory key-value cache that can be used to temporarily cache frequently requested data on websites. In this guide, we will demonstrate how to install and use memcached on an Ubuntu 14.04 server.
How to Allow MySQL Remote Access Securely (2025 Guide)
Learn how to allow MySQL remote access safely: bind to a private IP, lock down port 3306 with firewalls, create least-privilege users, enable SSL/TLS, and use AI-assisted audits to prevent misconfigurations.
How To Install MySQL on Ubuntu 16.04
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data.
How to Change a MySQL Data Directory to a New Location on CentOS 7
Databases grow over time, sometimes outgrowing the space on the file system. You can also run into I/O contention when they’re located on the same partition as the rest of the operating system. RAID, network block storage, and other devices can offer redundancy and other…
Установка WordPress с помощью Docker Compose
WordPress — бесплатная система управления контентом (CMS) с открытым исходным кодом, которая опирается на базу данных…
How To Use Triggers in MySQL
When working with relational databases and SQL, most operations on the data are performed as a result of explicitly executed queries, such as SELECT, INSERT, or UPDATE. However, SQL databases can also be instructed to perform pre-defined actions automatically every time a specific event occurs through triggers. In this tutorial, you’ll use different SQL triggers to automatically perform actions where rows are inserted, updated, or deleted.
Installieren von MySQL unter Ubuntu 20.04
Eine frühere Version dieses Tutorials wurde von Hazel Virdó verfasst. MySQL ist ein Open-Source-basiertes Datenbank-Managementsystem, das üblicherweise als Teil des beliebten…
How To Optimize MySQL with Query Cache on Ubuntu 18.04
Query cache is a prominent MySQL feature that speeds up data retrieval from a database. In this tutorial, you will first configure MySQL without query cache and run queries to see the duration results. Then you’ll set up query cache and test your MySQL server with it enabled to show the difference in performance.
