Tag: MySQL
Check our vast MySQL tutorials, we have how to's that range from the basics, from setting up a user to advance topics like how to index your database.
How to Install and Configure Zabbix on Ubuntu 20.04
Introduction
Zabbix is an open-sourced tool used to monitor various IT components such as servers and hardware that they are running, cloud services, whole networks, etc. Zabbix can monitor the network health and integrity of your servers. All monitoring can be done through Zabbix’s web-based frontend. This means that you can quickly check the status of your servers from anywhere! This article describes how to install the Zabbix monitoring tool, create a database, and configure the frontend on Ubuntu 20.04.
What is a Time Series Database?
Introduction
We might be unaware of this fact, but we use time series databases all the time. They will become even more relevant as the Internet of Things (IoT) and other revolutionary technologies continue to develop. In this article, we will review what a time series database is, what its purpose, and their impact on our daily lives.
How to Install and Configure ClickHouse on Ubuntu 20.04
What is ClickHouse?
ClickHouse is an open-source column-oriented DBMS (or database management system) primarily used for OLAP (or the Online Analytical Processing of queries). It is capable of blazing fast generation of real-time analytical data and reporting utilizing SQL queries. It is fault tolerant, scalable, highly reliable and contains a feature rich tool set.
How to Install ArangoDB on Ubuntu 20.04
What is ArangoDB?
ArangoDB is a high availability and scalable multi-model NoSQL database that natively works with graphs and documents and includes a full-text search. It is a free, open-source software developed and maintained by ArangoDB GmbH. The system supports three different data models with one database core and includes a unified query language called AQL (ArangoDB Query Language). This query language is declarative and allows the combination of different data access patterns in a single query. The software can be implemented on multiple systems, including Windows, macOS, Linux, Kubernetes, Docker, and on our Managed Cloud. It has a strong community support base on GitHub, StackOverflow, Google Groups, and Slack.
How to Install Neo4j on Ubuntu 20.04
Introduction
In this tutorial, we will examine what Neo4j is, what it is used for, and how it is implemented. We will also install and configure the installation on an Ubuntu 20.04 server. Neo4j is a graphical database used to create data relationships. Other examples of graphical databases include:
How to Install MongoDB on CentOS 8
What is MongoDB?
MongoDB is a documented database management system that does not require the description of a table scheme. It is representative of a NoSQL based system (NoSQL is an approach to implement a scalable database storage system within a flexible data model), which uses JSON like documents and database schemas often used in web development. It is written in C, C++, JavaScript, and since it is cross-platform, it allows one to deploy it on any platform.
What is MongoDB?
MongoDB is a documented database management system that does not require the description of the table scheme. It is an example of NoSQL systems (NoSQL - this is an approach to implement scalable db storage with a flexible data model), MongoDB uses JSON like documents and a database scheme. It is often used in web-development along with Big data. MongoDB is written in C++, C, and JavaScript. It is also cross-platform, which lets us deploy it on multiple platforms.
MySQL Performance: How To Leverage MySQL Database Indexing
Throughout this tutorial, we will cover some of the fundamentals of indexing. As part of the MySQL series, we will introduce capabilities of MySQL indexing and the role it plays in optimizing database performance. Liquid Web recommends consulting with a DBA before making any changes to your production level application.
Connecting to MySQL Using Python
In this article, we will be discussing how to connect to MySQL using Python. Python is one of the most productive and widely used programming languages in use today. Its simple and elegant syntax makes it ideal for new programmers, while experienced programmers enjoy the extensive list of available modules and functionalities.
MySQL Performance: Identifying Long Queries
Every MySQL backed application can benefit from a finely tuned database server. The Liquid Web Heroic Support team has encountered numerous situations over the years when some minor adjustments have made a world of difference in website and application performance. In this series of articles, we have outlined some of the more common recommendations that have had the largest impact on performance.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.