Comments - Server System Variables

The entry here for explicit_defaults_for_timestamp is missing its "Introduced:" info field. It seems to be 10.1.8. https://mariadb.com/kb/en/mariadb-1018-changelog/

I defined the following data directory in /etc/my.cnf:

[mysqld] datadir=/mysql

After I started mariadb by the following command:

1. systemctl start mariadb

Error msg were shown on /var/log/messages:

[ERROR] InnoDB: Operating system error number 2 in a file operation. [ERROR] InnoDB: The error means the system cannot find the path specified. [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. [ERROR] InnoDB: Cannot open datafile for read-only: './SACCDB/UPLOAD_CCF_BATCH_DATA.ibd' OS error: 71

Here below is the directory structure and permission:

1. cd /
2. ll -d mysql drwxrwxrwx 7 mysql mysql 238 Feb 1 16:17 mysql
3. cd mysql
4. ll -rw-rw---- 1 mysql mysql 32768 Feb 1 16:17 aria_log.00000001 -rw-rw---- 1 mysql mysql 52 Feb 1 16:17 aria_log_control -rw-rw---- 1 mysql mysql 16783 Feb 1 16:17 ib_buffer_pool -rw-rw---- 1 mysql mysql 79691776 Feb 1 16:17 ibdata1 -rw-rw---- 1 mysql mysql 50331648 Feb 1 16:17 ib_logfile0 -rw-rw---- 1 mysql mysql 50331648 Feb 1 16:16 ib_logfile1 -rw-rw---- 1 mysql mysql 0 Mar 25 2020 multi-master.info drwx------ 2 mysql mysql 4096 Mar 25 2020 mysql drwx------ 2 mysql mysql 20 Mar 25 2020 performance_schema drwx------ 2 mysql mysql 12288 Jan 19 16:22 saccdb drwx------ 2 mysql mysql 12288 Jun 9 2020 sacctestdb drwx------ 2 mysql mysql 20 Mar 25 2020 test

Although it complained there are system OS errors, I still could connect to it. All tablespaces could be accessed and they are all in read-write mode, not read-only mode!!!

Are all the system OS related error messages false alarms?

The MariaDB version is in 10.4.12

Does changing hostname affect the datadir= option to find the new data path?

my.cnf --------- [mysqld] datadir=/mysql socket=/mysql/mysql.sock

The socket file could be created under /mysql

[root@dmbsdb1 mysql]# ll total 188512 -rw-rw---- 1 mysql mysql 32768 Feb 1 16:17 aria_log.00000001 -rw-rw---- 1 mysql mysql 52 Feb 1 16:17 aria_log_control -rw-rw---- 1 mysql mysql 5 Feb 1 16:43 dmbsdb1.pid -rw-rw---- 1 mysql mysql 16783 Feb 1 16:17 ib_buffer_pool -rw-rw---- 1 mysql mysql 79691776 Feb 1 16:44 ibdata1 -rw-rw---- 1 mysql mysql 50331648 Feb 1 16:44 ib_logfile0 -rw-rw---- 1 mysql mysql 50331648 Feb 1 16:44 ib_logfile1 -rw-rw---- 1 mysql mysql 12582912 Feb 1 16:43 ibtmp1 -rw-rw---- 1 mysql mysql 0 Mar 25 2020 multi-master.info drwx------ 2 mysql mysql 4096 Mar 25 2020 mysql srwxrwxrwx 1 mysql mysql 0 Feb 1 16:43 mysql.sock drwx------ 2 mysql mysql 20 Mar 25 2020 performance_schema drwx------ 2 mysql mysql 12288 Jan 19 16:22 saccdb drwx------ 2 mysql mysql 12288 Jun 9 2020 sacctestdb drwx------ 2 mysql mysql 20 Mar 25 2020 test

In normal situation, there should be only one IP bind to db server. Application will connect to this binding address. But on our environment, our developer need to access to the db on another network segment.

I tried to define the parameter as follows:

[mysqld] bind_address=10.x.x.1,192.168.x.x

When starting using /usr/bin/galera_new_cluster, it turned out with the following error messages:

[ERROR] Can't create IP socket: Name or service not known

Is there any way to bind more than one IP?

It should be...

[galera] bind_address=10.x.x.1,192.168.x.x

If I define as follows, it works.

[galera] bind_address=10.x.x.1

It works also as follows:

[galera] bind_address=192.168.x.x

have_symlinks is disabled in Windows installs

I tried everything I could find to try to get the have_symlinks = 1 on my Windows server. Eventually I resorted to looking through the source code and I see that it is disabled on all Windows builds. I have been unable to find this information in any documentation online so I wanted to confirm that I am not seeing things incorrectly.