MySQL at Sunshine PHP

February 4, 2020

Sunshine PHP is the first US based PHP Conference of the year and it has been a favorite of mine for a long time. MySQL is proud to again sponsor this amazing event. This show brings in the best talent from around the world and covers all the aspects of PHP software development.SunshinePHP logo

I will be speaking on new features in MySQL such as dual passwords, hash joins, and JSON document validations. And this year Kathy Forte will present on Testing MySQL Group Replication with MySQL to Enhance Your High Availability Strategy.

There are a few tickets left but they are running out quickly. And be sure to drop by the MySQL booth to say hello.


Lucky Sevens — MySQL 5.7 and PHP 7

December 10, 2015

MySQL 5.7 and PHP 7 are the latest versions releases of two ofthe LAMP Stack pillars. In the past I have detailed how to use the MySQL apt-get repository to upgrade Ubuntu to the latest and greatest. But that about PHP 7? This is a fairly simple update for someone running a traditional LAMP (Linux Apache MySQL and PHP) server. There are also great directions out there on updating Nginx for those so inclined to be found with a quick search.

sudo apt-get install python-software-properties
sudo add-apt-repository ppa:ondrej/php-7.0
sudo apt-get update
sudo apt-get purge php5-fpm
sudo apt-get install php7.0-cli php7.0-common libapache2-mod-php7.0 php7.0 php7.0-mysql php7.0-fpm php7.0-curl php7.0-gd php7.0-mysql
cp /usr/local/php7/libphp7.so /usr/lib/apache2/modules/

Then a quick test program:
<?php
$mysqli = new mysqli("localhost", "root", "hidave", "world");

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

/* print MySQL server version */
printf("

PHP version: %s

", phpversion());
printf("

MySQL version: %s

", $mysqli->server_info);
printf ("

System status: %s

", $mysqli->stat());

$mysqli->close();
?>

And the result:
PHP version: 7.0.0-5+deb.sury.org~vivid+1

MySQL version: 5.7.9

System status: Uptime: 2102 Threads: 1 Questions: 12 Slow queries: 0 Opens: 107 Flush tables: 1 Open tables: 26 Queries per second avg: 0.005

Please note that you will have to update your code if you use the old and no deprecated mysql calls instead of the supported mysqli calls.


Need a quick MySQL 5.7 PHP Vagrant environment?

November 20, 2015

The Laravel folks are not letting the grass grow under their feet. The popular PHP Framework (motto ‘The PHP Framework For Web Artisans’) wraps their framework and the recently released MySQL 5.7 server software in a Vagrant image called Homestead ready for you to use.

I created a new directory for my new Laravel work, cd-ed into it, and then issued vagrant init laravel/homestead. As quick as my hotel wi-fi could support, I had 5.7, PHP 5.6.15 plus more on an Ubuntu 14.04 LTS virtual machine.

So if you want to easily try MySQL 5.7 or Laravel please Laravel Homestead a try


Learning PHP, MySQL, GIT, CSS, HTML, OOP, etc.

April 28, 2014

“How do I learn PHP, MySQL, GII, CSS, HTML, OOP, and all that quickly, without becoming confused or frustrated but still get to do the cools stuff?” I get this question on a very frequent basis and until last Friday, I had to suggest a number of ways of pulling together all the pieces together. But it still lacked a comprehensive theme and flow. Then last Friday at LonestarPHP, the LonestarPHP organizers teamed with PHPWomen,to provide a foundations track that covered all the above and more. Davey Shafik, Elizabeth Smith, Matt Frost, and Michelle Sanver put together an amazing day of learning with PHPBridge PHPBridgefor a crowd of about 40 novices,

The material is under a Creative Commons License and can be used by other events. The idea was borrowed form RailsBridge and organizes the many moving parts of a PHP application building environment in a very easy to follow but still very informative fashion. If you want to provide this material as a PHPBRidge event, there are some provisos (Free of charge, make tech more welcoming) and you should consider adding this to your local event.

I heartily recommend this to any novices out there or those with some gaps in their knowledge of PHP app development. You will be walked through the basics, set up a development environment, code, connect to a database, use a relational database (MySQL) for storing data, and more. Hats off to PHPWomen and LonestarPHP for this year’s track and I hope to see it again next year.


PHPTek

May 21, 2013

The PHPTek Conference bills itself as the premier professional PHP conference with a community flair. Having been to dozens of PHP conferences, I thought that was a pretty bold claim.

MySQL Boogiebot

But as they say in Texas, it ain’t bragging if you can do it.
MySQL plush dolphins and BoogieBots.  The wind up dancing robots were popular in Chicago

MySQL plush dolphins and BoogieBots. The wind up dancing robots were popular in Chicago

And the organizers picked perfect weather for this Chicago based show.

The quality of the presenters and presentations was amazing high. Most of these sessions covered intricacies with the PHP language. The talks covered the range from beginning Symfony 2 to advanced security. The presenters were indeed the cream of the crop and the material covered very well developed.

Oracle’s own Ligaya Trumelle started the second day with a MySQL 5.6 new features session specifically tailored to what this elite audience wanted to know about 5.6. Later she teamed with Davey Shafik on Engine Yard on MySQL HA, Recovery, and Load Balancing. The second talks was a comprehensive look at the most popular options for all three areas1.

Oracle was a sponsor of this show and I also had an opportunity to present Ten Things To Do To Make Your MySQL Databases Stronger and Healthier when not at the booth handing out three hundred Boogie Bots, MySQL Stickers, and a handful of plush Sakila Dolphins. The attendee questions at the booth were also high level (isolation levels for the best insert concurrency, how to use GTIDs, and partitioning) as opposed to more mundane questions at other shows.

So this truly is the premier PHP show and if you are a serious PHP coder, you need to plan to attend this show next year.

  1. You should download their slides on this as they worked hard to provide good benchmark numbers. Sadly some of the software (third party) did not prove to be robust enough for a good comparison. Lig and Davey put a lot of hard work into this sessions and the slides were loaded with vital info and their configurations.