Post has shared content

Post has attachment
Where on the Mariadb.org site is there an updated page explaining how to move a users database directory from the default /var/lib/mysql? My sizable database is filling up my / directory and so I made several attempts to move to a /home/maria/mysql directory with far more space. This is quite a frustrating procedure as the steps I find on the web are old, stale and just do not work.

Filling up the / directory makes it difficult to keep the linux (Fedora) system up to date.

Thanks in advance for any help, direction and clarity!


Database MariaDB is not initialized, but the directory /home/maria/mysql is not empty, so initializatio
Jan 17 06:47:01 BillLaptop systemd[1]: mariadb.service: Control process exited, code=exited status=1
Jan 17 06:47:01 BillLaptop systemd[1]: Failed to start MariaDB 10.2 database server.
Jan 17 06:47:01 BillLaptop systemd[1]: mariadb.service: Unit entered failed state.
Jan 17 06:47:01 BillLaptop systemd[1]: mariadb.service: Failed with result 'exit-code'.

Hi all!

Could anyone explain me is it bug or feature?

Debian Stretch
mariadb-server-10.1.26
mariadb-client-10.1.26
MySQLdb-1.2.5

Python code perfectlly work in Debian Jessie, but failed in Stretch with error:

Traceback (most recent call last):
File "bug_check.py", line 17, in <module>
cur.executemany(q, p)
File "/usr/local/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 255, in executemany
self.errorhandler(self, TypeError, msg)
File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
TypeError: not all arguments converted during string formatting

Python code:
#!/usr/bin/python
# -*- coding: UTF-8 *

import MySQLdb

db = MySQLdb.connect(host='192.168.1.183', user='root', passwd='password', db='test', charset='utf8')
cur = db.cursor()

q = """INSERT INTO test2 (id, value)
VALUES (%s, %s)
ON DUPLICATE KEY
UPDATE value=%s
"""

p = [(1, 7, 7)]

# failed
cur.executemany(q, p)

# working
for i in p:
cur.execute(q, i)

db.commit()
db.close()


Database:

CREATE TABLE `test2` (
`id` bigint(8) NOT NULL,
`value` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `test2`
ADD PRIMARY KEY (`id`);

ALTER TABLE `test2`
MODIFY `id` bigint(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

I am trying mariadb-10.2, pymysql but anyway error occurs.

Post has attachment
Let's tune my servers, anything to make them speed up.
Hope this can help somebody else.

Post has attachment
We are excited to have ProxySQL creator René Cannaò join us on Feb 28th for the webinar MySQL & MariaDB Load Balancing with ProxySQL & ClusterControl

Post has attachment

Hi Friends,

Any of you know any tool that allows me to obfuscate my code functions and / or stored procedures y MariaDB/MySQL ? :(

Hey Comm, quick question.

If using a master/master replication with two nodes using a keepalived virtual IP; is it really still necessary to setup an auto increment increment/offset?

I reckon it isn't because the application only reads/writes to the virtual IP which will only be on either one of the nodes.

It would be necessary if the application reads/writes on both nodes simultaniously, which isn;t the case.

Thanks in advance!

Hello someone could tell me how the connection between MariaDB and java is done is I have to do a project but have not been able to find as the connection is made. I'm using HeidiSQL and netbeans.
please help.

Post has attachment
Wait while more posts are being loaded