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...]
Cloud Computing
Cloud computing is becoming more and more important. Here are articles on Cloud Computing,Cloud Server,SaaS,PaaS,IaaS and Cloud related technology.
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...]
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...]
Difference Between Apache Solr and Apache Lucene
One user have installation guide for Apache Solr but we do not have guide for Apache Lucene. It is kind of deliberate omission. There is an easy way to use Lucence on the command line. In most of the situations possibly you'll use Apache Solr and when you'll realize the need to utilize Apache Lucene, then you'll not need our help on installation. Solr is based on a Java library which is known as … [Read more...]
How to Install CockroachDB on Ubuntu Server
CockroachDB is an Open Source NewSQL DBMS. If you are new to the NewSQL world - CockroachDB can run on Raspberry Pi to large cluster of servers. Distributed Online Transaction Processing (OLTP) is one of the widely known use case of CockroachDB. CockroachDB is an interesting DBMS. It uses PostgreSQL protocol and you'll feel to find some MySQL syntax. It has good things of both RDBMS and NoSQL. It … [Read more...]
Review of 101Domain For E-commerce
In a past article on ICANN's new domain name transfer policy, we mentioned 101domain as one of a few other service providers. After that article our readers asked us to know more about their total set of services. What attracted us to 101domain is their insightful blog on technical matters around domains, SSL, and corporate brand services. The articles on their blog demonstrate carefulness around … [Read more...]
MySQL Versus NewSQL
From our article What is NewSQL, a question possibly will come in mind - MySQL with InnoDB engine is also coming under the classification of NewSQL. Then why we need to think, learn, use the new software such as Google Spanner, Clustrix, NuoDB, TransLattice? NewSQL is the latest implementation of relational databases. Traditional relational databases including MySQL with MyISAM engine were … [Read more...]
How to Package and Run Apache Twill (on Hadoop YARN)
YARN stands for Yet Another Resource Negotiator. YARN is a cluster management technology since Hadoop 2.0. YARN is being extensively used for writing applications by Hadoop Developers. Most of the readers of this website are beginners around big data. For that reason, we point towards the basic theoretical articles such as differences between batch processing and stream processing, differences … [Read more...]
How to Install Apache Crunch (on Hadoop)
By now, we know the differences between batch processing and stream processing, differences between Hadoop and Spark. Here are the steps to install the Apache Crunch on Hadoop. Crunch is used to creating pipelines that are composed of many user-defined functions. Crunch can run with Hadoop MapReduce and Apache Spark. Apache Crunch library is for tasks which are difficult to implement with just … [Read more...]