Re

Oracle is the most powerful database system in the world. However, Oracle's expensive and complex replication makes it difficult to build highly available applications or move data in real-time to data warehouses and popular databases like MySQL. 

In this video (recording of our live webcast on 10/18/12) you will learn how Continuent Tungsten solves problems with Oracle replication at a

Did you just run an UPDATE against your 10 million row users table without a WHERE clause?  Did you know that in MySQL 5.5 that sometimes you can recover from a bad UPDATE statement?  This is possible if you are running in binlog_format=ROW !

Imagine this scenario:

CREATE TABLE `t1` (
 `c1` int(11) NOT NULL AUTO_INCREMENT,
 `c2` varchar(10) NOT NULL,
 PRIMARY KEY (`c1`)
) ENGINE=InnoDB;
INSERT INTO `t1` (`c2`) VALUES ('michael'), ('peter'), ('aamina');

We run an accidental UPDATE statement that changes a row:

UPDATE `t1` SET `c2` = 'tom' WHERE `c1` = 2;

If we examine this UPDATE using the Binary Logging format of STATEMENT the entry would look like:

# at 464
#121019 16:10:42 server id 1 end_log_pos 532 Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1350677442/*!*/;
BEGIN
/*!*/;
# at 532
#121019 16:10:42 server id 1 end_log_pos 638 Query thread_id=1 exec_time=0 error_code=0
SET …

Percona has offered Training for years, and I have personally delivered my share of Public and Private training.  Below are my thoughts on the different training delivery options and how to choose the one that fits your needs.

The Onsite Public training is perhaps the most conventional type.  We get people from different people and go over our standard curriculum for the class  This is often the best choice when sending 1-2 employees, as they will likely establish connections with other students and benefit from their respective questions and comments –  This provides great insight and a much better learning experience.  Joining an Onsite Public course is also more affordable than Private Training too.  There are, however, downsid­­­es – one being its set curriculum.  We go over our …

MySQL Connector/Net 6.6.4, a new version of the all-managed .NET driver for MySQL has been released.  This is the Release Candidate intended to introduce users to the new features in the release.

Some of our users have faced the situation when they need to change the connection details of the existing Database Diagram file. Let’s assume the situation when you have several databases with identical schemas which are only located on different MySQL servers and you have created a database model that was saved in a Database [...]

A comment was recently posted on the MySQL User Group Wiki page about a new user group in the Netherlands available via Meetup.com.

I wanted to take a moment and say thank you and ask everyone to support this new user group.

If people are aware of any user groups not listed, please feel free to post on the wiki page this information.

While Flex Baumgartner was jumping from the outer space, bloggers of database technologies were adventuring into the vistas of new technologies and sharing their experiences through their blogs. This Log Buffer Edition jumps right into the middle of database blogosphere and brings you Log Buffer #291. Oracle: Jason Lamon is doing OpenWorld 2012 recap and [...]

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.1.0 GA, one of our newest products contained in the MySQL Installer suite.  This new version introduces the Edit MySQL Data feature.

You can download it from our official Downloads page at http://dev.mysql.com/downloads/installer/.

It has been several weeks since the last time I did a DB roundup, mostly due to travel. I spoke at Nagios World Conference 2012 at the end of September in St. Paul, Minneapolis, and then had a keynote and 2 talks at MySQL Connect, which was followed by Oracle OpenWorld and a Web Operations Team Meetup, which the DB team was invited to participate (and since I was in San Francisco anyway, I figured I’d stay for the meetup and the millionaire’s bacon (it was epic).
We have been busy, and getting some …

MySQL's support for case sensitive search is explained somewhat opaquely in the aptly titled Case Sensitivity in String Searches documentation. In short, it explains that by default, MySQL won't treat strings as case sensitive when executing a statement such as:

SELECT first_name FROM contacts WHERE first_name REGEXP '^[a-z]';

This simple search to look for contacts whose first name starts with a lower case letter, will return *all* contacts because in the default character set used by MySQL (latin1), upper and lower case letters share the same "sort value".

UPDATE: After many helpful comments from readers, it would seem the term I should have used was collation, not sort value. The documentation for both …