Installing MySQL Database on Ubuntu or CentOS is a trivial operation as long as they have nice package managers as Aptitute and YUM. Otherwise, in Mac OS X is a hard operation from downloading the correct package, apllying with several steps and it can break the whole install, if you But, with Homebrew, the install... Read More
The post Installing MySQL on Mac OS X easily appeared first on Devops for Dummies.
If you install a MySQL Database Server with the default options, your data are insecure and your server is in risk of invasion and some performance issues will appear shortly. With some best practices, your MySQL database becomes secure and the performance goes well. 1 – Set root password and change its login name As... Read More
The post MySQL Security Best Practices appeared first on Devops for Dummies.
When you have a MySQL server in production, backups are necessary to protect your data against any problem that may occur with your server. To make the backup and to restore the data, Exporting to a dump file The operation of export is also called dumping. To carry out the exporting, use the command msyqldump […]
This is just an update to let you know that the new SkySQL Training Schedule is now available online.
The schedule extends as far as September 2012.
There are courses in the Belgium, Germany, France, the United Kingdom, Ireland, the Netherlands, Sweden, and and the United States.
And some of the course titles include:
You can read the full schedule here:
http://www.skysql.com/services/training/schedule?vdt=training_course_list|page_3
As a followup to my previous post on installing HandlerSocket on CentOS 5 + Percona-Server 5.1, I’ve been asked to provide an updated HOWTO for RHEL 6 + Percona-Server 5.5. Although very similar to the original steps, there are some new traps (RHEL 6 comes with SELinux enabled) and there are some new ec2 gotchas! [...]
On several occasions it may be necessary to do some tasks around the process of starting or stopping a MySQL server such as:
init_file
configuration may not have access to.
innodb_log_file_size and adjust the on disk files
that this needs.
log_bin (I
try to use a relative paths to ensure that different instances
use a common setting even if datadir is different,
and changing from an absolute to relative path often requires
adjusting the binlog index file).
You may have others and many of these are likely to be site …
[Read more]Requirement 6 of PCI DSS v1.2 states that in order to be compliant, an organization must: “Develop and maintain secure systems and applications” “Unscrupulous individuals use security vulnerabilities to gain privileged access to systems. Many of these vulnerabilities are fixed by vendor- provided security patches, which must be installed by the entities that manage the [...]
Requirement 4 of PCI DSS v1.2 states that we must: “Encrypt transmission of cardholder data across open, public networks” Specifically, “Sensitive information must be encrypted during transmission over networks that are easily accessed by malicious individuals. Misconfigured wireless networks and vulnerabilities in legacy encryption and authentication protocols can be continued targets of malicious individuals who [...]
I’ve written some new Nagios checks for MMM (MMM on Google Code … MMM on Launchpad). check_mmm is a part of http://code.google.com/p/check-mysql-all/, and is meant to be called locally on the MMM Monitor server (usually via NRPE). Feedback is welcome, usage is as follows: Usage: check_mmm --cluster C# Options: --cluster= The MMM Cluster to check [...]
We are pleased to announce the release 1.0.16 of HoneyMonitor, our GUI for MySQL™ administration and monitoring.
In this release, available for immediate download, we have fixed many bugs and included several improvements.
We are working to release a RC version as soon as possible.
The following is the list of changes:
