(Meenakshi Agarwal) This tutorial explains MySQL UPPER()/UCASE() functions which convert the lower case characters of a string to upper case.
Tag: Open Source
(Dave Stokes) The ability to import data in parallel is now a feature of the new MySQL Shell. And you can run it from a command line instead of from within an interactive shell.
(Ashraf Sharif) ProxySQL has supported native clustering since v1.4.2. This means multiple ProxySQL instances are cluster-aware; they are aware of each others’ state and able to handle the configuration changes automatically by syncing up to the most up-to-date configuration based on configuration v
(Abdel-Mawla Gharieb) Some time ago, I was building a new MySQL DB server (5.7.25) and like all DBAs, I have a template of my.cnf that I use for the new instances after changing a few variables based on the instance resources, replication … etc. I had MySQL installed but I struggled on having the se
(Vinicius Grippa) In this post, we will discuss a new feature – the MySQL 8.0.17 clone plugin. Here I will demonstrate how easy it is to use to create the “classic” replication, building the standby replica from scratch.
(Tomer Shay) From time to time, you might notice that your MySQL database suddenly under-performs.
(Wayne Leutwyler) The blog post How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3 by Walter Garcia, inspired me to create an updated install of Percona Server for the Raspberry Pi 3+.
Are you looking to get started with the world’s most popular open-source database, and wondering how you should setup your MySQL hosting? So many default to Amazon RDS, when MySQL performs exceptionally well on Azure Cloud.
(Ashraf Sharif) WHM and cPanel is no doubt the most popular hosting control panel for Linux based environments. It supports a number of database backends – MySQL, MariaDB and PostgreSQL as the application datastore.
(Baron Schwartz) VividCortex can now detect deadlocks in MySQL, and generate events that you can use for alerting and notification.