Re: [Maria-discuss] service on port 4567 is not starting

2013-02-11 Thread Kőszegi Dániel
Hi Elena, Thank you very much, this solved my problem, replication is working! :) Cheers, Dan -Original Message- From: Elena Stepanova [mailto:ele...@montyprogram.com] Sent: Tuesday, February 12, 2013 2:03 AM To: Kőszegi Dániel Cc: maria-discuss@lists.launchpad.net Subject: Re: [Maria-

Re: [Maria-discuss] service on port 4567 is not starting

2013-02-11 Thread Elena Stepanova
Hi Daniel, On 2/12/2013 3:30 AM, Kőszegi Dániel wrote: Hi All, I would appreciate a little help. I have done everything how it is in the installation steps, but the galera service on the port 4567 is not starting. No errors in mysql or syslog :( Tried on debian and centos as well. Right now

Re: [Maria-discuss] Problem in replication with NOW('2012-03-07 17:32:03')

2013-02-11 Thread Elena Stepanova
Hi Jan, On 2/12/2013 3:46 AM, Jan Kirchhoff wrote: Elena, I can't switch to statement based replication that easy. Even only for the connection(s) that produce the bad statements, if they can be easily isolated and modified? (to row-based replication; statement is what you have now). Actua

Re: [Maria-discuss] Problem in replication with NOW('2012-03-07 17:32:03')

2013-02-11 Thread Jan Kirchhoff
Elena, I can't switch to statement based replication that easy. Actually, I hope that all that is obsolete if galera works out for me. I thought this NOW(timestamp) syntax was a modification coming from the binlog somehow to keep the timestamps in sync when using replication, but I remember the

[Maria-discuss] service on port 4567 is not starting

2013-02-11 Thread Kőszegi Dániel
Hi All, I would appreciate a little help. I have done everything how it is in the installation steps, but the galera service on the port 4567 is not starting. No errors in mysql or syslog :( Tried on debian and centos as well. Right now server version: 5.5.28a-MariaDB-a1~squeeze-log

Re: [Maria-discuss] Problem in replication with NOW('2012-03-07 17:32:03')

2013-02-11 Thread Elena Stepanova
Hi Jan, The function NOW() was never supposed to take a timestamp as an argument, neither in MySQL nor in MariaDB. In earlier versions any argument was ignored. Starting from MariaDB 5.3 (and MySQL 5.6), when microseconds support was implemented, it takes an optional integer argument, which i

[Maria-discuss] Problem in replication with NOW('2012-03-07 17:32:03')

2013-02-11 Thread Jan Kirchhoff
Hi, I set up 2 hosts as a galera cluster, one of them is a slave of my main database. The galera hosts are 5.5.28a-MariaDB-a1~precise-log, all other databases are 5.2.12-MariaDB-mariadb115~squeeze-log. The 5.5 slave stops with 1064 errors. I figured this is because of updates using NOW()

Re: [Maria-discuss] testing Galera

2013-02-11 Thread Elena Stepanova
Hi Jan, I recommend to ask for advice regarding Galera fine-tuning and tricks on the Codership mail list: codership-t...@googlegroups.com. It's an active group, and as far as I can tell, Galera experts there are quite responsive. While we might be able to provide _some_ views on the subject,

Re: [Maria-discuss] testing Galera

2013-02-11 Thread Jan Kirchhoff
Hi everybody, I installed Galera on 2 servers, imported a database dump (took almost 2 days to import a 100GB gzipped sql-dump ...) and set up one of the two servers as a replication slave of our main database. Now as I try to understand all the new variables and want to get an idea of do's and d