Installieren und Verwenden von ClickHouse auf Debian 10
Der Autor hat den Free and Open Source Fund dazu ausgewählt, eine Spende im Rahmen des Programms Write for DOnations zu erhalten. ClickHouse ist eine…
How To Install MariaDB on Ubuntu 18.04
MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement for MySQL. This tutorial will explain how to install MariaDB on an Ubuntu 18.04 server, and verify that it is running and has a safe initial configuration.
How to Use Full-Text Search in PostgreSQL on Ubuntu 16.04
In this tutorial, we’ll use PostgreSQL to store data containing articles for a hypothetical news website, then learn how to query the database using FTS and select only the best matches. As the final step, we will explore the available types of indexes in PostgreSQL which can be used to significantly improve performance of the full-text search queries.
How To Configure a Galera Cluster with MariaDB on Debian 10 Servers
In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three Debian 10 Droplets that will act as nodes in the cluster. MariaDB is an open source relational database system that is fully compatible with the popular MySQL RDBMS system. Galera is a database clustering solution that enables you to set up multi-master clusters using synchronous replication.
How To Use Stored Procedures in MySQL
MySQL supports the use of stored procedures, which group one or multiple SQL statements for reuse under a common name. Using stored procedures, you can create reusable routines for common tasks to be used across multiple applications, provide data validation, or deliver an additional layer of data access security. In this tutorial, you’ll learn what stored procedures are and how to create basic stored procedures that return data and use both input and output parameters.
How To Install MySQL on CentOS
MySQL is an open-source database management system. CentOS prefers MariaDB by default, a fork of MySQL managed by the original MySQL developers and designed as a replacement for MySQL. Unless you have a specific use-case for MySQL, see the [How To Install MariaDB on CentOS](https://www.progressiverobot.com/how-to-install-mariadb-on-centos-7/) guide.
Установка и использование ClickHouse на Debian 10
Автор выбрал фонд Free and Open Source Fund для получения пожертвования в рамках программы Write for DOnations. ClickHouse — это столбцовая аналитическая база данных с…
Como usar a extensão PHP PDO para realizar transações do MySQL em PHP no Ubuntu 18.04
O autor selecionou a Open Sourcing Mental Illness para receber uma doação como parte do programa Write for DOnations. Uma transação de MySQL consiste em um grupo de comandos em SQL relacionados de…
Comment installer et utiliser Clickhouse sur Debian 10
L’auteur a choisi le Free and Open Source Fund pour recevoir une donation dans le cadre du programme Write for DOnations. ClickHouse est une base de données…
How To Import and Export Databases in MySQL or MariaDB
Learn how to import and export databases in MySQL or MariaDB using command-line tools like mysqldump. Backup and restore your data safely.
