In our earlier articles we have discussed about 5G. There is a practical need to know whether 5G network going to be available in the next year. According to the official news, 5G shall be available to users at affordable prices starting from 2021. So, we can comfortably say that most of the users do not need a 5G set in the next year. It does mean - we should avoid purchasing present top-model 4G … [Read more...]
WordPress MySQL Replication With HyperDB
In our earlier guides, we have discussed about Standalone Database and Distributed Database, shown MySQL Configuration to Set Up Master-Slave Replication. Here is the required setup and settings to make WordPress use master/slave MySQL database with replication fully working. The total set of articles will make your WordPress setup far more advanced and fail proof. Obviously, like anything it will … [Read more...]
MySQL Configuration to Set Up Master-Slave Replication
Our Use-Case of Master-Slave Replication is For WordPress. Master-Slave Replication For WordPress Makes it Fail-Proof to WordPress Database Errors Making the Website Fully Unreadable (which we have discussed in our article on Difference Between Standalone Database and Distributed Database). The main reason for so much discussion is for one big reason - the master MySQL database will read and write … [Read more...]
How to Install Percona XtraBackup on Ubuntu Server
To follow this guide, ideally you should have Percona MySQL installed and configured in the way we described in our linked guide. But Percona XtraBackup supports all MySQL flavours like Percona Server, MariaDB, and the original MySQL from Oracle. You must apply the fixes to resolve problems such as Debian distro-specific automatic restart issues. If the server you are going to work is of live … [Read more...]
Difference Between Standalone Database and Distributed Database
The obvious difference between the two is the number of servers. The standalone database requires one server while distributed databases require multiple servers (at least two). In the case of one-node (or one-server) centralized databases, all data are managed by a single DBMS. That is the common setup for almost everything from web software like WordPress to analytical software. Data consistency … [Read more...]
How to Install InfluxDB on Ubuntu Server
InfluxDB is a time series database written in the Golang programming language. It is easy to install for use in specific purposes, use SQL-like query language. It supports HTTP API, also can use InfluxDB to store metrics of our Internet of Things (IoT) projects. InfluxDB is optimized for fast, high-availability storage and retrieval of time series data in fields. It supports processing data from … [Read more...]
Connect Android CLI (Termux) to IBM Watson IoT Like Raspberry Pi
Android smartphones can be made to partially work like Raspberry Pi like single board computers. That is probably useful for different reasons. To follow the steps of this guide, you need to read our previous guide for the basic setup with Termux. Although in that guide, we mainly focused on how to use Node-RED, there are is the installation of termux-api and some useful links. Any Android device … [Read more...]
What is Time Series Database (TSDB)?
The time-series database systems provide various features based on time such as calculating at a high speed, executing query analysis from continuous values. Time-series databases are associated with industrial applications. They can store values from sensors. Compression algorithms may be used to manage the data. The design of these time series systems uses time as a key index which makes the … [Read more...]
Avoiding Landing Page Failure
Landing pages are said to be one of the most prominent and yet easy to implement online marketing tool. The concept enthusiasts at every possible opportunity quote its numerous benefits such as: increasing conversion rate, getting insights about visitors, getting attention of customers quickly, building trust, speeding up decision making process. Frankly speaking … [Read more...]
Difference Between a USB Type-C and a Micro-USB Connector
USB-C Connector (USB Type-C is the official name) Increasingly Being Used in Modern Smartphones and Other Computing Devices. USB-C is not like the classic USB connectors (including the microUSB and MiniUSB connectors). USB came as a replacement for the large connectors to replace the serial ports, parallel ports, the port for PC mouse and keyboards. USB Type B was designed for the larger, … [Read more...]
How to Use Android Smartphone as IoT Device (Termux, Node-RED)
We can use any modern Android Smartphone something like a Raspberry Pi with a camera, all the sensors & send the collection to any IoT platform. Although it will sound like a complex work it is easy because of a lot of development by many hundreds of developers. There are ready to use Android applications which does the similar job from GUI and connect with IoT platform like IBM Watson IoT … [Read more...]