… topology when using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is the second post…=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop… t; +———-+ | count(*) | +———-+ | 0 | +———-+ Can we still use master_auto_position = 1? Let’s hope so, as it is one of the…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… try to reconfigure the master? This time, replication on slave #1 will stop: 2013-05-17 13:32:08 2563 [ERROR... at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show… nice to be able to mix servers where gtid_mode is ON with servers where gtid_mode is OFF. This would greatly…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…” align=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the… lead to unresolved package dependencies when installing Percona Server 5.1. Bug fixed #893860. The log tracker thread was unaware of… Server. Bug fixed #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… (`id`), KEY `parent_id` (`parent_id`), CONSTRAINT `child_B_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id`) ) ENGINE=InnoDB… but it doesn’t help SchemaSpy at all. This is where Metadata files come in to play Creating a Metadata File….xml -o /var/www/schemaspy/ The -o directive tells SchemaSpy where to write the output to, make sure this is a…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… developer to refactor manually. There could also be some cases where optimizing a query automatically would be more costly than just… the IDs for movies are distributed uniformly over the range 1..MAX(id)? Yes, there’s a risk if you have…? The tuple comparison you’re referring to is this example: WHERE (k1.keyword, k2.keyword, k3.keyword) = (‘espionage’, ‘nuclear-bomb’, ‘ejector…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… much differently than traditional hardware, and I’ve seen situations where even under just a moderate load on the host system… with a two-NIC bonded pair you’ll get roughly 1.67x the throughput of a single port. [Don’t try… on the back end, but I think that’s probably where the similarities end. Q: What kind of replication issues can…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex… `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF For full disclosure…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1‘,’root’,”); mysql_select_db(‘test’,$mysql); function… BY parent) Deriv1 ON a.id = Deriv1.parent WHERE a.parent=” . $parent); echo “”; while ($row = mysql…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
since I upgrade percona xtrabackup to 2.1.3. My node is crashed and I have this error … backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… t as SELECT ld.label_id, cai.inventory_id, COUNT(1) as installed_count from client_app_inventory cai inner join… label_to_device ld on (ld.device_id = d.id) where ld.trash = ‘f’ and cai.trash = ‘f’ and (cai.status…
