….31), looking for optimizations with HAProxy to account for high connection rates, and using pacemaker with PXC. The goal is to…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
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
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…-sys-maint”,”priv_user”:”debian-sys-maint”,”host”:”localhost”,”cmd”:”Connect“,”query”:”Connect“} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query…-sys-maint”,”priv_user”:”debian-sys-maint”,”host”:”localhost”,”cmd”:”Connect“,”query”:”Connect“} In conclusion, the plugin API seems to be opening…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… ports. Why 4? Two of those NICs should be directly connected from one machine to another and configured with Linux network… privilege; a user with SUPER will always be able to connect, and that may not accurately report what your application servers are seeing. But, if you can connect and run a simple query and receive a response back…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… -1 Could not establish cib_ro connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still running… [root@percona3 ~]# /etc/init.d/pacemaker start We can now connect crm_mon to the cluster and check its status: [root…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible that… the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download…
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… $ mysqlindexcheck –server=user:pass@localhost test.test # Source on localhost: … connected. $ pt-duplicate-key-checker –tables test.test # ######################################################################## # test.test…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the slave to the correct master with master_auto_position…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
May 28, 2013 By 3 Comments
I backed port percona’s perf tuning for read_view to AliMySQL-5.5, with 1K connections case, RO 13187 -> 40797, RW QPS 2W -> 3W TPS 5K-> 8.5K Amazing ~
