…: In constructor ‘Car::Car()’: ndbapi_scan.cpp:111: error: ‘memset’ was not declared in this scope ndbapi_scan…_NO))” ” ENGINE=NDB”)) { if (mysql_errno(&mysql) != ER_TABLE_EXISTS_ERROR) MYSQLERROR(mysql); std::cout << "MySQL Cluster already has example table....0.8a/mysql.sock 127.0.0.1 Connecting…Connected! Initializing NDB…Done Looking for table GARAGE…Got it! = GARAGE Getting the…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… the master: # mysqldump –all-databases –single-transaction –triggers –routines –host=127.0.0.1 –port=18675 –user=msandbox –password=msandbox > dump… is the error we are going to get: Slave_IO_Running: No Slave_SQL_Running: Yes Last_IO_Error: Got fatal error 1236 from… on the slave: slave1 [localhost] {msandbox} ((none)) > source test.sql; [...] ERROR 1840 (HY000): GTID_PURGED can only be set when GTID…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… server we can replay the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db…, 330501 were slower A total of 51 queries had errors. Expected 372462 rows, got 371851 (a difference of 611) Number of queries…, 330737 were slower A total of 51 queries had errors. Expected 372462 rows, got 371851 (a difference of 611) Number of queries…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
… case, I immediately got the dreaded: ERROR 2026 (HY000): SSL connection error As is normally the case when one encounters this error, the following… s_client -CAfile /etc/mysql/ssl/ca-cert.pem -connect 127.0.0.1:4433 If all is working, then your… of the server certificate and generally not give any errors. If there are errors, it’s helpful to look at what the…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
…” RA (patch from MarkS applied manually) I got from ocf-tester: Beginning tests for /…lib/ocf/lib/heartbeat/ocf-shellfuncs * rc=127: Your agent has too restrictive permissions: should…{ -:1: parser error : Document is empty ^ -:1: parser error : Start tag expected, ‘<' not found ^ I/O error : Invalid …
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… few queries, quit, and cancel tcpdump. Now I’ve got a file and I’m ready to analyze it. … 101ms 101ms 0 101ms # Users 1 msandbox # Hosts 1 127.0.0.1 # Databases 1 # Time range 2009-07-…the flags set in the protocol, indicating the warning count, error count, rows affected, and whether no index or no …
