Gestix on Mac OS X Yosemite – download this kickstarter to facilitate launching MySQL and Apache when needed

This tiny application has been created with Automator and can be inspected to see the applescript program inside it:

on run
    do shell script "/usr/local/mysql/bin/mysqld_safe > /dev/null 2>&1 &" with administrator privileges
    do shell script "apachectl restart > /dev/null 2>&1" with administrator privileges
end run

The script will try to launch MySQL by calling mysqld_safe directly, thus without the need to have the StartupItems / System Preferences components installed.

Then it will try restarting apache as well, by invoking apachectl restart.

Download link: http://gestix.com/download/Server-kickstarter-by-gestix.app.zip

Open the application, it will prompt for the computer’s password.Screen Shot 2015-05-27 at 8.47.42 PM

Then it tries launching both services and displays a confirmation message that enables  sending your feedback directly to the supporting team.

 

Screen Shot 2015-05-27 at 8.48.23 PM

 

 

 

 

Check the support page http://gestix.com/go/support

Like us on facebook http://facebook.com/gestix

Securing your MySQL server host computer

Secure your MySQL server host as to allow connections from the apps host only.

Then, install fail2ban and configure it so it will warn you whenever there are detected threats, like too many password failures, blacklisted access and so on. You can get the DVD ROM drive door open, an email sent, and other ways of being warned of any suspicious activity.

Fail2ban website: http://www.fail2ban.org

install and configure fail2ban onto all your multi-server appliance for gestix and mysql

install and configure fail2ban onto all your multi-server appliance for gestix and mysql

Note: for server running up to 100 simultaneous users, medium activity, consider using 2 separate 2 processor-cores appliances connected through low latency links, one for MySQL, the other for Gestix.