My presentation from the 2008 MySQL Conference on Top 20 Design Tips for Data Architects has been receiving a lot of traffic lately.
Most recently this presentation was featured on the front page of Slideshare, as well as last month I made the top 10 of Hacker News.
In response to a number of comments, I thought I would clarify the scope of my discussion regarding Options using MySQL pairs before I begin. As mentioned their is no one way or type of configuration for MySQL in a HA solution, however the simplest progression from a single Master/Slave environment is the concept of a pair of servers, configured to support a fail over and fail back via MySQL Replication.
The concept of a MySQL Pair in this context is to have a “hot” MySQL standby ready for controlled and hopefully! automated fail over. I say hopefully because with MySQL Replication as an asynchronous solution there is no guarantee for no loss of data.
I consider DRBD/Heatbeat for example a “cold” standby, as MySQL on the slave server is not actually running. DRBD does provide …
[Read more]MySQL 5.1 and MySQL 5.1 Connector/J 5.1 have been officially released. Connector/J 5.1 adds support for JDBC 4.0. You can download Connector/J and find out additional info regarding JDBC 4.0 support here.
MySQL 5.1 and MySQL 5.1 Connector/J 5.1 have been officially released. Connector/J 5.1 adds support for JDBC 4.0. You can download Connector/J and find out additional info regarding JDBC 4.0 support here.
MySQL 5.1 and MySQL 5.1 Connector/J 5.1 have been officially released. Connector/J 5.1 adds support for JDBC 4.0. You can download Connector/J and find out additional info regarding JDBC 4.0 support here.
MySQL 5.1 and MySQL 5.1 Connector/J 5.1 have been officially released. Connector/J 5.1 adds support for JDBC 4.0. You can download Connector/J and find out additional info regarding JDBC 4.0 support here.
Configuring a production environment using a pair of MySQL servers in a Master/Fail Over Master situation is a common process to provide many benefits including supporting failover, backup/recovery, higher availability for software & database upgrades. This is also a common method for database shards. One of the key hidden benefits is by performing regular controlled failovers for example with software upgrades you are actively testing your disaster recovery procedures. Most organizations have a partial plan, some don’t have any, but rarely do people test their disaster recovery.
There is no one way to configure and manage such an environment. There are a number of options including:
Some days ago, I released version 0.11 of mylvmbackup a Perl script that performs consistent backups of a MySQL server by using LVM filesystem snapshots. The source archive as well as a generic RPM can be found on the project home page, packages for many Linux distributions are available on the openSUSE Build service.
This release includes some new functionality as well as numerous bug fixes and improvements, most notably:
Some days ago, I released version 0.11 of mylvmbackup a Perl script that performs consistent backups of a MySQL server by using LVM filesystem snapshots. The source archive as well as a generic RPM can be found on the project home page, packages for many Linux distributions are available on the openSUSE Build service.
This release includes some new functionality as well as numerous bug fixes and improvements, most notably:
FOSDEM 2009, one of the biggest European Open Source conferences, will take place on February 7-8 in Brussels, Belgium. Today I received a confirmation from the organizers: MySQL will have a developer room on Sunday, the 8th! This is very cool.
My idea was to organize some kind of MySQL mini-conference, with a focus on developers and DBAs. I am going to send out a more formal CfP soon, but if you have any ideas or suggestions for a talks/sessions already, please get in touch with me!
In addition to the devroom, I have also been invited to give a talk about MySQL High Availability solutions in the conference main track. In this talk I plan to cover some commonly used HA setups for MySQL, including the OSS components/tools (for Linux and …
[Read more]