Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… not with this list. I tested this with “connect,Quit” to log successful and failed connections. Yes, it had to be a capital… #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record_cmds=connect,Quit Notice the audit_offsets that I…”,”host”:”localhost”,”cmd”:”Connect“,”query”:”Connect“} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… executed on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. You… you monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to… privilege; a user with SUPER will always be able to connect, and that may not accurately report what your application servers…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…] parse error in config: Can’t open logfile ‘/var/log/corosync.log‘ for reason: Permission denied (13).#012. So now you …Could not establish cib_ro connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@percona2…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And … before sending all writes If the binary logs of the master are no longer readable, … replication when using GTIDs is usually straightforward: just connect the slave to the correct master with …
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal 11 ; …read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible…56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File… Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… to connect and talk more about MySQL buffer pools or anything else that’s on your mind! There are numerous solutions for MySQL…/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped… during installation. Bugs fixed #1031427 and #1051874 (Ignacio Nin). The log tracker thread was unaware of the situation when the oldest…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
…. Bugs fixed: Percona Playback for MySQL now shows error when it’s unable to connect to the MySQL database server. Bug fixed #1070824… #1072845 (Stewart Smith). Percona Playback for MySQL wouldn’t reconnect or log the error if the connection was broken during the query. Bug fixed #1080654 (Vlad Lesin). Release notes with all the bugfixes for Percona Playback for MySQL…
