…; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ | 2 | percona1 | lefred | | 3 | percona2 | kenny | +—-+—————+——–+ 2 rows in set (0.00 sec) percona2 mysql> select * from percona; +—-+—————+——–+ | id | inserted… set (0.01 sec) You can keep inserting data, it won’t be replicated and you will have 2 different version of… results: version = 2, component = PRIMARY, conf_id = 6, members = 2/3 (joined/total), act_id = 19, last_appl. = -1, protocols = 0/4/2…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…replication slave the last master binlog file InnoDB: position 0 1604, file name mysql-bin.000001 InnoDB: Last… unimportant binlog events: /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_… /*!*/; # at 517 #100810 18:54:31 server id 1 end_log_pos 544 Xid = 18 COMMIT/*!*/; …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…table, it may last way too long for your 150 GB table! If you have inserted in an ascending … that table on a separate computer, maybe a replication slave. Can you make the reorganization run in … “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987, …
Post: How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
…id int unsigned auto_increment not null primary key); replica> INSERT INTO percona.test VALUES (1); master> INSERT INTO percona.test VALUES (1); replica> show slave status\G … Slave_SQL_Running: No Last…record from replication slave and replication…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…into special counter table, having say “id” and “counter” columns. Using separate…or simply the database which is not replicated) to log updates in heap… script which processes the views within last hour has to run rather complicated…shadow table” trick – use two tables insert into one and process and …
Comment: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… load balancing – my last proposal for the future of the PHP replication plugin….What?…Think of a global transaction ID as a unique… id BIGINT UNSIGNED NOT NULL. ENGINE memory ..INSERT INTO trx VALUES 0 ..When ever you commit a transaction UPDATE the trx id field ..UPDATE trx SET trx id trx id 1…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… (Google, Yahoo, MSN) provides real-time reporting last time I was involved with them (and … joins. Watch Data Types Does your ad ID look like “8a4dabde-1c82-102c-ab13-0019b984eacd” …Replication Building aggregated tables is hard work for the database server. If you do it on the master with INSERT…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…early stage) out performed InnoDB with INSERTS and UPDATES (but not SELECTS)…. completed at the beginning of last year with the implementation of … supports row-based replication which makes it possible to do replication while using … quite compact (especially when row IDs are consecutive) but this can…
