I realized recently from observation that some smaller websites which use MySQL do not have a working backup and recovery strategy. Some may have a backup approach but it will not work in a recovery. As part of a number of discussions on Backup & Recovery here is part 1.

Using straight ‘cp’ for Backup

Using ‘cp’ to simply copy your running database *DOES NOT WORK*. You may be lucky, but in a world of guarantees, this is no guarantee that your can recovery your system. Why is this so.

• The data is not consistent during the backup. If it takes say 5 minutes to copy your files, they are copied probably in alphabetical order, what if data is written during the backup to a table starting with ‘A’ and a table starting with ‘Z’, the A file has already been copied.
• When using MyISAM, Indexes are not flushed to disk unlike Table data. This means that while MyISAM has the facility of recover and …

While MySQL has successfully had a worldwide conference in the US for several years, we've also expanded our efforts internationally.  This fall we're now doing 3 one day conferences in Europe with sessions in London, Munich and Paris in October.  And we also have our first ever MySQL Conference in Japan in September.  Last year we also introduced our first ever MySQL Camp event, and …

Finally got around to reading Brad's article on Social Networks.

http://bradfitz.com/social-graph-problem/

I am not going to comment too much on his ideas. I thought he presented them in a very straight forward manner and I can notfind much of a reason to disagree with what he has said. I have concerns about how to control the information, but part of me just thinks that we shouldn't be too concerned with the privacy issue. Sign up and use it if you want to, otherwise reenter your information into each system you want to use.

Ease of use wins over privacy for a lot of people.

When I implemented Zoo for Slashdot back in 2003 (or was it 2002?) I made a point of making all of the social graph public:
http://slashdot.org/~krow/zoo/

You can …

il corra walks you through building mysql-proxy for ubuntu.

il corra » mysql-proxy on ubuntu 7.04 feisty

First of all, there is not a packetized mysql-proxy for Ubuntu, so the only way to install it is to build it from the source

Which is great. But I'd like to take this opportunity to tell people that I've actually been working on packages for debian/ubuntu. They're almost ready to be released into the wild (I'm waiting on an almost non-related event) If you'd like to play with the packaging stuff before then, check out http://launchpad.net/mysql-proxy

I'll be sure to let everyone know when the packages themselves are in an APT repository.

MySQL data service running on a clustered-server model provide orderly startup, shutdown, fault monitoring, and high availability(failover) mechanism compared to the single server model. It can be free donwloaded, and Sun also released Open HA cluster, derived from the Sun Cluster 3.2 agents including HA MySQL data service. The open HA cluster also provide build tools necessary to develop new features, build and use the code. In addition, Sun cluster 3.2 Data service for MySQL has the advantages including:

• It is easy to install and configure with straightforward GUI and command line interfaces.

• Expanded support for Solaris Containers(Solaris zones)

• Expanded support for SMF

• ZFS is fully supported as a local highly available …

Well, today is the official end of coding for the Summer of Code and I am pleased to let everyone know that the MySQL Test Creator, a lua script that integrates with the MySQL Proxy, is indeed working and creating test scripts. So, that being said I wanted to run down some of the features that have been implemented to increase test creation productivity and ease.

http://code.google.com/p/mysql-test-creator/

First of all, what my project does is using the MySQL Proxy, it intercepts queries between the client and the MySQL backend and records the query plus its result in a fashion acceptable to mysqltest. There is a `START` and `STOP` mechanism that allows the user to selectively record within whatever window necessary to the creation of the test case and all of the meat of this tool happens in this recording window.

Mysqltest's …

A buddy of mine from Borland days, Ben Riga, is helping to drive the content for Microsoft's Mix '08 conference. He's looking for input on what would make Mix attractive to startups and venture capitalists. To be honest, I haven't seen a lot of startups using the Microsoft stack in recent years. I'm sure there are plenty, but it seems at least at first glance, there's far more innovation happening over on the LAMP stack (Linux, Apache, MySQL, PHP) and with other emerging languages like Ruby on Rails, Scala, etc. Still there's no reason that Windows as a platform couldn't... READ MORE

MySQL data service running on a clustered-server model provide orderly startup, shutdown, fault monitoring, and high availability(failover) mechanism compared to the single server model. It can be free donwloaded, and Sun also released Open HA cluster, derived from the Sun Cluster 3.2 agents including HA MySQL data service. The open HA cluster also provide build tools necessary to develop new features, build and use the code. In addition, Sun cluster 3.2 Data service for MySQL has the advantages including:

• It is easy to install and configure with straightforward GUI and command line interfaces.

• Expanded support for Solaris Containers(Solaris zones)

• Expanded support for SMF

• ZFS is fully supported as a local highly available …

MySQL data service running on a clustered-server model provide orderly startup, shutdown, fault monitoring, and high availability(failover) mechanism compared to the single server model. It can be free donwloaded, and Sun also released Open HA cluster, derived from the Sun Cluster 3.2 agents including HA MySQL data service. The open HA cluster also provide build tools necessary to develop new features, build and use the code. In addition, Sun cluster 3.2 Data service for MySQL has the advantages including:

• It is easy to install and configure with straightforward GUI and command line interfaces.

• Expanded support for Solaris Containers(Solaris zones)

• Expanded support for SMF

• ZFS is fully supported as a local highly available …

If you have an Ubuntu 7.04 Feisty Linux Distribution and you are planning to install mysql-proxy in order to test the new proxy functionalities, maybe you will have some problem. I use Ubuntu 7.04 on my laptop, with all packets installed and configured correctly using Synaptic Packet Manager and, in fact, I had problems! If you won’t have problems … well … I’m unlucky!

First of all, there is not a packetized mysql-proxy for Ubuntu, so the only way to install it is to build it from the source you can get from MySQL website.

mysql-proxy needs the LUA scripting language in order to work correctly. LUA is the milestone, the tool to write configuration scripts to instructs mysql-proxy what to do receiving packets to and from the MySQL server. LUA is the key to achieve great tasks from …