July 2014 - discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.0 + Master/Slave + spontanous Got fatal error 1236
by Erik Wasser 18 Jul '14

18 Jul '14

Hello *, I'm doing a master/slave setup in 2 OpenVZ hosts both with debian 7 and MariaDB 10.0 from the offical repository. The problem is that the slave sometimes bails out with the following error message: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000073' at 33590521, the last event read from 'mysql-bin.000073' at 39362449, the last byte read from 'mysql-bin.000073' at 39362560.' Okay, no problem I start the replication with "START SLAVE" but the next error occurs within 5 minutes or so: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000073' at 39362449, the last event read from 'mysql-bin.000073' at 48667806, the last byte read from 'mysql-bin.000073' at 48668672.' Sometimes it runs so for a week sometimes it fails 3 times within 15 minutes. It seems that the slave read some data and but the master havn't finished writing the data to the binlog. That should be impossible. So after starting the slave again everything is fine again. I can start the replication again with "START SLAVE" and everything is fine again for some times until the error appears again. And it's not that I'm running out of disc space I'm running here out of ideas. B-) Some other info: [mysqld] ... binlog-ignore-db = mysql binlog-ignore-db = test server_id = 10 log_bin = mysql-bin read_only = yes sync_binlog = 1 binlog_format = MIXED expire_logs_days = 14 max_allowed_packet = 1047527424 Any other "esoteric" ideas? -- Greetings... Erik Wasser

1 0

Re: [Maria-discuss] Increasing InnoDB page size in 10.1
by Tim Callaghan 15 Jul '14

15 Jul '14

Thanks, that is helpful. It would be good to capture this (and any other technical advantages) in the KB page itself. On Tue, Jul 15, 2014 at 3:44 AM, Jan Lindström <jan.lindstrom(a)skysql.com> wrote: > Hi, > > We had a customer request to increase the page size for uncompressed pages > to allow more blob fields in a table. This request is satisfied by this > implementation. While I was doing this enhancement, I did try to increase > the page size for compressed pages also but this proved too hard for time > constraints I had. I did try to discuss about the problems with only person > I know who really knows how compressed pages storage format is implemented > (Marko Mäkelä) but unfortunately, I did not get it to work with limited > help I received. As soon as I have again time, I will revisit this issue > and see what I can do. > > R: Jan > > > On Mon, Jul 14, 2014 at 4:07 PM, Tim Callaghan <tmcallaghan(a)gmail.com> > wrote: > >> I'm curious as to the reasoning behind this feature. I assumed it was to >> get better compression, but the kb page >> <https://mariadb.com/kb/en/mariadb/mariadb-documentation/mariadb-storage-eng…> >> states that compression will not be supported on the new 32K and 64K page >> size. >> >> -Tim Callaghan >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > > -- > > Jan Lindström, Principal Engineer > SkySQL - The MariaDB Company > > skype: jan_p_lindstrom > > www.skysql.com > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2F&sa=D&sntz=1&usg=…> > > [image: Twitter] > <http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fskysql&sa=D&sntz=1&u…> > [image: Blog] > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2Fblog%2F&sa=D&sntz…> > [image: Facebook] > <http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fskysql&sa=D&snt…> > [image: LinkedIn] > <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2F12142…> > [image: Google+] <https://plus.google.com/117544963211695643458/posts> >

2 1

[Maria-discuss] maridb performance issue with master server replication
by Zakir Mahomedy 14 Jul '14

14 Jul '14

I been trying to trouble shoot this problem for sometime now in both mariadb and percona. I been trying to migrate from Mysql5.6 to mariadb or percona, however in our testings our business app performs terrible when multi master circular replication is on. Our setup, 2 servers same specs, running vmsphere 5.5. VMs are created and CentOs 6.5 installed. On the same hardware, same VM setups, we are running Mysql 5.6 com edition with GTID circular replication with no problems in performance. With Mariadb and Percona as soon as I start slave, the master server performs badly with our business app. If I had to run the same business app on the slave machine, while its receiving updates, no problems, but as soon as I make it a Master the performance drops. While all the binary logging stuff are on, without replication turned on by using start slave; the app performs fine as some people suggested that there might be a performance hit with sync-binlogs etc Ive started a thread about this on dba.stack which has my config files etc posted. http://dba.stackexchange.com/questions/71188/slow-writes-on-percona-server-… This is so far the only issue that is stopping us from migrating to mariadb, and its driving me nuts. Our servers are going through a vpn and is lagging 0 seconds behind master Does anyone have an idea what may be the problem. thanks zak |

1 0

[Maria-discuss] Increasing InnoDB page size in 10.1
by Tim Callaghan 14 Jul '14

14 Jul '14

I'm curious as to the reasoning behind this feature. I assumed it was to get better compression, but the kb page <https://mariadb.com/kb/en/mariadb/mariadb-documentation/mariadb-storage-eng…> states that compression will not be supported on the new 32K and 64K page size. -Tim Callaghan

1 0

[Maria-discuss] Building MariaDB audit plugin for Percona 5.5.37-rel35
by Nick Urbanik 10 Jul '14

10 Jul '14

Dear Folks, The documentation at says, "The MariaDB Audit Plugin works for MariaDB, MySQL and Percona Server." So: 1. Which version of the MariaDB audit plugin should I use for Percona 5.5.37-rel35? 2. Does the user whitelist/blacklist feature work with Percona? 3. Does build/installation work in the same way as for MariaDB? -- Nick Urbanik http://nicku.org nicku(a)nicku.org GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24

2 3

[Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)
by Tanstaafl 09 Jul '14

09 Jul '14

Hi all, I'm very inexperienced mariadb/mysql/sql user/admin, but not totally clueless, been maintaining a tiny mysql DB for postfixadmin for years, then converted it to mariadb. We recently started using SOGo (groupware). I hired the SOGo guys to help with the install/config, and have been using it trouble-free for a few months now (love it for the most part), until now. Everything seems to be working fine, but since the upgrade to SOGo 2.2.4 on 6/12, which I am told increases the number of connections it uses to the DB, I have been getting very occasional errors like this (the system error is always either 104 or 0): 2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 104 <0x0x236c140[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x22241b0] connection=0x(null)> for URL: mysql://user:password@myhost.com:3306/sogo/sogo_sessions_folder <0x0x236c140[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2014-06-12 03:30:01 -0400 2014-06-12 03:30:15.531 sogo-tool[31674] Can't aquire channel But it only happened once per day after the upgrade, then once it happened twice (about 12 hours apart), and it happened at times when the load would be the lowest (ie, 3:30am for the one above). Googling reveals a lot of reports about this error over the years, some seemingly to be bugs, others DB tuning issues. Should I be looking at tuning: max_connections max_user_connections ? If not, does anyone know where I should start looking? Is there some kind of extra logging I could enable that wouldn't cause serious performance problems? Or... maybe this is simply not something I should be worried about? Thanks for any help/suggestions...

5 23

[Maria-discuss] max_connections variable
by Tanstaafl 08 Jul '14

08 Jul '14

Hello all, How is the max_connections variable used? Apparently it counts the max number of connections for all users combined, but is there a time factor? Ie, is it just simultaneous connections? Or max_connections per day? per hour? Thanks

4 3

[Maria-discuss] Galera cluster with asynchronous slave
by Johnny Antonsen 03 Jul '14

03 Jul '14

Hi! First off let show you what we are trying to achieve: Galera Cluster: MariaDBNode1 - HAProxy - keepalived <- MariaDBNode2 - HAProxy - keepalived <- MariaDB Slave node with GTID MariaDBNode3 - HAProxy - keepalived <- I'm currently working on a high-availability project where we want to use MariaDB 10 and Galera as the backend. Running this system as it is with Haproxy and keepalived works great. We are able to write to the VIP that is being moved between each node and haproxy takes care of redirecting the server with least connections. The problem comes when we want to do a standard master/slave replication from the cluster to an external slave. The slave is set up to connect to the VIP (or I have also been testing with connecting directly to the haproxied ip), and Using_gtid is set to Slave_pos. However, after some time, once the connection changes to a different node through haproxy, the following error occurs: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 3-1-422, which is not in the master's binlog' And the Slave_IO_State shows that it's no longer in sync. I have run SELECT @@GLOBAL.gtid_slave_pos; to check what the current GTID for each node is, and they all return: 1-1-2145, however, sometimes if I add a lot of data, that value is different on some nodes, which is why I think the slave gets confused. On the slave, when activating using_gtid=slave_pos, the following gtid_IO_pos appear: 1-1-2464,2-3-420,3-1-422 From what I have read, this should be somewhat correct, as the first value is the server id. However, in the config I have specified that node 1 has server id 1, node 2 has id 2 and so on, and that the same goes for gtid_domain_id. Is this the correct setup or do the nodes need to have the same server-id or gtid_domain_id? Surely there must be a good way to solve this? Is the system not built to handle an asynchronous slave replicating from one random node? Hope I can get some good feedback on this. Just as a side-note, I'm fairly new to mariadb and galera cluster, so be gentle :) With best regards Johnny Antonsen

1 0

[Maria-discuss] information about functions
by Roberto Spadim 02 Jul '14

02 Jul '14

hi guys! does information plugin show something about, what functions i'm using in my mariadb server? for example, i want know what udf functions are being executed and for a second step, there's something to block functions ? like some user only use sum() and min() max(), i want to block count() function -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

2 1