Tag mysql

Various

PostgreSQL vs MySQL: A Comparison Of The Popular Database Management Systems

In the world of open-source relational database management systems, the undisputed champions vying for the top spot are MySQL and PostgreSQL. These relational DBMSs are renowned for both their resilience and the fact that they scale with ease, so let’s…

Elvis Plesky
January 9, 2022

Various

MySQL Performance: Identifying Long Queries

An optimized database server is key to ensuring that apps which rely on MySQL run efficiently. Sometimes all that’s needed to see website and application performance improvements are a few small adjustments, so in this article, we look at some…

Elvis Plesky
December 27, 2019

Various

NoSQL vs SQL: Examining the Differences and Deciding Which to Choose

At 74, Larry Ellison, co-founder and CTO of Oracle has amassed a fortune of $66.1 billion. He got going in 1966 and in the seventies took an idea from IBM’s Edgar F. Cobb for a SQL relational database. This became…

Elvis Plesky
May 16, 2019

Various

Manage MySQL databases from the command line

MySQL is one of the most popular relational database management systems. There are a variety of ways to manage a MySQL server – countless frontends including PhpMyAdmin, MySQL Workbench and even Adminer. However, clearly the most efficient way to manage…

Elvis Plesky
February 4, 2019

Product and technology

My Plesk User Experience (2): Lessons learned from testing Plesk Onyx

My Plesk user experience 2 - Plesk Onyx testing and analysis

So Plesk Onyx came along and it had implemented NGINX caching. Naturally I was curious and removed all my customizations. Then I started to compare the website performance with the inbuilt NGINX caching, other caching methods, and the Speed Kit…

Igor G
January 30, 2019
4 Comments

Product and technology

My Plesk User Experience (1): Easy Starts and Common Issues

Plesk User Experience While Testing Plesk Onyx

Plesk first crossed my path when it came packaged with web hosting acquired from a Russian provider. At the time it was version 12.0, but I never paid any attention to it until I discovered that part of its service…

Igor G
January 29, 2019

Product and technology

MySQL vs MariaDB – Can One Replace The Other?

With all MariaDB’s power under the hood, “MySQL vs MariaDB” was suddenly a legitimate topic of conversation. The two databases are so similar that MariaDB negates the need to upgrade mysql, because it can usually replace MySQL in a straight…

Elvis Plesky
October 4, 2018
6 Comments

Product and technology

MariaDB installation guide

Plesk uses MySQL as both admin and client RDBMS. Plesk 11.5 for Linux and higher allows for MySQL alternatives (such as MariaDB or Percona Server) to be used as drop-in replacements for it. Upgrade from installations with drop-in replacements is…