… it. Basically the steps are: Make the master read-only so that the slaves can execute all events and be in sync with… MASTER TO to instruct all servers to use GTIDs Disable read-only mode This procedure will switch all your servers from regular… to make the master read-only? Can we use regular replication for some slaves and GTID replication for other slaves at the same time…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… looking for the binlog position of a specific event. The only part were we should pay attention is the server we… up-to-date slave and reconfigure the other slaves as we did above. So we will suppose that we can read the binary logs of the crashed master. The first thing to do after choosing which slave will be…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to… something you’re not that familiar with, I’d suggest reading over the manual’s description of how replication filtering rules…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
…, which is coming soon. 2. OmniOS rocks. It is the only stable illumos distro designed for server usage, and it can… quit, so I consider that pretty much dead project. The only thing I don’t like about OmniOS is that the…. RSF-1 costs a lot. So OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the…. Bugs fixed #1131189 (Alexey Kopytov). In the event that a slave was disconnected from the master, under certain conditions, upon reconnect…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the…. Bugs fixed #1131189 (Alexey Kopytov). In the event that a slave was disconnected from the master, under certain conditions, upon reconnect…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… you only write to a single node in PXC, then it is recommended you disable this feature by setting fc_master_slave… the cluster might have applying cluster transactions. Therefore, it keeps reads more up to date without needing to use wsrep_causal… a master/slave cluster, therefore, it’s reasonable to increase the fc_limit because the only lagging nodes will be the slaves with…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…Software Repositories. Percona XtraBackup is the world’s only open-source, free MySQL hot backup software …information can be used to create/restore a slave can be found in this blogpost. Percona … innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… the slave: slave> set global GTID_EXECUTED=”9a511b7b-7059-11e2-9a24-08002762b8af:1-14″ ERROR 1238 (HY000): Variable ‘gtid_executed’ is a read only variable Error! Remember, we get the GTID_EXECUTED from the master and set is as GTID_PURGED on the slave… SET because is a read only variable. The only way to change it is with reset master (yes, on a slave server): slave1> reset…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… need more. So here comes the bigger boxes, the read-only slaves, the complex sharding systems, the discussions on cluster, more… that reads two rows, and update one of them to read from memcached if available, remove on update, and read from the db only… must need more. So here comes the bigger boxes, the read-only slaves, the complex sharding systems, the discussions on cluster, more memcached…
