July 2015 - discuss - lists.mariadb.org

[Maria-discuss] doubt - replication at same mysqld process
by Roberto Spadim 15 Jul '15

15 Jul '15

hi guys, i have a doubt about replciation on same machine, i never did this before i have a table running many writes and few reads, and another process start reading a lot, my today solution is replication on two servers (on same machine or other machine), the point is... could i replicate in same server (with only one server running / only one mysqld process) ? something like change table A, and a background process replicate to table B? "many writes" will write at table A, reads will read table B (read can be out of sync) innodb is locking a lot of rows, and myisam/aria is locking table a lot, both engines i have problem with lock, i consider replication to another mysqld process as the only solution, but i'm considering running only one mysqld process (if possible) i was thinking about something like HA in spider, but i didn't tested, maybe with flexviewcdc i could have a materialized view "B" of table A? any idea/help is wellcome -- Roberto Spadim

5 16

[Maria-discuss] ssd and hdd
by Roberto Spadim 12 Jul '15

12 Jul '15

hi guys i`m with a doubt... i have a server with ssd raid 10 array and hdd raid10 array ssd is faster for non sequencial read that's a fact when i change a table from one device to another and check query response histograms my doubt is... today i have myisam, aria, innodb and sometimes tokudb and spider at same server how could i easily select what table should be stored at ssd or hdd array? there's a "table space" to select if i want to use ssd or hdd instead of create table, and create symbolic links, or create table with data directory/index directory? i was thinking about something more easily understood like tablespace, but used by all engines something like create table blabla table space ssd create table blabla table space hdd what i'm doing today... i have many tables that i use normally and don't drop, these tables i can symbolic link to ssd or hdd, but all new tables i use hdd (they normally are temporary tables), i'm using innodb per file, tokudb i'm not using too much but i don't care about where it's today anyone with experience to help or ideas? -- Roberto Spadim

4 3

[Maria-discuss] New Question: Joomla 1.5 and unicode databse
by AskMonty KB 12 Jul '15

12 Jul '15

Hello, A new question has been asked in "Moving to MariaDB" by alijam. Please answer it at http://mariadb.com/kb/en/joomla-15-and-unicode-databse/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a server which (unfortunately) have tens of joomla 1.5 websites, After upgrade from Mysql to Mariadb 10 , all of the unicode texts are being displayed as question marks (i.e. ?????? ????), I looked into the databases , the data seems to be intact, even I moved some of them to another server with mariadb 5.6 which "seems" ok. It seems to be a driver/configuration issue. It works on later versions of joomla (2.5& 3.x) versions. It seems mariadb should also be compatible with joomla 1.5 In the joomla system information it says: Database Version: 10.0.20-MariaDB Database Collation: N/A (mySQL < 4.1.2) PHP Version: 5.4.41 Web Server: Apache Web Server to PHP interface: cgi-fcgi Joomla! Version: Joomla! 1.5.26 Stable [ senu takaa ama busani ] 27-March-2012 18:00 GMT User Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:39.0) Gecko/20100101 Firefox/39.0 Any help would be greatly appreciated , as I'm going to upgrade my other servers to mariadb. Best -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/joomla-15-and-unicode-databse/

1 0

Re: [Maria-discuss] New Question: backup
by Reindl Harald 10 Jul '15

10 Jul '15

Am 10.07.2015 um 14:03 schrieb Pantelis Theodosiou: > Is rsync a valid backup option for a running server? no > Without stopping it or at least (flushing and) locking tables first? no there are files in use and you can't get a safe, consistent snapshot of the datadir when the server is running, what you can do is one hot rsync, then stop mysqld and make a second rsync which should be fast because it only needs to copy the recent changes and fire up the daemon after that but that's just a workaround losing caches and buffers for nothing there is no problem start a replication-slave instance even on the same host while it's prferred to have it on a different because that brings you a "realtime backup" if the master host crashs unclean and refuses to start mysqld because damage of datafiles > On Wed, Jul 8, 2015 at 3:53 PM, Reindl Harald <h.reindl(a)thelounge.net > <mailto:h.reindl@thelounge.net>> wrote: > > > > Am 08.07.2015 um 16:40 schrieb AskMonty KB: > > A new question has been asked in "MariaDB Documentation" by > gtrymore. Please answer it at http://mariadb.com/kb/en/backup/ > as the person asking the question may not be subscribed to the > mailing list. > > -------------------------------- > How do you back up a mariadb server and what is /var/lib/mysql > directory > -------------------------------- > > power down the replication slave and rsync /var/lib/mysql to the > backup-location or whatever folder is configured as datadir - to be > honest you could have typed the same in a google search

1 0

[Maria-discuss] New Question: backup
by AskMonty KB 10 Jul '15

10 Jul '15

Hello, A new question has been asked in "MariaDB Documentation" by gtrymore. Please answer it at http://mariadb.com/kb/en/backup/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do you back up a mariadb server and what is /var/lib/mysql directory -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/backup/

5 8

[Maria-discuss] New Question: MaxScale without a Single Point of Failure?
by AskMonty KB 10 Jul '15

10 Jul '15

Hello, A new question has been asked in "MaxScale Getting Started" by iomdesign. Please answer it at http://mariadb.com/kb/en/maxscale-without-a-single-point-of-failure/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, We are looking at potentially using MaxScale as a solution to load balance our MySQL connections and provide read/write splits in a master slave setup. If we have both web servers pointing to a single proxy then obviously we have a single point of failure. When we were originally looking at HAProxy it was suggested having a local proxy for each web server that could then balance out across the databases. Is it possible to run MaxScale in a similar fashion? Is there a better approach that could be suggested with MaxScale without a single point of failure? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maxscale-without-a-single-point-of-failure/

1 0

[Maria-discuss] mariadb galera on sles?
by Federico Razzoli 07 Jul '15

07 Jul '15

Hi Is there a MariaDB Galera cluster repository for SLES12? I've found MySQL Galera repos, but not MariaDB... Regards Federico

2 1

[Maria-discuss] New Question: Limits in .frm
by AskMonty KB 01 Jul '15

01 Jul '15

Hello, A new question has been asked in "Optimization and Tuning" by lrirwin. Please answer it at http://mariadb.com/kb/en/limits-in-frm/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Does MariaDB implement anything to either split the content of the .frm files (or some other approach) to get beyond the 64K limit? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/limits-in-frm/

1 0

Re: [Maria-discuss] Can't connect to local MySQL server through socket
by Sylvain Raybaud 01 Jul '15

01 Jul '15

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi I'll try hard to fix the problem with rsync, even if I switch to mysqldump or xtrabackup-v2 in the future. Some context : mariadb and galera are built in buildroot and run on raspberry pis (ARMv6). Mariadb is started manually. I fixed the config file as you suggested yesterday (wsrep_cluster_address=gcomm://IP1,IP2,IP3 in my.cnf on all three nodes). I bootstrap the cluster on node #1 with --wsrep-new-cluster and I just start mysqld_safe and nodes #2 and #3. Running: mysql -u root --execute="SHOW GLOBAL STATUS WHERE Variable_name IN ('wsrep_ready', 'wsrep_cluster_size', 'wsrep_cluster_status', 'wsrep_connected');" on node #1 gives me: +----------------------+---------+ | Variable_name | Value | +----------------------+---------+ | wsrep_cluster_size | 3 | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_ready | ON | +----------------------+---------+ and on nodes #2 and #3: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111 "Connection refused") If I start mariadb outside a cluster on nodes #2 and #3 it works as expected. It seems nodes #2 and #3 are never synced since SYNCED never appears in error log. wsrep_sst_method is rsync. On 24/06/2015 15:00, Guillaume Lefranc wrote: >> Does this mean that mariadb tries to sync nodes but for some >> reason the script hangs, the nodes are never sync and remain >> unusable? > > I'm afraid that must be something along those lines. I have the > following suspicions: > > * SELinux or Apparmor not disabled, causing the SST to hang > forever. * Ports not open on the firewall (for the record you need > 3306, but also 4444, 4567 and 4568). Neither SELinux or Apparmor is enabled and there is no firewall on any of the boxes. They are all connected to the same ethernet switch. I'm investigating wsrep_sst_rsync script. Here are the processes running: # ps auxf | grep mysql 128 root {mysqld_safe} /bin/sh /usr/bin/mysqld_safe - --defaults-file=/etc/mysql/my.cnf 422 mysql /usr/bin/mysqld --defaults-file=/etc/mysql/my.cnf - --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/plugin - --user=mysql --wsrep_provider=/usr/lib/libgalera_smm.so - --log-error=/var/lib/mysql/buildroot.err --pid-file=/tmp/mysql.pid - --socket=/tmp/mysql.sock --port=3306 - --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1 429 mysql sh -c wsrep_sst_rsync --role 'joiner' --address '192.168.1.80' --auth '' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '422' --binlog '/var/lib/mysql/mariadb-bin' 430 mysql {wsrep_sst_rsync} /bin/bash -ue /usr//bin/wsrep_sst_rsync --role joiner --address 192.168.1.80 --auth --datadir /var/lib/mysql/ --defaults-file /etc/mysql/my.cnf --parent 422 --binlog /var/lib/mysql/mariadb-bin 458 mysql rsync --daemon --no-detach --port 4444 --config /var/lib/mysql//rsync_sst.conf 26966 mysql sleep 0.2 Note the sleep 0.2: it shows up often. It appears in wsrep_sst_rsync in two places: lines 136--140: # wait for tables flushed and state ID written to the file while [ ! -r "$FLUSHED" ] && ! grep -q ':' "$FLUSHED" > /dev/null 2>&1 do sleep 0.2 done lines 281--284: until check_pid_and_port $RSYNC_PID $RSYNC_REAL_PID $RSYNC_PORT do sleep 0.2 done Is it possible that one these loops never terminates? If I run the same commands invoked by mysql manually, they terminate with errors because SST_PROGRESS_FILE and WSREP_SST_OPT_ROLE aren't defined but this is probably not significant. I'll be happy to read any idea you might have. Maybe I should also send this message to galera mailing list? Cheers, - -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJVi9d9AAoJEEkkwl4JtJ9yE6EP/3PVzEXO7KVX9UrKrQSLXXM/ EWuV2a2KKxB8GkH1uDBISrn84futPR6M7/gdbMV8DeRNWAbCWgXWkrY/HVALvLxu jze4znZMmn+mxqDzmhp1klon+w9WAyH7lSfIC4AGgSiAe6ZFP5c8CSfbLNJPlSM+ buoJTQz9BFo+NTh4w7gbZUjAJVEm/7CpM8TwMPsu7+mMvbn4yMMLU2RkjhysGGKI YAJ9dXYjmD+49Z3Z2B54lRGeIbZNMDRjlQ/+F61Ml9XbQYJtDb8gHGN5a4FIiaFh pvOtjCi5foXdGfGv/nPbSkrMqkKBJHL0xbnKeze/OdIdZ1aOVN7Sy5tZJirlCJV3 q/48hmrIIMVU1FuC9F0zW7lGHsgsKiQvLM0X8C/ZdX0ZTvTjWWefoWLa/fSv/vYp z9E5HJxJ47gbnGeSEBby1+TmV/GoXvjiyH3oRXzEuyEP5xQtKH4Kvrh9MhwZdZpv sJc5QO9qfAHPecavhRQ1luuv6JCSqLPGpF+3RB80rB+BRUkwi0dfO0RmBzzmKBGZ vryGxAVBNZmpIatuCWY4cvvrkQm9kF7JMAR1rNTRylxLtyI5TR42c5r24tSasWct P6gICSrMBKVgoCdxanTI2q+faqAur/NDq4W6tgeqRnV/mk9zQW4oxJxfwQlS0zr6 YiUMXGeRi6IT0MTKwChk =goS7 -----END PGP SIGNATURE-----

2 5