I have a database in a VPS up and running. Its purpose so far is just educational for myself.
I am accessing it with DBeaver and HeidSQL.
When at home my host is changing frequently because on ISP IP reset. When at work I have changing IPs too and I'm behind a proxy. Since I'm sick of renaming or creating the user like 3 times a day and not willing to set the host to '*' I'm looking for a solution which allows me to have a fixed user and connect to the database via a proxy or VPN (SSH tunneling won't work on my companies network because of the proxy).
Hi, I'm using the mariaDB dockers on unraid for my nextcloud database. This has been working without issue for a year or so now, until today when I tried to update it (haven't updated in several months). I'm using the docker image from here:
which I have had running for a long time with no problems. Using a brand new docker, I tested with no other data, just adding either of those lines to the cnf file and I got the same error and could not connect to the mysql instance.
For now I have fixed the problem by rolling back to an older release using the docker tags, but I'm wondering if there has been a change to mariadb or Innodb recently that would make this configuration now work properly. Any ideas what could cause this?
I have a database that I've developed on my local machine and wish to mirror on my server for future use in a web app. Since the data is will not change frequently once it is fully loaded in, I had planned to use my local machine as master and my server as the slave. However, slave configuration specifies that I have some sort of static IP or DNS for master, which I do not have on my home connection. Additionally, it would be nice to have the option to delegate other users to edit some of the data from my server so the data editing is not solely my responsibility.
Would the sensible thing to do be to copy my database over to my server and then set up my server as master and use my laptop as a replication slave for development testing?