Advanced Total found: 98
Posts (67) Pages (1) Comments (30)

November 13, 2009

Post: Finding your MySQL High-Availability solution – Replication

Posted by Yves Trudeau |
In the last 2 blog posts about High Availability for MySQL we have introduced definitions and provided… Cons Simple Variable level of availability (98-99.9+%) Inexpensive Not suitable for high write loads All the servers can be used…

October 16, 2009

Post: Finding your MySQL High-Availability solution – The questions

Posted by Yves Trudeau |
… some questions. Do you need MySQL High-Availability? That question is quite obvious…s list the most common ones: - MySQL replication with manual failover - Master-…  Write capacity MySQL replication Fair Master-Master with …

October 9, 2009

Post: Finding your MySQL High-Availability solution - The definitions

Posted by Yves Trudeau |
As my first contribution to the MySQL Performance Blog, I joined Percona at …  computer architecture designed to improve the availability of a computer service, like a … our case, dedicated to high availability of the MySQL database service. With theses …

June 17, 2010

Post: High availability for MySQL on Amazon EC2 - Part 1 - Intro

Posted by Yves Trudeau |
… true. Amazon has also some drawbacks, availability is not guaranteed and discovery protocols …easy to have a truly highly available solution for MySQL on EC2. If a … monitoring script Part 6 – Publishing the MySQL server location Part 7 – Pitfalls to …

February 1, 2009

Post: Faster MySQL failover with SELECT mirroring

Posted by Baron Schwartz |
… of my favorite MySQL configurations for high availability is master-master …in both directions. Aside from MySQL Cluster, which is more special…to keep everything on its feet. If you need really high…I used — it could be MySQL Proxy or a TCP sniffer…

June 29, 2010

Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances

Posted by Yves Trudeau |
…-lucid-daily-i386-server-20100618 099720109477 available public i386 machine aki-aca44cc5 instance-…1 Resources configured. ============ Online: [ monitor hamysql ] Install MySQL For the sake of simplicity, we…

July 12, 2010

Post: High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources

Posted by Yves Trudeau |
…crm configure crm(live)configure# primitive mysql ocf:heartbeat:anything \ params binfile=”/usr…crm(live)configure# location loc-1 mysql 1000: hamysql crm(live)configure# … but, if hamysql is not available, will be able to run …

March 10, 2009

Post: Percona at PHP Quebec 09

Posted by Morgan Tocker |
Percona presented two talks at PHP Quebec last week – one on A Tour of MySQL High Availability, and another on Performance Tuning MySQL. There was a great reaction to showcasing some of the quick-wins that can be …

October 27, 2009

Post: State of the art: Galera - synchronous replication for InnoDB

Posted by Vadim |
…Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as … Any of N standby nodes are available immediately when main node fails. Galera…/2009/10/16/finding-your-mysql-high-availability-solution-%e2%80%93-the-…

July 31, 2006

Page: Consulting for MySQL

Posted by peter |
…Scaling Consulting – Hardware and OS configuration, MySQL Server Configuration, Schema, Queries, Application Architecture, Caching etc. MySQL High Availability design and implementation Design … with large data sets in MySQL or how to optimize queries …