- discuss - lists.mariadb.org

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

[Maria-discuss] New Question: Data Type
by AskMonty KB 29 Jun '15

29 Jun '15

Hello, A new question has been asked in "MariaDB Community" by bhumika. Please answer it at http://mariadb.com/kb/en/data-type/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, Can I create my own custom Data type in Maria DB , Can you please provide me some help on this. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/data-type/

1 0

[Maria-discuss] New Question: ipv6
by AskMonty KB 28 Jun '15

28 Jun '15

Hello, A new question has been asked in "MariaDB FAQ" by gerald_schade_g. Please answer it at http://mariadb.com/kb/en/ipv6/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- does, will or when (and how) will MariaDB support client-connections via ipv6? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/ipv6/

1 0

[Maria-discuss] doubt about index
by Roberto Spadim 26 Jun '15

26 Jun '15

hi guys, i`m with a doubt... when i have a primary key i know that's a unique key when i have a index with primary key + any other column, does mariadb consider that it's unique too? i`m thinking more about SELECT optimization

4 31

[Maria-discuss] FedereratedX ODBC Source
by Darin Keever 25 Jun '15

25 Jun '15

This is regarding: https://mariadb.com/kb/en/mariadb/about-federatedx/ Specifically, the last section bullet - Support for other RDBMS vendors using ODBC My employer started a project to add a generic ODBC source to the FederatedX plugin. Once into the project, it was decided that creating a specific source to our COM server would be faster. The ODBC source did work, but it was buttoned up after read-access was completed. I'm not sure if it will ever be released, but I thought we should distribute the code regardless. Please find an incredibly boring page here: http://stonebond.com/mariadb-contributions/ Included in the zip are the changes to source files, as well as two additional files for connecting to ODBC and to our COM dll. These were only compiled on windows, so likely are not ready for inclusion in the source tree. Let me know if you have any questions.

2 2