aptitude update, apt-get update, apt update do the same job. Then what is the difference between them? We explained the basic of Advanced Packaging Tool (apt) and aptitude in the linked old article. Let us first discuss aptitude and apt-get. aptitude, apt-get and apt are front ends to dpkg. aptitude provides a terminal menu interface whereas apt-get does not. Using aptitude TUI as a normal user … [Read more...]
The MySQL Query Cache For Page Speed Optimization
You'll notice that our earlier guide on MySQL optimization disabled MySQL Query Cache. Various WordPress Plugins exist for database caching, which are different from the thing we are talking about. Our discussion demands to tweak my.cnf file which is usually located at /etc/my.cnf in case of Ubuntu, Debian etc distro. The WordPress plugins decrease the count of queries to the database by caching … [Read more...]
How to Install Apache Druid (Single Server)
Apache Druid is a column oriented, analytics database which can be used to build a data warehouse. Druid has APIs (via HTTP and JDBC) for loading, managing, and querying data and the user can also interact with Druid via the console. A mere 4GB RAM of an instance or computer is sufficient to test-run nano-quickstart configuration of Druid, and 16GB RAM instance can run it at production. Druid can … [Read more...]
MySQL Performance Tuning For WordPress (Percona MySQL)
Optimizing MySQL for WordPress running on Virtual Server is not exactly easy. There is no way to predict how the hardware will behave. Most of us deliver optimization tips for the dedicated servers. I saw that cloud server from Rackspace, HP Cloud and IBM Cloud are like dedicated servers. Often for one server setup, we end up with some compromise. If you are using cloud server, then after trial … [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...]
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...]
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...]
MongoDB versus MySQL
MySQL is the most popular relational database which is free to use. It is normal for many of the MySQL users to think - why we will learn MongoDB or any noSQL? Typically, MongoDB is for a different type of applications to meet today's need. You can think the visitor tracking plugin for your WordPress website using MongoDB. It is not a good use-case of MongoDB, but probably points where MongoDB can … [Read more...]