This article covers how to allow remote connections to a MySQL server. Hosting databases and web servers on a separate database server can improve security, hardware performance, and enable you to scale resources quickly.
One of the most frequently observed database bottlenecks encountered by large projects is high MySQL traffic. Sure, we could talk about moving to a bigger cloud instance size, faster cores, and better storage, but that’s too obvious and costly. Instead, we would like to focus on several tips that can reduce traffic with a bit of configuration.
Methods to reduce Internet traffic when connecting to the remote host:
- Disable and/or optimize the high-load features of your application.
- Use ProxySQL to enable connection pooling. This will prevent your application from overloading MySQL with a multitude of concurrent connections. Another nice feature of ProxySQL helps cache query results for a certain period of time.
- Monitor your databases for performance bottlenecks.
- Identify and optimize queries that cause high load. If you use dbForge Studio for MySQL, you get a specialized tool—Query Profiler—which helps you deal with this task easily.
- Add missing indexes and eliminate redundant and unused ones.
- Conduct a thorough check of your background operations. Some of them can be postponed, some may work just as effectively with limited resources (e.g. limited concurrencies for batch jobs), and some may be perfectly running on replicas.
This article covers how to use screen commands in ubuntu 20.04. Screen or GNU Screen is a terminal multiplexer. In other words, it means that you can start a screen session and then open any number of windows (virtual terminals) inside that session. Processes running in Screen will continue to run when their window is not visible even if you get disconnected.
How to Install Linux GNU Screen on Ubuntu ?
1. Check if it is installed on your system by typing:
$ screen --version2. If you don't have screen installed on your system, you can easily install it using the package manager of your distro.
Install Linux Screen on Ubuntu and Debian:
$ sudo apt update
$ sudo apt install screen3. To Install Linux Screen on CentOS and Fedora:
$ sudo yum install screen4. To start a screen session, simply type screen in your console:
$ screenMost common commands for managing Linux Screen Windows:
- Ctrl+a c Create a new window (with shell).
- Ctrl+a " List all windows.
- Ctrl+a 0 Switch to window 0 (by number).
- Ctrl+a A Rename the current window.
- Ctrl+a S Split current region horizontally into two regions.
- Ctrl+a | Split current region vertically into two regions.
- Ctrl+a tab Switch the input focus to the next region.
- Ctrl+a Ctrl+a Toggle between the current and previous windows
- Ctrl+a Q Close all regions but the current one.
- Ctrl+a X Close the current region.
Here is a complete guide on how to configure the DNS caching-only server on CentOS 8.
Here, you will learn how to install and configure a DNS Server on CentOS 8 machine.
More Linux Tutorials
We create Linux HowTos and Tutorials for Sys Admins. Visit us on IbmiMedia.com
Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com
