… that the source is not seen for example aggregating Oracle, SQL Server and MySQL into one source that the user or application…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…, given the import/export functionality of Xtrabackup combined with Percona Server (Exporting and Importing Tables), it did seem possible. Further discussion… same server. This will allow you to compare and restore values (potentially corrupted via user error or other issues) with SQL rather than needing to import from a remote server. This can allow for more targeted…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the IO… correctly, gtid_mode must be ON on all servers or OFF on all servers, but not something in the middle. What if…: we can have different replication modes on different servers, but only if all servers have gtid_mode set to ON. Could it…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… then the binary log filters are executed on the intermediate server, thus resulting in less binary log data being sent down… is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are going to be…/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… 5.7 the checks will be stricter: in the default SQL mode, a duplicate index will throw a warning instead of… check manually the optimizations proposed by Percona Toolkit. The MySQL server, of course, cannot risk to block directly all cases. A… (1.57 sec) Records: 0 Duplicates: 0 Warnings: 0 $ mysqlindexcheck –server=user:pass@localhost test.test # Source on localhost: … connected. $ pt…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… here is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc… a directory that can then be accessed by a web server. Also note that since I created the mysql.properties file…, and tables with the string NULL instead of the actual SQL NULL value. This is basically a quick sanity check of…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Percona Server, we included a regression in the RPM packaging that prevented the server from restarting following an upgrade — instead, the server would…) Bugs Fixed: Due to parse error in the percona-server.spec Percona Server rpm packages couldn’t be built on RHEL 5… was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library…) Bugs Fixed: Due to parse error in the percona-server.spec Percona Server rpm packages couldn’t be built on RHEL 5… was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key… Server 5.1.66-14.2 which could cause a server to hang when binary log is enabled. Bug fixed #1162085. Percona Server would re-create the test database when using rpm on server upgrade, even if the database…
Comment: Death match! EBS versus SSD price, performance, and QoS
May 13, 2013 By 55 Comments
… be a problem. The AWS instance we use (for our SQL Server) does have two ephemeral SSDs. Since they are ephemeral I…
