… have my website develop in PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout… default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not… = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start the…
Page: Consulting for MySQL
July 31, 2006 By
… your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL Replication…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… a cadre of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the future, and…, and submit those session and tutorial proposals on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… we’re comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while… DRBD do not spread too wide. So when I would recommend to use DRBD with MySQL ? There some good reasons to use DRBD with MySQL… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
Post: Data Corruption, DRBD and story of bug
November 29, 2010 By 6 Comments
… use DRBD for HA purposes ( as is in the case I worked with), you screwed, as DRBD mirroring physical data, and MySQL keeping crashing on both instances – active and passive. So DRBD can’t be considered…. It has MySQL version 5.6, but the problem exists in MySQL 5.1.50 or below and in MySQL 5.5, and…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…, average MySQL DBA + good Sysadmin skills Heartbeat/SAN (depends on SAN) High, Good MySQL DBA + strong Sysadmin skills Heartbeat/DRBD High, Good MySQL DBA + strong Sysadmin skills NDB Cluster Very high, Specific NDB knowledge, strom MySQL skills…
Post: Is DRBD the right choice for me?
July 7, 2009 By 17 Comments
… points: DRBD‘s aim (assuming replication mode C) is to provide 100% consistency, and then as much uptime as possible. MySQL Replication… explain the full picture. The typical crash recovery process in DRBD is a lot longer: After resource transfer, a filesystem check…: If you have an application that requires 100% consistency, then DRBD is one of your best choices on the mysql-market today.
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
… Haas with his talk MySQL High Availability Sprint: Launch the Pacemaker! will talk about MySQL High Availability using DRBD and Pacemaker (Heartbeat) which have been a high availability solution of choice for MySQL with Innodb…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
…) options available for MySQL. I have done dozen of MySQL HA related engagements while working for Sun/MySQL over the last couple of years using Heartbeat, DRBD and NDB… first DRBD based HA solution nearly 10 years ago. There is quite a lot of confusion surrounding HA solutions for MySQL, I…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… what is the most popular HA solution for MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest… used. The following figure summarize the simplest HA architecture using MySQL replication. All writes are going to the master while reads…, I’ll present another HA solution build around Heartbeat and DRBD.
