How to Save on AWS RDS MySQL Costs
Right-sizing database instances is the process of adjusting your database instances’ size to match the workload generated by the application...
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.
Right-sizing database instances is the process of adjusting your database instances’ size to match the workload generated by the application...
The MySQL Development team is proud to announce a new version of the MySQL Shell with the following major improvements:...
Managing the logs in a centralized repository is one of the most common best practices in the DevOps world. Application logs, system logs, error logs, and any databases logs also will be pushed into your centralized repository...
Let’s try to give you all the necessary info the provide the most accurate answer...
An SQL injection is a code injection technique that may lead to destroying your database...
Almost every application of any real utility is backed by a database, which in turn is administered through a database management system (DBMS). MySQL is an extremely widely-used DBMS whose popularity is only exceeded by that of Oracle...
When it comes to migrating from on-premise to the cloud, there are many factors to consider and decisions that need to be made. First (and probably most important) on that list: managed DBaaS or setup and manage our own infrastructure?
When users experience memory usage issues with any software, including MySQL®, their first response is to think that it’s a symptom of a memory leak. As this story will show, this is not always the case. This story is about a bug...
In this post we describe MySQL connections, user threads, and scaling. We hope that an increased understanding of how MySQL works will help application developers and system administrators to make good choices and trade-offs...
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.…