InnoDB is currently the default storage engine for MySQL and is recommended for most use cases. The company behind it was acquired by Oracle Systems a number of years ago, and the software is known in particular for being a transaction-safe storage engine. In this article, we’re going to look at some of the features of InnoDB and how it’s different from MyISAM, the previous software.
Apache Cassandra is a column-oriented database management system based on NoSQL. It offers options for horizontal scaling so that you can add any number of individual nodes. Cassandra was originally developed for Facebook, but it is now used by many social networks and scientific institutions that manage large amounts of data. In the following article, we’ll introduce you to this system.
ERR_CERT_COMMON_NAME_INVALID is an error message shown by Chrome when there are problems with a website’s security certificate. This error message prevents you from accidentally visiting an unsafe website and it keeps visitors safe from third parties trying to steal their data. Here is how to fix the error with different methods.
The Auth Code (short for Authorisation Code) or AuthInfo Code is required when you want to move your domain to another provider. By requesting the code, the new provider can ensure that you are the registered user of the domain. It is crucial that you keep this information private. The Auth Code is the key to your domain.
When it comes to running and managing a Database Management System, synchronising all the interlinked databases is one of the most important and one of the most laborious tasks. However, if you use MariaDB, the Galera Cluster software for Linux can help with this task. It works by distributing database transactions to all the specified servers in real time, optimising use of resources in the...
Working with this in-memory database is not that difficult, but without an easily understandable Redis tutorial, one can quickly become discouraged. Here you will learn how to install the database, configure it, and enter data. We will also show you how to add, get, and delete data step by step.
The open-source database management system InfluxDB manages and visualises data from time series databases, in which thousands of data sets from Internet of Things (IoT) devices or sensors are captured in a constant stream of time-stamped data. The current version 2.0 runs as a cloud service with its own user interface and is written in the new scripting, and query language, Flux.
At some point, you’ll undoubtedly have been prompted to “clear your cache.” But what exactly does it mean? What does this intermediate storage do, and why should it be cleared at all? Read this article to find out how a cache works, what tasks it performs, and much more on the topic – explained simply with helpful examples.
When a web project is growing and the user rates are beginning to skyrocket, some web servers may quickly become overworked when it comes to dispatching requested content. A hardware upgrade may seem like the only option, but this can be an expensive undertaking. Varnish hosting offers an affordable alternative. But despite the excellent performance it delivers, the software still has its...
Converting the MySQL extension to MySQLi led to some uncertainty in the PHP community since some of the industry’s heavyweights like WordPress continued to rely on the old extension despite it being deprecated. However, as of PHP 7, this extension is no longer available. In this article, we will go over its successor in detail and present examples which highlight the differences between the two...