After MySQL installation, If you don’t have any enterprise
level / any GUI interface for monitoring, backup then one of the
option is, write your own scripts to automate these tasks.
In this Blog post, we are going to see few monitoring and backup
scripts with covering common security issues.
Credential security
Following is a simple script, which will monitor MySQL service. In case MySQL …
[Read more]How to solve mysqld service restart problem for above error?
Problem :
I was adding shell and home directory for mysql user,executed
following cmd,
shell> usermod -m -d /home/mysql -s /bin/bash mysql
If mysql is running and process running with mysql , we
need to stop mysql otherwise it will throw an error like
usermod: user mysql is currently used by process
27768
After stopping MySQL service and adding shell and homedir for mysql user, at the time mysqld service startup it started throwing error.
shell> service mysqld restart Redirecting to /bin/systemctl restart mysqld.service Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. Shell> systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded …[Read more]
Over the recent years, there has been a large number of individuals as well as organizations who are ditching the Windows platform for Linux platform, and this number will continue to grow as more developments in Linux are experienced. Linux has for long been the leader in Web servers as most of the web servers run on Linux, and this could be one of the reasons why the high migration is being experienced.
MySQL 5.7 improved as compare to previous releases in terms of transnational capabilities, performance with high load, high Availability, Security and it’s defaults.
Check my blog post : MySQL 5.7 features
This blog post will describe End to End implementation of MySQL on Linux distributions Which will cover MySQL Installation, configuration and administration in production environment with proper configuration. So you can start using your application by implementing following setup and in future you can change it if requires.
[Read more]In this blog we are going to share my recent experience with an issue which we faced during migration between two Ubuntu servers.
The activity was pretty simple, the client had bought a new machine with enhanced memory and faster disk, so the data has to be transferred to the new server and live MySQL replication has to be configured between the old and the new server.
For the hot and live data transfer we used xtrabackup’s stream method, the data transfer happened smoothly without any issue.
Everything was set and we had applied the log and followed the normal procedure to change the ownership of datadir to “mysql” and all the entries in the my.cnf were double checked.
When we intended to start mysql, the service didn’t come up instead we had a weird error as below.
MySQL Error:
——————
2016-08-31 22:35:27 9938 [ERROR] InnoDB: ./ibdata1 can't be opened in …[Read more]
The behavior of vm.swappiness was always a bit confusing for novice linux users, as setting vm.swappiness to 0 would not completely disable swapping in the system during a memory crunch. vm.swappiness would only affect the agressiveness of swapping.
Following upstream commit tried to give more control to parameter. This commit tried to avoid swapping completely when vm.swappiness is set to 0.
commit fe35004fbf9eaf67482b074a2e032abb9c89b1dd
Author: Satoru Moriya
Date: Tue May 29 15:06:47 2012 -0700
mm: avoid swapping out with swappiness==0
With above commit, setting vm.swappiness to “0” instructs the
kernel not to initiate swapping until the amount of free and
file-backed pages is less than the high water mark in a memory
zone. In other words, it tries to reclaim as much memory that can
be reclaimed, before swapping starts.
This greatly reduced the chances of swapping.
When this …
[Read more]This post is a continuance of my Docker series, and examines Running Percona XtraDB Cluster nodes with Linux Network namespaces on the same host.
In this blog I want to look into a lower-level building block: Linux Network Namespace.
The same as with cgroups, Docker uses Linux Network Namespace for resource isolation. I was looking into cgroup a year ago, and now I want to understand more about Network Namespace.
The goal is to both understand a bit more about Docker internals, and to see how we can provide network isolation for different processes within the same host. You might need to isolate process when running several MySQL or MongoDB instances on the same …
[Read more]This post shows you how to add the menu option and GUI to set users and groups. It’s quite a bit easier than mastering all the command-line syntax. It makes setting up the required user and group accounts for an Oracle Enterprise or MySQL database solution much easier.
You add the utility by calling the yum (Yellowdog Updater, Modified) utility like this:
yum installed -y system-config_users |
You should see the following:
Loaded plugins: langpacks adobe-linux-x86_64 | 951 B 00:00 ol7_UEKR3 | 1.2 kB 00:00 ol7_latest | 1.4 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package system-config-users.noarch 0:1.3.5-2.el7 will be installed --> Processing … |
This article consolidates information from several sources into the format I use to setup MySQL Master/Master Replication. The beauty of Linux and open source is that there are many different ways to do this. Please take a look at my references and use them to accommodate any needs you may have.
We’ve been learning for many years how to run Linux for databases, but over time we realized that many of our lessons learned apply to many other server workloads. Generally, server process will have to interact with network clients, access memory, do some storage operations and do some processing work – all under supervision of the kernel.
Unfortunately, from what I learned, there’re various problems in pretty much every area of server operation. By keeping the operational knowledge in narrow camps we did not help others. Finding out about these problems requires quite intimate understanding of how things work and slightly more than beginner kernel knowledge.
Many different choices could be made by doing empiric tests, sometimes with outcomes that guide or misguide direction for many years. In our work we try to understand the reasons behind differences that we observe in random poking at a problem.
In order …
[Read more]