Every week we collate our favourite articles from the week. Have a read of the latest PHP Developer news, Database News and Web Development news.

Back to news categories

PHP Developer News

Database News

Percona Live Europe 2018 Wednesday Keynotes and Sessions!

Welcome to Wednesday at Percona Live Europe 2018! Today is the final day! Check out all of the excellent sessions to attend...

Read Article

Import JSON to MySQL made easy

The latest release of the MySQL Shell 8.0.13 (GA) introduced some interesting improvements and features...

Read Article

Rundeck Series: Install And Configure RunDeck 3.0 On CentOS 7

Here we are going to see how can we install and configure rundek on a CentOS server with mysql as a backend...

Read Article

Versioning an existing database

This article describes a few of the important planning considerations, and then provides a simple walkthrough of how our team brings an existing database under version control using SQL Source Control...

Read Article

JSON Paths and the MySQL JSON Functions

I wrote MySQL and JSON: A Practical Programming Guide to help developers find their way around the MySQL JSON data type and the supporting functions. The MySQL Documentation on the subject is very good but I had to puzzle through the examples to see how things worked. I might be a bit 'thick' but good examples always make things easier. Others seem to have similar difficulties. MySQL and JSON a Practical Programming Guide should be on your desk as a handy reference to MySQL's JSON data type....

Read Article

NoSQL Development for MySQL Document Store using PHP

MySQL 8.0 introduced the MySQL Document Store, allowing developers to work with SQL relational tables and schema-less JSON collections through the use of the X DevAPI...

Read Article

Descending index in MySQL 8.0

MySQL 8.0 has come with a list of new features for DBA’s...

Read Article

MySQL & MariaDB Performance Tuning for Dummies

You’re running MySQL or MariaDB as backend database, how do you tune it to make best use of the hardware? How do you optimize the Operating System? How do you best configure MySQL or MariaDB for a specific database workload?

Read Article

Configuring MySQL in a Docker Container

In recent weeks I’ve been focusing on Docker in order to get a much better understanding of the containerized world that is materializing in front of us. Containers aren’t just for stateless applications anymore and we’re seeing more cases where MySQL and other databases are being launched in a containerized fashion...

Read Article

ProxySQL Query Rewrite

In this blog post, Alkin Tezuysal revisits the ProxySQL Query Rewrite feature.

Read Article

Spatial Reference Systems in MySQL 8.0

MySQL 8.0 brings a lot of new spatial features. The main feature is the support for multiple spatial reference systems (SRSs).

Read Article

Debian 9 LAMP Server Tutorial with Apache, PHP 7 and MariaDB

LAMP is short for Linux, Apache, MySQL, PHP. Here is a tutorial that shows how to install an Apache web server on a Debian 9 (Stretch) server with PHP (mod_php) and MySQL / MariaDB support. A LAMP setup is a perfect basis for CMS systems like Joomla, Wordpress or Drupal.

Read Article

How to do Point-in-Time Recovery of MySQL & MariaDB Data using ClusterControl

Backups are crucial when it comes to safety of data. They are the ultimate disaster recovery solution - you have no database nodes reachable and your data centre could literally have gone up in smoke, but as long as you have a backup of your data, you can still recover from such situation.

Read Article

MySQL Community Awards Winners 2018

One of the highlights of Percona Live is that the winners of the annual MySQL Community Awards are announced. A 100% community effort, the awards were created to recognize community contribution. This year saw six very deserving winners in three categories:

Read Article

New JSON functions in MySQL 5.7.22

A number of new JSON functions have been added to MySQL 8.0. Since we appreciate that not everyone will be ready to upgrade to MySQL 8.0 the minute it is released, we have backported many of the new functions to MySQL 5.7 so that they are available starting with version 5.7.22.…

Read Article

Our Services

Contact Us

Must be a valid email address.