Questions tagged with MariaDB
Content language: English
Sort by most recent
Hi, Can you please help to install maria db in amazon linux ec2 instance. While i was trying to install the server with the below command i am getting the following error as unable to find a match. am i missing anything ?
[ec2-user@planetm ~]$ sudo yum install -y mariadb-server
Last metadata expiration check: 4:46:51 ago on Sat Mar 18 17:35:23 2023.
***No match for argument: mariadb-server
Error: Unable to find a match: mariadb-server***
[ec2-user@planetm ~]$
I tried to connect to my db (mariadb) using HeidiSql and Navicat, connection fails with "unknown error". I can still connect through a connection in an application. First time in several months I have tried. and first time since they apparently upgraded security, always worked in the past
We are planning on exploring MyRocks database engine of MySQL.
I am aware that AWS RDS MariaDB supports it but haven't found any article if it's not supported by Aurora MySQL Compatible.
Is this available and will it be available in the future?
Thanks!
We have a MariaDB RDS in version 10.5.x and instance type of r5.xlarge. I created a Blue/Green Deployment to upgrade both DB version and instance type to r6g.xlarge. It creates the master instance in Green Deployment and upgraded to the latest MariaDB version yet the Blue/Green Deployment stuck in Provisioning.
Earily we have created a Blue/Green Deployment for another RDS and everything goes smooth with a very similar background. I have no idea on what should we do regarding it.
I have a MariaDB 10.6.10 RDS instance running on db.m6g.2xlarge ( 8 vcpu / 32 GB / 20GB SSD), using option group default:mariadb-10-6 and parameter group default.mariadb10.6.
When I try to create a "point in time restore" instance with the same options group, parameter group, db engine version, and instance that is running, the point-in-time restore instance fails to start, with the following status:
incompatible-restore
I've researched a bit on this failure and found this AWS doc (https://aws.amazon.com/premiumsupport/knowledge-center/rds-incompatible-parameters/#:~:text=An%20Amazon%20RDS%20DB%20instance%20in%20the%20incompatible%2Dparameters%20state,version%20or%20DB%20instance%20class.) which discusses matching custom paramters group to default, but I'm already using the ONLY parameter group available, which IS the AWS default for that MariaDB engine (10.6.10).
Any thoughts or insights appreciated.
Thanks
In a database instance for Mariadb, what is the best strategy for caching?
Today i tried to enter my Maria databasers with DBeaver on my three Lightsail instances. The setup was done a few month ago and have worked without any problem
DBeaver failed. Error:
Could not connect to 127.0.0.1:47610 : unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
So i tried again from CLI, MobaXterm:
r> mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local server through socket '/opt/bitnami/mariadb/tmp/mysql.sock' (111)
VPS Main Server>
Then i tried from Lightsails own connection:
mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local server through socket '/opt/bitnami/mariadb/tmp
/mysql.sock' (111)
VPS Main Server>
2 AM in the EU-West-2 region RDS did an automatic minor upgrade from 8.0.20 to 8.0.28 even though the "Enable auto minor version upgrade" checkbox was unchecked. As a result, the MySQL Workbench could not connect to the DB forcing us to reboot.
How do we ensure that RDS doesn't upgrade the version despite disabling the automatic minor upgrade?
Thanks for your help!
Is phpmyadmin installed to a light sail Wordpress instance? And how do I check? I used ssh and typed phpmyadmin —version But it wasn’t found
I tried logging in to phpmyadmin with no success.
I checked the bitnami directory and there is a phpmyadmin directory but it is empty. Is it installed and if so where would it be?
I am also port forwarding and using https://127.0.0.1:8888/phpmyadmin/ but it’s not found.
My database seems to be a Mariadb database. I assume it is used with phpmyadmin ?
Or is there another way to edit the database. I just want to access my Wordpress tables.
Hi,
We have a long-running RDS DB, and we would like to pay upfront for it, we want to know what is the best instance type to use.
Is there a tool like AWS compute optimizer for RDS?
If not, how do you determine what is the best-fit instance type?
I have a MariaDB 10.6, RDS t4g.micro instance, however when I go to Modify, there's no Performance Insights section.
According to the documentation here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Overview.Engines.html
Under Amazon RDS for MariaDB - The db.t4g.micro and db.t4g.small instance classes require 10.6 and higher.
Hi,
previously I was using mysqldump to get a copy of our production database, and importing it into another database, and scripting the scrubbing of all the data, however, the dump file has now exceed 38gb, and we are looking at trying to improve the process.
We were looking at using snapshots, but can load into existing db. so a new db needs to be stood up each time.
we would still need to use mysqldump to get a copy of the scrubbed data out, but I am trying to improve the process to be most efficient due to speed and size.
Thanks!