Migrate MySql to MariaDB for Bitnami LAMP

Keywords: LAMP/MAMP/WAMP - AWS - How to - Other
Description:
Are there possibilities of having MySQL and MariaDB in the same LAMP installation? I just discovered that an application has problems with the new versions of MySQL and I do not want to downgrade, I prefer to use MriaDB, I also did tests on localhost and MySQL is the cause of the error (SQLSTATE [HY000]: General error: 1525 Incorrect TIMESTAMP value: ‘-3004’)

With MaríaDB it works fine.

I read a post right here that DREAMFACTORY recommended but I just started it and maria DB is an extra service for their rates, which I am not interested in.

What can I do to be the closest thing to LAMP but with MARIA DB?

https://bitnami.com/stack/mariadb/cloud

Can this serve me? I do not see in its description what it includes.

ok now i have mariaDB but it is out of bitnami’s stack in the following path

/ etc / mysql

image

and
/etc/systemd/system/mariadb.service.d

image

This is my file in

/opt/bitnami/mysql/conf/my.cnf

> [mysqladmin]
> user =

> [mysqld]
> skip_name_resolve
> explicit_defaults_for_timestamp
> basedir = / opt / bitnami / mysql
> port = 3306
> tmpdir = / opt / bitnami / mysql / tmp
> socket = / opt / bitnami / mysql / tmp / mysql.sock
> pid_file = / opt / bitnami / mysql / tmp / mysqld.pid
> max_allowed_packet = 16M
> bind_address = 127.0.0.1
> log_error = / opt / bitnami / mysql / logs / mysqld.log
> character_set_server = utf8
> collation_server = utf8_general_ci
> plugin_dir = / opt / bitnami / mysql / plugin
> default_authentication_plugin = mysql_native_password
> sql_mode = NO_ENGINE_SUBSTITUTION

> [client]
> port = 3306
> socket = / opt / bitnami / mysql / tmp / mysql.sock
> #default_character_set = UTF8
> character-set-server = utf8
> plugin_dir = / opt / bitnami / mysql / plugin

> [manager]
> port = 3306
> socket = / opt / bitnami / mysql / tmp / mysql.sock
> pid_file = / opt / bitnami / mysql / tmp / mysqld.pid
> ! include /opt/bitnami/mysql/conf/bitnami/my_custom.cnf
> ! include /opt/bitnami/mysql/conf/bitnami/memory.conf

and this is the file

in the rute
> /etc/mysql/mariadb.cnf

> # MariaDB-specific config file.
> # Read by /etc/mysql/my.cnf

> [client]
> # Default is Latin1, if you need UTF-8 set this (also in server section)
> # default-character-set = utf8

> [mysqld]
> #
> # * Character sets
> #
> # Default is Latin1, if you need UTF-8 set all this (also in client section)
> #
> # character-set-server = utf8
> # collation-server = utf8_general_ci
> #character_set_server = utf8
> #collation_server = utf8_general_ci
> # Import all .cnf files from configuration directory
> ! includedir /etc/mysql/mariadb.conf.d/

**I thought it would be less complicated but I am trying because the MariaDB stack on AWS Apache, myphpadmin, php etc. are still missing.

Hi @ztudiomedia,

Thanks for using Bitnami!. If I have understood correctly you want to migrate from MySQL to MariaDB, if so please take a look at this link:
https://mariadb.com/kb/en/incompatibilities-and-feature-differences-between-mariadb-105-and-mysql-80/

If you want to change MySQL for MariaDB in LAMP, that is not possible, since they are stack prepared with those applications.
What you can do is to connect your application to Mariadb independently the stack of LAMP.

If I don’t understand you correctly, please add more information about the steps you want to follow.

Regards,
Ibone.

1 Like

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.