…to make the life of DBAs much easier when having to maintain servers under a specific replication topology. However you should keep… how to switch to…Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion Enabling GTID-based replication can be tricky if your…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…percona.com. My apologies if we weren’t able to get to your question during the initial session, so I’…master to slave, and if so, how? A: Yes. There are a few of ways to do it. One way is to set…OS-level status variables that you might want to keep an eye on to prevent a problem before it occurs. For…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…(RTT) between any two nodes in your cluster. Transaction apply on slave nodes is still asynchronous from client… of hotspots Example 1: Your application is an online game and you keep track of global achievement …adapt around it, but how might you do that ? Write to one node If your issue is really …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, care must be taken that your application or some other maintenance operation…keeps the certification interval small, which minimizes replication conflicts on a cluster where writes happen on all nodes. On a master/slave… and therefore time-consuming to the application. How to tell if flow control…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…an overview of how to install and run…to accessing the non-aggregated data. Keeping MVs up-to-date (refreshing) is usually expensive. A change data capture tool can be used to…to set up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to… your database. This isn’t anything to…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… slave could have an easier time keeping up with changes written by the master, and each slave would…couldn’t pick a slave at random, your application would need to direct queries to the slave(s) that have…in $_SESSION lead to local storage and limit scalabilty? A: It depends how you store $_SESSION. …
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
…. Especially if the slave‘s load is pretty uniform, a slave that’s at 90% of its capacity to keep up with the master can be indistinguishable from one that’s at 5% of its capacity. So how can you tell when your slave is nearing its capacity to keep up with the master? Here are…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…Keep those big fat log files out of the database. The database is usually the most expensive and hardest-to…your write workload exceeds the capacity of a single server (or if you’re using replication, the capacity of a single slave… to think about how to avoid enormous tables that are hard to …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…how to keep replication from lagging. The lag you will see will vary a lot from application to the application and from load to…to keep going. So if you want to keep replication lag under control you need to keep Slave…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… and is heavily writing using multiple threads, the slaves will likely not be able to keep up. Replication is not the only technology… skills and strong Sysadmin skills 7. How deep are your pocket? The last aspect that needs to be considered is the budget, complexity… some circumstances. Yves’s estimate is for a project to create a replication slave for HA purposes, not for “setting up replication…
