Loading...

Follow MariaDB | Reddit on Feedspot

Continue with Google
Continue with Facebook
or

Valid

Hi,

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).

Is there a common solution for this use case?

Thanks and regards

Robert

submitted by /u/silentBob84
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

The download page used to be something like https://archive.is/TE4Kh and linked from the plugin pages at https://mariadb.com/kb/en/library/mariadb-audit-plugin/ but can't find the link any more.

you could download it from: https://downloads.mariadb.com/Audit-Plugin/MariaDB-Audit-Plugin/server_audit-1.4.0.tar.gz for example but this URL returns a 404 now.

Anybody know where they have gone to ?

edit: https://downloads.mariadb.com/Audit-Plugin/MariaDB-Audit-Plugin/server_audit-1.4.0.zip used to be available too.

submitted by /u/trocster
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hello,

I need to upgrade MariaDB Galera Cluster from 10.0 -> 10.2 version.

Is it necessary to temporarily eject node from the cluster commenting out wsrep_provider during upgrade?

When I check MariaDB guide this step is not needed. It is enough to set only read_only=ON during upgrade.

Will mysql_upgrade have any effect on remaining nodes?

I suppose that mysql_upgrade actions will not replicate to other nodes of the cluster and we can safety run it as many times as we want.

Thanks for your help.

submitted by /u/shtuks
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
MariaDB by /u/automaticgarage5 - 1w ago

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:

https://hub.docker.com/r/linuxserver/mariadb/tags/

After updating to the latest, I was not able to connect to the mysql instance from command line (error can't connect to socket) and in the docker logs I got this repeating every second or so:

181031 13:47:34 mysqld_safe Logging to syslog. 181031 13:47:34 mysqld_safe Starting mysqld daemon with databases from /config/databases 

I eventually narrowed down the problem to adding some InnoDB changes in the custom.cnf file, for nextcloud, they recommend the following InnoDB changes:

innodb_large_prefix=true innodb_file_format=barracuda 

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?

submitted by /u/AutomaticGarage5
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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?

submitted by /u/757DrDuck
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I noticed for a while now that randomly mariadb starts to fill the ssd in 30MB/s speed.

Running Fedora 27 with MariaDB 10.2.19. The DB dir is 22G in size. Yet MariaDB decides to fill 500G out of nowhere. When things fill up it’s neither /var/lib/mysql nor swap growing!

As errors all I got is that a forums session cache is full, maybe some ddos attempt or just the effect of MariaDB going crazy, but that it would be able to fill the disk at that speed is really weird!

Luckily a remote service is pinging me in this case so I can quickly restart the db and everything is back to “normal“ for a random amount of days, this is really troublesome.

submitted by /u/SolSoCoG
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
MariaDB by /u/himalyahippie - 1w ago

I am trying to Update MariaDB from version 10.0.2 to 10.3.8 using the binary files. I am following the below steps:

  1. Replace the data folder of MariaDB 10.3.8 by my old (v10.0.2) data folder.
  2. Upgrade all the necessary configuration files.
  3. Run mysql_upgrade.
  4. Restart the mysqld service.

I have created a script to perform the above steps. But when I try to run mysql_upgrade, I get the following error:

Version check failed. Got the following error when calling the 'mysql' command line client ERROR 1193 (HY000) at line 1: Unknown system variable 'WSREP_ON'

FATAL ERROR: Upgrade failed

I am using Linux (I have tried over both Ubuntu and RHEL) OS. I don't get any error when I am doing the same thing over Windows.

https://i.redd.it/x8c7nip1oi021.jpg

submitted by /u/HimalyaHippie
[visit reddit] [comments]
Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview