Archive for the 'Database' Category

 

 

Jul 19 2021

How to Access ProxySQL Web Interface on Kubernetes

Published by under Docker,Kubernetes,Mysql

I wrote in a previous post about a ProxySQL Helm chart for Kubernetes, in which you can configure the pod from SQL queries. The chart includes an ingress to reach the stats server on port 6080. Here are a few steps to get this working. Ingress needs to be activated in the Helm Values file […]

No responses yet

Jul 06 2021

ProxySQL Helm Chart ⎈ Load Rules from SQL Query Set

Published by under Docker,Kubernetes,Mysql

ProxySQL is a powerful tool that relays traffic to multiple Mysql backends. Configuration can be set in proxysql.cnf that is loaded when the daemon starts. This is really nice from a Docker perspective. You change the file and redeploy with the new settings. Official ProxySQL Helm Chart I tried to use the ProxySQL team helm […]

No responses yet

May 16 2021

MySQL / PostgreSQL on iSCSI Fail to Start at Boot

Published by under Linux,Mysql,Postgresql

You are hosting Mysql or PostgreSQL data directory on iSCSI disks but the service fails to start at server’s boot. The service does not find the directory. However, you can start the service manually if you log on the server once SSH is available. These are logs for Mariadb but they would be similar for […]

No responses yet

Feb 28 2021

Change Procedure/Function Security Type and DEFINER

Published by under Mysql

Mysql procedures and functions security type is set as DEFINER which is the default value, as described in the “Create Procedure and create function chapter” on mysql.com.Why one needs to be cautious? Anyone with EXECUTE privilege can run the procedure or function with the DEFINER permissions. This might not be what you want. An error […]

No responses yet

May 08 2013

Include Stored Procedures in Mysql Backups

Published by under Mysql

Most of us use mysqldump utility to backup Mysql databases. Be aware because mysqldump includes triggers by default but stored procedures and functions are ignored.Stored procedures and functions are called routines in Mysql all together. Run mysqldump –help and you will see FALSE for routine’s default value. You can include stored procedures and functions adding […]

No responses yet

Next »