In 2012, we published some guides on VNC Remote Desktop and clientless remote desktop with Guacamole. Presently, we can avoid VNC (Virtual Network Computing) and use X2Go to create an XFCE desktop environment. X2Go is a remote desktop software for GNU/Linux which uses a modified NX3 protocol. NX compresses the X11 data to minimize the amount of data transmitted, and caches data to keep the … [Read more...]
Install/Renew SSL Cert on Apache (2020 Cipher Suites)
Those who are following us since many years know that we publish the updated server guides enough for a newbie to build and run a professional-grade quality. Renew and getting a new (paid) SSL certificate has little difference except - you may use the old CSR, Private Key and the intermediate certificate. Reusing the old CSR, Private Key and the intermediate certificate will not extremely weaken … [Read more...]
How To Install PHP 7.4 on Ubuntu Server
PHP 7.4 is a new minor version of PHP with some breaking changes. While installing PHP 7.4 for my new website abhishekghosh.com I noticed that some packages do need careful installation. Overall our main guide on how to install PHP 7.2 on Ubuntu 18.04 LTS server should work fine for setup of a LAMP server for installation of PHP-MySQL web software like WordPress. The new features are written on … [Read more...]
How to Install Gradle on Debian
Gradle is a build tool primarily used for Java projects. Gradle combines the features of Ant and Maven. Gradle uses Groovy, which is a dynamic, object-oriented programming language for the Java platform to define the project and build scripts. Java is one of the most popular programming languages used to build different kinds of applications and systems. Applications developed in Java are scalable … [Read more...]
aptitude vs apt-get vs apt
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...]
- « Previous Page
- 1
- 2
- 3
- 4
- …
- 12
- Next Page »