Most people install WordPress through its web interface using a browser. This is the officially supported installation method, and it's easy and intuitive. But did you know you can also install WordPress from the Linux command line?
You probably already know that Puppet allows you to set up a server from scratch. You might not realize that Puppet provides efficient, centralized management for complex services such as MySQL.
If you develop software, you need a tool to handle bug reporting, requests for changes, and new proposals. Mantis Bug Tracker (MantisBT) is particularly effective at those tasks.
Configuring and maintaining healthy replication in MySQL involves the execution of long, complex commands. With help from MySQL Utilities, however, administering replication can be simpler, more straightforward, and less error-prone.
Drupal is one of the most popular open source content management systems today. Unfortunately the default Drupal installation often requires a lot of customization to meet an organization's needs, so you have to rely on Drupal's thousands of extensions to tailor the software to do exactly what you want, and that takes time. It would be easier if you could install Drupal with all the extensions that you want to use straight out of the box – and you can do just that by using Drupal distributions.
Oracle, the company behind MySQL, provides MySQL Utilities, a collection of command-line scripts for accomplishing some common database administration tasks. We put the utilities through their paces on CentOS 6 and MySQL 5.6.
Little escapes the notice of the all-knowing, all-seeing system administrator with Zabbix at his disposal. Zabbix' enterprise-class monitoring software provides distributed monitoring with a centralized web administration interface.
Considering migrating your server from Debian to CentOS? This article provides information on key differences between the two operating systems, along with instructions on moving your applications and configuration files.
MySQL version 5.6 provides new database replication features that enhance reliability and help you improve performance. This article provides technical tips on how to implement and use the new features. OpenLogic provides expert MySQL support.
Stored procedures, which are available in all popular SQL engines, including MySQL, allow you to save SQL statements with variable declarations and flow control for later use. In MySQL, stored procedures have been supported since version 5.0, which means they are available in the default packages for CentOS and all other recent Linux distributions. You may have heard of stored procedures before, but do you know that you can use them to enhance your security?