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:

• Develop your own home grown scripts
• Flipper by Proven Scaling
• …

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.

Installing Nginx With PHP5 And MySQL Support On Debian Etch

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Debian Etch server with PHP5 support (through FastCGI) and MySQL support.

Percona has a new Chief Operating Officer! It is Tom Basil, who was Employee #11 at MySQL and led the Support organization there for almost eight years. He was the founding Director of Support at MySQL, and built it into a team of about 60 people all across the world. Tom was legendary as a manager at MySQL, and we're really looking forward to his experience at Percona.

It sure is funny how things work out. When Peter and Vadim were at MySQL, Tom was their boss for 4 years. Now, Tom works for them! And Tom actively recruited me for a position at MySQL Support almost exactly a year ago, but I joined Percona instead. Perhaps we were meant to work together.

So, why did he resign from Sun/MySQL and come join us? In his own words, slightly paraphrased,

• Vision. Tom knows that we have replicated the vision of MySQL's own founders Monty and David, which was what drew him to work at MySQL in the first place. We're building our …

You remember our slogan “Freedom to work anywhere“, meaning that MySQL doesn’t require you to relocate to Uppsala, Cupertino, München or anywhere, to join the company? And that you sometimes can work even far away from home? Sun continued this policy, more or less. Now, Dups is taking the policy to extremes.

Background: As a colleague and fellow mountaineer, I had heard of Dups wanting to do some mountaineering in the Andes well before hearing that he would want to join the Community Team. And hence, it was an easy thing for Dups to convince …

The MySQL Connector/C++ Connector project has successfully reached its first major milestone by releasing its Alpha version.

The Connector provides a C++ implementation modeled after JDBC. This allows developers who have worked with JDBC to quickly take advantage of this Connector minimizing the learning curve.

The current release provides support for many of the methods found in the following JDBC interfaces:

• java.sql.Connection
• java.sql.DatabaseMetaData
• java.sql.Driver
• java.sql.PreparedStatement
• java.sql.ResultSet
• java.sql.ResultsetMetaData
• java.sql.Savepoint
• java.sql.Statement

Examples of using MySQL Connector/C++

Here is an example which connects to a MySQL Server, creates a table and then inserts a row into the table

      sql::mysql::MySQL_Driver *driver; …

Dear Lazyweb

I saw recently an interesting installation at a company. This company had databases in two different locations and they established a connection using SSH tunneling.

The thing that looked very interesting to me is, they setup a dedicated machine that had a MySQL instance on it. That database was mostly empty, but it had a port open on that machine that is a "virtual" tunnel. This allowed you to connect to the databases in the second location but it seemed as if the database is local to the network.
I believe this opens up a SSH tunnel and from my first impressions, it appears to be the case. My question is, how is that setup?

The MySQL Connector/C++ Connector project has successfully reached its first major milestone by releasing its Alpha version.

The Connector provides a C++ implementation modeled after JDBC. This allows developers who have worked with JDBC to quickly take advantage of this Connector minimizing the learning curve.

The current release provides support for many of the methods found in the following JDBC interfaces:

• java.sql.Connection
• java.sql.DatabaseMetaData
• java.sql.Driver
• java.sql.PreparedStatement
• java.sql.ResultSet
• java.sql.ResultsetMetaData
• java.sql.Savepoint
• java.sql.Statement

Examples of using MySQL Connector/C++

Here is an example which connects to a MySQL Server, creates a table and then inserts a row into the table

      sql::mysql::MySQL_Driver *driver;
 …

The MySQL Connector/C++ Connector project has successfully reached its first major milestone by releasing its Alpha version.

The Connector provides a C++ implementation modeled after JDBC. This allows developers who have worked with JDBC to quickly take advantage of this Connector minimizing the learning curve.

The current release provides support for many of the methods found in the following JDBC interfaces:

• java.sql.Connection
• java.sql.DatabaseMetaData
• java.sql.Driver
• java.sql.PreparedStatement
• java.sql.ResultSet
• java.sql.ResultsetMetaData
• java.sql.Savepoint
• java.sql.Statement

Examples of using MySQL Connector/C++

Here is an example which connects to a MySQL Server, creates a table and then inserts a row into the table

      sql::mysql::MySQL_Driver *driver; …