I've seen variations of this question but for some reason I think I'm missing something. Problem I'm running a couple of containers on docker swarm. Every time my DB container, or backend container restarts, the database gets cleared. I thought…
On my Mac, when I write: sudo brew services list I get this result: Name Status User File ------------------------------ dnsmasq started root /Library/LaunchDaemons/homebrew.mxcl.dnsmasq.plist mariadb error 256 root /Library/LaunchDaemons/homebrew.mxcl.mariadb.plist nginx started root /Library/LaunchDaemons/homebrew.mxcl.nginx.plist [email protected] started root /Library/LaunchDaemons/[email protected] Yesterday I was battling…
in phpMyAdmin I can see all databases and tables. But when clicking on any table I get the error Error #1932 - Table 'mytablename' doesn't exist in engine I tried a lot of solution advises found on Google and Stackoverflow,…
Recently my web host decided to switch to MariaDB from MySQL. Since then, I get the following error whenever a page tries to connect to the database. "Versions of MySQL prior to 5.6 are not currently supported". I'm using ASP.NET…
I'm new to MariaDB galera cluster load balancing and I'm trying to use HAProxy to do the load balancing. I have set up the MariaDB Galera cluster and it works perfectly. In Haproxy, I have created a VIP for the…
I would like to access mariadb in the db container from the app container with the following folder configuration, but it does not work with an error. directory structure . ├── app │ └── Dockerfile ├── db │ └── Dockerfile…
We have a site that has been working pretty well for the past 2 years. But we are actually seeing random peaks in the database load that make the site very slow for a few seconds. These peaks only appear…
I have the calendar table with all the dates of the month of December 2021 (I will only exemplify some dates within the table, but it is understood that it actually contains all the days of said month): ID date…
I have the following table called employees: num_employee name 001 George 002 Mary And the table called records: num_employee date 001 2021-12-01 002 2021-12-01 001 2021-12-02 002 2021-12-01 001 2021-12-03 002 2021-12-06 In the example above, both employees attended on…
I have a large Wordpress site with 170.000 users and a lot of daily page views. I just tuned all MySQL indexes based on several comments but actually in my slow logs the SELECT distinct wp_usermeta.meta_key FROM wp_usermeta; takes around…