Debian logo by Software in the Public Interest, Inc. (CC-BY-SA) MySQL and Debian 9 “Stretch” Debian 9 (“Stretch”) was released on June 17, and we congratulate the Debian community on another iteration of a central Linux distro. Now, the Debian release team some time ago decided not to ship MySQL as part of the distro, instead replacing it […]
10 Older Entries »
This tutorial explains how to setup and configure MySQL multi-master replication on Oracle Linux. Please note that even though the configuration is made under Oracle Linux, yet the steps and configuration are mainly the same to CentOS and Red Hat Linux.
In this blog post, we are going to test load balancer solution for MySQL high availability by integrating it with Keepalived, HAProxy, xinetd software components.
High availability databases use an architecture that is designed to continue to function normally even when there are hardware or network failures within the system.
Why we need this?
Let’s take a scenario where we have MySQL Multi-Master / MASTER-SLAVE replication setup for high availability. In the case of Hardware/Network failure on MASTER, In order to failover to a next available server, we need to manually do the configuration changes for client connections.In this case, downtime is expected since manual failover will take some times. To solve this we can integrate load balancer with MySQL to take care of this manual work and do automatic failover connections.
To avoid such downtimes and for the maximum high …[Read more]
In this tutorial, I will guide you how to install and configure the new stable MySQL 5.7 version on CentOS 7 server and Ubuntu 16.04 server. MySQL is an open source relational database management system developed by Oracle corporation. The source code is released under GNU General Public License.
via GIPHY I was just reading over StackOverflow’s 2017 Developer survey. As it turns out there were some surprising findings. Join 33,000 others and follow Sean Hull on twitter @hullsean. One that stood out was databases. In the media, one hears more and more about NoSQL databases like Cassandra, Dynamo & Firebase. Despite all that … Continue reading What engineering roles are most in demand at startups? →
Following are the few best practices and basic commands for MySQL Administration.
MySQL Access and credential security
shell> mysql -u testuser -pMyP@ss0rd
mysql: [Warning] Using a password on the command line interface can be insecure.
By looking at OS cmd’s history using history cmd other os users can see/get MySQL user password easily. It always good to not use a password on the command line interface. Another option for securing password while automating MySQL scripts is a use of mysql_config_editor. For more info on this check out my blog post about credential security.
Consider of having following implementation for Strong access policy.
- use of validate_password plugin for a strong password policy.
- Limit …
The EasyGUI library is a nice tool for developing GUI applications. It doesn’t require you to know event-driven programming to write basic GUI applications because it’s based on Python functions.
You can download and install the EasyGUI library with
yum utility like this:
yum install -y python-easygui
It should generate the following list:
Loaded plugins: langpacks, refresh-packagekit mysql-connectors-community | 2.5 kB 00:00 mysql-tools-community | 2.5 kB 00:00 mysql56-community | 2.5 kB 00:00 pgdg93 | 3.6 kB 00:00 updates/20/x86_64/metalink | 2.8 kB 00:00 Resolving Dependencies --> Running …[Read more]
As a part database administration, DBA has to take care of sub-components of database like server logs and has to plan for maintenance activity for these components regularly.
MySQL has various types of log i.e binary log, error log, slow query log, general log for different purposes. And after certain time these logs will grow and you will start seeing issues like low disk space, a large number of logs etc.
MySQL allows you to flush logs using flush logs command, next “How to rotate and clean up old MySQL logs? ”
Linux has a utility called “logrotate” , using logrotate we can implement log rotation for MySQL server logs.
Binary logs: This one is critical if you have replication setup, By enabling expire_logs_days mysql variable you can manage …[Read more]
MySQL is available for a huge variety of platforms, in a wide range of packaging formats and through many channels. Part of our mission is to keep up with the times by making sure that all MySQL products are available where people expect and need them to be. As part of that we have invested […]
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.
Following is a simple script, which will monitor MySQL service. In case MySQL …[Read more]
10 Older Entries »