...
The link downloads an .rpm
package. The filename pattern is IderaSQLdmforMySQL-<version>.<architecture>.rpm
. You can install SQL DM for MySQL by calling the package manager on this file.
For Fedora and newer Red Hat-based distros, you can install SQL DM for MySQL with DNF:
Code Block |
---|
# dnf install /path/to/IderaSQLdmforMySQL-*.rpm |
For older Red Hat-based distros, you can use YUM:
Code Block |
---|
|
# yum install /path/to/IderaSQLdmforMySQL-*.rpm |
For openSUSE and SUSE-based distros, use YaST:
Code Block |
---|
|
# yast -i /path/to/IderaSQLdmforMySQL-*.rpm |
Image Added
Image Added
For any RPM-based distro, you can also use RPM itself:
Code Block |
---|
|
# rpm -ivh /path/to/IderaSQLdmforMySQL-*.rpm |
Image Added
Whichever package manager you use, it installs SQL DM for MySQL in the /usr/local/MONyog/
directory. You can now begin configuring and using SQL DM for MySQL.
Start/Stop
- In Redhat and Fedora systems if SQL DM for MySQL is installed from the RPM package, the daemon script 'MONyogd' can be used to start/stop the server. This script is in"/etc/init.d/" directory.
You can use one of the following command to start SQL DM for MySQL:
Code Block |
---|
|
# service MONyogd start |
or,
Code Block |
---|
|
# /etc/init.d/MONyogd start |
- To start the MONyog(SQL DM for MySQL) service on a system that uses systemd, run this command instead:
Code Block |
---|
|
# systemctl start MONyog |
Image Added
similarly for stopping:
Code Block |
---|
|
# service MONyogd stop |
or,
Code Block |
---|
|
# /etc/init.d/MONyogd stop |
Info |
---|
By default in these systems SQL DM for MySQL will be started automatically even after a restart. |
- In SUSE systems if SQL DM for MySQL is installed from a RPM package, the YaST 'run-level tool' can be used to start/stop the server. You may enable/disable the MONyog(SQL DM for MySQL) service from YaST (Administrative settings) > System > System Services.
Upgrading
To upgrade SQL DM for MySQL in Redhat/Fedora from a previous installation the following command can be used:
Code Block |
---|
|
# rpm -Uvh <IderaSQLdmforMySQL_package>.rpm |
Image Added
Uninstalling SQL DM for MySQL
To uninstall SQL DM for MySQL in Redhat/Fedora the following command can be used:
Code Block |
---|
|
# rpm -e IderaSQLdmforMySQL |
Note |
---|
SQL DM for MySQL upgrade is supported from MONyog 2.7.0-0 onwards, currently SQL DM for MySQL supports upgrade from lower version of SQL DM for MySQL to upper version of SQL DM for MySQL. |
Tar Installation
In the event that your server runs a Linux distribution that isn't RPM-based, such as Debian or Ubuntu, you can still manually install SQL DM for MySQL from a tarball. Note that SQL DM for MySQL does not require any sort of compiling. You just need to unpack it. Select the download link that corresponds to your hardware: 32 Bit Tar or 64 Bit TAR.
Installation
The download link retrieves a .tar.gz
file from IDERA. The pattern for the filename is IderaSQLdmforMySQL-<version>.<architecture>.tar.gz
. To install it run Tar setting the output to /usr/local
or any prefix appropriate to your system:
Code Block |
---|
|
# tar -xvf /path/to/IderaSQLdmforMySQL-*.tar.gz -C /usr/local |
Image Added
Image Added
It installs SQL DM for MySQL in the same path as the RPM package. In order to use the MONyog(SQL DM for MySQL) service, you also need to copy the MONyog
service script to /etc/init.d/
directory.
Code Block |
---|
|
# cp /path/to/MONyog/bin/MONyog /etc/init.d/ |
Start/Stop
This description applies if you have extracted SQL DM for MySQL(Monyog) from zipped tar(.tar.gz) package.
There is one shell script named "MONyog" within "MONyog/bin" directory. For example if SQL DM for MySQL(Monyog) has been extracted to ~/MONyog/ directory, you can start SQL DM for MySQL by typing:
Code Block |
---|
|
$ ~/MONyog/bin/MONyog start |
Image Added
Similarly, to stop:
Code Block |
---|
|
$ ~/MONyog/bin/MONyog stop |
Upgrading
Untar the SQL DM for MySQL package in the same directory where you had untarred the previous SQL DM for MySQL, use the command: 64 bit tar.
Code Block |
---|
|
# tar -xvf /path/to/IderaSQLdmforMySQL-*.tar.gz -C /usr/local |