MySQL on Amazon S3: ClouSE version 1.0b.1.4 is released

OblakSoft is pleased to announce the release of ClouSE version 1.0b.1.4.  In this release we fixed some of the known ClouSE Beta limitations that required workarounds in some configurations.

In particular, now the popular BuddyPress WordPress plugin can store its tables in ClouSE without a patch that worked around the missing features.  If you’re using the patched version of BuddyPress 1.6.1 provided by us, you can now upgrade ClouSE and use the original BuddyPress sources.  Thank you for your patience and commitment!

Here is the summary of changes:

• Support for latest MySQL 5.5

Now ClouSE supports MySQL thru 5.5.28.  To keep the distribution small, we don’t build binaries for MySQL prior to 5.5.17 …

How do you connect to and converse with your database of choice (MySQL, in my case)? Chances are it’s largely formed by the programming language you choose. I’ve worked with a variety of programming languages. Anytime I begin learning a new one, I am reminded again that there’s more than one way to skin a cat. Over the last few years, I’ve mostly programmed in Perl and shell. The shell interface to MySQL is simple: the mysql command-line tool.

A problem that sometimes when writing queries or stored routines is the need to use strings to do basic manipulation of the data. While from a performance perspective it is generally faster to do these manipulations inside the application, for various reasons it may be desirably to keep things inside MySQL.

This post lists two stored functions that can be used for simple manipulation of strings.

substr_count()

This is a port of the PHP function of the same name. It counts the number of times a given substring is encountered in a text. The signature is:

substr_count(
   in_haystack mediumtext,
   in_needle varchar(255),
   in_offset int unsigned,
   in_length int unsigned
) RETURNS int unsigned

The function as it stands here, has the following limitations and behaviours:

• As the MySQL convention is to use 1 as …

After reading a blog post about MySQL Tuning scripts I thought about the possibility of a fully Automatic MySQL Tuner.

This is how it would work:
A daemon which would connect to your database server and then fetch status variables, just like mysqltuner and such. Then the daemon could decide that a parameter would need to be adjusted and then run "SET GLOBAL …" and write a /etc/mysql/autotuner.cf file which should be included in your my.cnf.

It should have a min/max setting for each option and some thresholds.

Why?

• Not everyone is a DBA
• It's could better than the default settings is most cases. Luckily many defaults are updated in 5.6.
• You're not using my-huge.cf, are you?
• It could help when there are changing workloads
• It might be sufficient for …

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.