…seen situations where even under just a moderate load on the host system, DRBD can end …and configured with Linux network interface bonding in balance-rr mode; this is the only NIC bonding…replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave. I wonder …a raid10 for the binlog (yeah I know, not very balanced in terms of I/O). mysqlslap –concurrency=25,50,…-sql-load-type=mixed –number-of-queries=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1….
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… roundtrip because of a loadbalancer and scalability of PXC’s load balancing layer scales simply with application servers. We will use Percona… log_bin=mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql wsrep_slave_threads=2… MySQL you can break the privilege system’s host part, because MySQL will think that the connections are always coming from the load balancer…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
…, application servers etc. We can put these behind some simple load balancer which can provide both high availability and fault tolerance. Technology… performance problems are also handled different way – the load balancer typically can monitor load of the node and do not send new requests… tricky. Not only Failover process for MySQL replication is tricky it can be long – consider slaves lagging and need few minutes to…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
… using MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave… handled by some server, so you can use DNS for load balancing without worrying about TTL and similar things. If Active server… happen within few seconds. Such IP based high availability and load balancing does not require any extra hardware or software and works…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data. It is true delay is often insignificant but in times of heavy load or… queries on the master and non time critical on the slave, or balance them if you have underloaded master. For example search…
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
… Facebook MySQL experts: Domas Mituzas, Database Engineer Harrison Fisk, MySQL Performance Engineer Yoshinori Matsunobu, Database Engineer Their breakout session is entitled “MySQL at… logical database from on MySQL master A (and its slaves) to another MySQL master B (and its slaves) to balance the load and the two parts…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… include load-balancing and failover features, but these features don’t seem to measure slave lag. They seem to assume that all slaves are… production. Even the official manual page for MySQL Proxy 0.8.2 still says: “MySQL Proxy is currently an Alpha release and… a number of “unsafe” slaves going to be a high performance cost? A: Connecting to a MySQL database isn’t a great…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… replication mysql> STOP SLAVE; we don’t want schema changes to be replicated to db1 now. 3. on db2: load the sql scripts $ mysql… on our blog. When new changes are loaded: 4. on db2: start replication mysql> START SLAVE; On step #1 MMM should have stopped…. you must change application to use different IP for MySQL or ensure some load balancer/proxy does this, set read-only manually on…
Comment: mysql-proxy, urgh performance and scalability ?
March 6, 2012 By 44 Comments
Hi, Still waiting on some feedback. Would really appreciate if anyone knows about a hardware load balancer that can manage load balancing among slaves, as I am not keen on using mysql proxy. Thanks
