Working with JSON arrays in MySQL/MariaDB
When you write stored procedures in MySQL or MariaDB, one of the features you may miss is arrays. At least, at a superficial look – because an array data type is actually not implemented...
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.
When you write stored procedures in MySQL or MariaDB, one of the features you may miss is arrays. At least, at a superficial look – because an array data type is actually not implemented...
In this tutorial, we’ll be focusing on creating a dashboard for an Online Retail Store. Online Retail Stores generate revenue across other e-commerce giants, apart from their own website. This dashboard focuses on showcasing a monthly performance of an online store across three e-commerce aggregators - Amazon, Ebay and Etsy...
It is my pleasure and honour to join the MariaDB Foundation as its new CEO from 1 Feb 2019. Following MariaDB closely since its inception, I welcome the opportunity to be focusing completely on adoption, collaboration and free open development of MariaDB Server...
In all versions of MySQL when you run a single query it will run in one thread, effectively utilizing one CPU core only. Multiple queries run at the same time will be using different threads and will utilize more than one CPU core...
Last year I published my 2018 Database Wishlist, which I recently revisited to check what happened and what didn’t. Time for a 2019 wishlist...
MySQL is the only database to offer both SQL and NoSQL data access/storage – delivering the best of both worlds to Developers, DevOps, and DBA teams alike....
Welcome to Wednesday at Percona Live Europe 2018! Today is the final day! Check out all of the excellent sessions to attend...
The latest release of the MySQL Shell 8.0.13 (GA) introduced some interesting improvements and features...
Here we are going to see how can we install and configure rundek on a CentOS server with mysql as a backend...
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...
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....
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...
MySQL 8.0 has come with a list of new features for DBA’s...
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?
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...
In this blog post, Alkin Tezuysal revisits the ProxySQL Query Rewrite feature.
MySQL 8.0 brings a lot of new spatial features. The main feature is the support for multiple spatial reference systems (SRSs).
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.
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.
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:
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.…