Recently while working on a web based project which runs on apache2 on EC2 Linux server, PHP, MySQL, using git as a source version control system(VCS), i was able to access the .git repository from browser like http://example.com/.git/ Why is it bad to keep .git folder on server and accessible on production servers? When deploying any … Continue reading How to prevent serving .git directory on web
Query to calculate gender percentage in MySQL
How to kill a frozen screen in Ubuntu 16.04
I really had to scratch my head when i forgot the commands, so did happened with me today with beanstalk, I had to check that whether or not my jobs are getting queued in beanstalk queue, are they getting delayed? Some of the commands that i used are: Connect to beanstalk telnet localhost 11300 Get the statistics of … Continue reading Beanstalk helpful commands
In my last two posts, I wrote about setting up replication with MySQL 5.6 using Global Transaction Identifiers. Even when I set up replication “the old-fashioned way“, one thought always enters my mind – did all of the data copy over to the slave? And, even after the master/slave has been running for a while, I am always wondering if the data in the slave matches the master. Or did the change that I made to that table make it over to the slave? It is probably more of a case of paranoia on my part, as MySQL replication is very reliable and works really well.
A few months ago, I started writing about the MySQL Utilities. If you haven’t heard about the MySQL Utilities:
“MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. These utilities encapsulate a set…
View original post 1,578 more words
Right, after my presentation at PHPLondon this month, the most contentious issue was that of using cookies with your REST API. I said, in no uncertain terms, that you shouldn’t do it. There were a few cries from the audience which were akin to the flapping you hear in a parliamentary broadcast, Derick Rethans didn’t agree but had the grace not to publicly embarrass me* and one comment on the original post requesting a clarification of my statement.
So, to clarify!
One of the most important constraints of REST is that it should be stateless, that is, every request made to API should contain everything the application needs in order to service the request. Now, at it’s most terse, that is my clarification, however, the quicker witted and cleverer among you will be proud to announce that a cookie is part of a HTTP request, and you’d be right, so…
View original post 406 more words
MySQL 5.7. Tutorial - Dutch PHP Conference 2015 Original Credit to Dave Stokes (MySQL Community Manager at Oracle)