…to MySQL Replication based solution. With MySQL Replication you have to have one Master node which handles traffic. You may be able to send some traffic to Slaves…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…to run the master and slave IPS and will accept writes. But what could happen with Galera replication…switch…And if you test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…replicating out to all slaves mysqlbinlog 5.6 Last year Percona IT director Tamas Kozak had a great blog post that showed how…master and slave Re-transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…MySQL replication…switch between different modes on successive queries. Q: Is RBR faster replicating vs SBR replication…to the slave‘s system clock and get a much more reliable measure of slave lag (assuming the system clocks on master and slave…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…master-master and bunch of slaves. Typically you would define “roles” for example READER and WRITER roles for most simply case and assign them to…switch happens “dirty” way potentially risking replication inconsistencies. This is very handy if you want to restart one of servers in clusters to…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication…to watch the traffic on the active master and replay SELECT queries against the passive one. I timed the results and…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
…switch from MyISAM to Falcon. It was rather interesting to hear a lot about features of new storage engines such as Nitro and…MySQL Enterprise from MySQL Marketing Materials . There is not much of technical insight otherwise – pretty simple site, master slave replication, plans to…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…switch to the slave in this case is not very easy too – all slaves can be on different positions at the master and you need to…master (and they will be replicated down to all slaves) the faster however (especially if you have many tiers of replication) is to bring all slaves to…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…replication slave. Can you make the reorganization run in a tolerable time? PZ: Indeed using master-master setup and switching roles is a good way to get large data manageable. MySQL Master Master Manager can help you to…
Comment: Small things are better
October 10, 2006 By 15 Comments
…and processors, in a dual-master-slave configuration. One acts as a primary and one as a backup. If one fails, I can switch over to… to the other. But then the problem is, how… a third and fourth replication slave, one on-site and one off… shut down MySQL on one of the backup slaves and synchronize the…
