The year 2014 is almost over, but looking around my developer colleagues, I see that there is still a lot of old knowledge and outdated techniques for using your Mac for (web-) development purposes. To counter this lack of information I will outline the steps I took to lift my two primary OS X systems into the new age. Gone are the days where we need to have a webserver, database system and a plethora of different packages installed on our main operating system and deal with breaking changes whenever a new OS update (Hello Yosemite!) comes along.
This post talks about setting up your own private local development server with all the needed software to start developing applications with PHP and MySQL without having to install any server software on your main operating system. The end product will also give you the means to quickly set up an identical virtual machine on any number of additional computers you might want to use for your development.
Disclaimer: As I am a heavy user of Laravel these days, this set-up will mainly center around web development and PHP.
SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"?FROM information_schema.TABLES GROUP BY table_schema ;
In our effort to get more and more services into our own hands & to be able to blame ourselves and nobody else if something goes wrong,?Hirschy successfully attempted to install MyDNS on a couple of our servers.
We already took a go at it after the second last outage of our fellow DNS provider Awebs (now Quickstep) but didn’t have the time and energy to completely finish the task. Now after the next outage which is still kind of un-explained by the DNS provider we though it’s time to move on.
After a couple of hours of testing and writing a custom update script that replicates our DNS data to the secondary and tertiary nameservers via mysqldump and scp I think we are ready to migrate all our domains to this setup.
Now the only thing left is an answer to my eMail to Quickstep and then we’ll begin moving.
I really hope with those measures all the domains will be saver and suffer from less timeouts. Many thanks to Hirschy for his excellent work 🙂
There is a good HOWTO at Howtoforge that explains the installation of MyDNS and the easy-to-use webfrontend namend MyDNSConfig.
just so I don’t forget it …
(still need it EVERYTIME I set up a new server *sigh*)
root@u-1:/home/u-1# mysql -u root mysql
mysql> SET PASSWORD FOR root@localhost=PASSWORD('whatever');