In this tutorial, we will show you how to create a backup of MySQL databases on an Ubuntu 20.04 VPS, ...
The post How to Create a Backup of MySQL Databases Using mysqldump on Ubuntu 20.04 appeared first on RoseHosting.
Jul
17
2020
May
07
2020
This tutorial shows how you can install Nginx on an Ubuntu 20.04 LTS server with PHP 7.4 support (through PHP-FPM) and MySQL support (LEMP = Linux + Nginx (pronounced "engine x") + MySQL + PHP).
Jan
03
2020
Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It’s also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and performance. This is usually done through monitoring software and tools either built-in to the database management software or installed from third-party providers.
Prometheus is an open-source software application used for event monitoring and alerting. It can be used along with a visualization tool like Grafana to easily create and edit dashboards, query, visualize, alert on, and understand your metrics. ScaleGrid provides full admin access to your MySQL deployments – this makes it …
[Read more]
Jun
03
2019
So the issue of max_connections dropping from the value set in
your my.cnf file down to 214 has been around for a little while
on Ubuntu.
As an example, it was noted here back in 2015
I ran into this again recently and was resolved with the
following steps.
# cp /lib/systemd/system/mysql.service
/etc/systemd/system/
# cd /etc/systemd/system/
# vi mysql.service
LimitNOFILE=infinity
LimitMEMLOCK=infinity
# systemctl daemon-reload
# systemctl restart mysql
Once those steps completed the MySQL connections were stable at
the given parameter in the my.cnf file.
Apr
05
2019
This tutorial shows how you can install Nginx on an Ubuntu 18.04 LTS server with PHP 7.2 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP).
Mar
06
2019
In this guide, we're going to show you how to Dockerize the Laravel project with PHP-FPM, MySQL database, and the Nginx web server using the Docker Compose on the Ubuntu Server 18.04. We're going to create a new docker image for the Laravel Project, and then create the docker-compose.yml script that contains some services including, the App/Laravel itself, Nginx web server, and MySQL database.
Feb
28
2019
The LEMP stack is a web development platform for hosting static and dynamic websites. It is a combination of free ...
The post How to Install LEMP on Ubuntu 18.04 appeared first on RoseHosting.
Feb
20
2019
In this tutorial, we will show you how to install and improve the security of MySQL on Ubuntu 18.04. MySQL ...
The post How to Install MySQL on Ubuntu 18.04 appeared first on RoseHosting.
Jul
16
2018
This tutorial shows the steps to install an Ubuntu 18.04 (Bionic Beaver) server with Nginx, PHP, MariaDB, Postfix, pure-ftpd, BIND, Dovecot and ISPConfig 3.1. ISPConfig is a web hosting control panel that allows you to configure the installed services through a web browser. This setup provides a full hosting server with web, email (inc. spam and antivirus filter), Database, FTP and DNS services.
Jul
11
2018
Ever since AMD released their EPYC CPU for servers I wanted to test it, but I did not have the opportunity until recently, when Packet.net started offering bare metal servers for a reasonable price. So I started a couple of instances to test Percona Server for MySQL under this CPU. In this benchmark, I discovered some interesting discrepancies in performance between AMD and Intel CPUs when running under systemd .
The set up
To test CPU performance, I used a read-only in-memory sysbench OLTP benchmark, as it burns CPU cycles and no IO is performed by Percona Server.
For this benchmark I used Packet.net c2.medium.x86 instances powered by AMD EPYC …
[Read more]