On May 20th, Ulf Wendel and Andrey Hristov from the MySQL Connectors development team delivered a webinar around MySQL Connector/C++. We have another Connector/C++ webinar scheduled for July 9th (Thursday) at 10:00 AM PT. This time, I will be talking about the Connector/C++ driver for about 40 minutes. I am not involved with the development of Connector/C++ in any way. However I have been playing with, and evangelizing this driver for the past few months - so in a way I'm qualified to talk about the driver and its features. As of now, I have the following topics in the agenda.

* What is MySQL Connector/C++?
* High Level Architecture
* Installation, Dependencies
* Implemented Classes
    * Driver, Connection
    * Statement, PreparedStatement
…

Recently, we were updating our own database used for dbForge Data Compare for MySQL testing. I wanted to add several tables with data, using a dump file of one of the tables.

Problem
But how to drop a millisecond part in every pasted string, I mean a date like ‘2006-12-24 15:35:19.658′ should be replaced with ’2006-12-24 15:35:19′ one?

Any simple Find and Replace functionality won’t help, as I don’t know what to find and with what to replace.

Solution

So what did I do? I completed this task using dbForge Studio for MySQL and regular expressions.  Regular expressions provide a concise and flexible means for identifying strings of text of interest, such as particular characters, words, or patterns of characters.

…

As the part of FbFund educational seminars I will give a talk on MySQL Scalability for Facebook Application Developers. We have been working with number of top FaceBook applications and these are really fun to work with due to their commonly agile development approaches and explosive growth if it happens to be the hit.

The event will take place Tuesday July 7th at 10:00 - it will be 1.5-2 hours presentation followed by discussion with me, Vadim and Ryan participating from Percona side.

Entry posted by peter | 2 comments

Add to: …

Image by RaghuP via Flickr

It is important to realize that there is less diversity in the enterprise OLTP market than at any point in the last 20 years.  Essentially this market has been boiled down to Oracle, SQL Server & DB2 (with few isolated exceptions).   Most new deployments are typically using one of the first two options.  The lack of diversity has created a stalemate or chicken & egg situation.  Enterprises now only want to install new applications that have been built to support Oracle or SQL Server.  This is what most …

I have been speaking with a lot or new database vendors over the last 12 months and this has prompted me to revisit a post I wrote mid last year.  The basic premise of this post is that your strategy, and the group of people you’re selling to, largely depends on the market sector you are focusing on (Enterprise OLTP, BI/DW, Cloud & Web 2.0).

A database platform by itself is a largely pointless piece of software.  The only way value is produced from a database platform is through the applications that interact with it.  Therefore the only way to be a successful database platform is by making others successful and motivated to use your platform.

Ok, so as a database platform vendor how do you enter this market then? Well there are a few strategies.  Due to the length of this article I have broken it up into Enterprise OLTP, Enterprise Data Warehousing and Cloud & Web 2.0

Oh my. This is just immensely funny & sad at the same time - Amusing Database Videos http://www.bigdatabaselist.com/wiki/Amusing_Database_Videos

On May 20th, Ulf Wendel and Andrey Hristov from the MySQL Connectors development team delivered a webinar around MySQL Connector/C++. We have another Connector/C++ webinar scheduled for July 9th (Thursday) at 10:00 AM PT. This time, I will be talking about the Connector/C++ driver for about 40 minutes. I am not involved with the development of Connector/C++ in any way. However I have been playing with, and evangelizing this driver for the past few months - so in a way I'm qualified to talk about the driver and its features. As of now, I have the following topics in the agenda.

\* What is MySQL Connector/C++?
\* High Level Architecture
\* Installation, Dependencies
\* Implemented Classes
    \* Driver, Connection
    \* Statement, PreparedStatement
…

On May 20th, Ulf Wendel and Andrey Hristov from the MySQL Connectors development team delivered a webinar around MySQL Connector/C++. We have another Connector/C++ webinar scheduled for July 9th (Thursday) at 10:00 AM PT. This time, I will be talking about the Connector/C++ driver for about 40 minutes. I am not involved with the development of Connector/C++ in any way. However I have been playing with, and evangelizing this driver for the past few months - so in a way I'm qualified to talk about the driver and its features. As of now, I have the following topics in the agenda.

\* What is MySQL Connector/C++?
\* High Level Architecture
\* Installation, Dependencies
\* Implemented Classes
    \* Driver, Connection
    \* Statement, PreparedStatement
…

Some weeks ago I've resigned from Sun Microsystems, where I worked as a MySQL Telecom Sales Engineer. Beginning July 13th I will take on a new role in the MySQL ecosystem, as "Project Manager and COO" for Monty Program Ab.

Since it can be argued I'm moving to a competitor, and I was working in a customer facing role, upon resigning I had to immediately return my computer, phone, etc to Sun, and my login accounts, including email, were terminated. I've gotten some comments about this (like: "Is there no trust in the world anymore?" and "How can you treat anyone like that?") and I cannot stress this enough: This is normal, I expected it, indeed brought it to my managers attention myself. If nothing else, think of it this way: This precaution also protects me from any misunderstandings and/or false accusations. Besides, starting your vacation by returning your laptop and removing your email account isn't the worst thing to happen to you - try …

There are many features that are similar in MySQL and Drizzle. There are also many that are not.

I’ve previously discussed topics like Datatypes and tables, SQL_MODE and SHOW.

A key difference in Drizzle is the definition of utf8 as 4 bytes, not 3 bytes as in MySQL. This combined with no other character sets leads to an impact on the length in keys supported in Innodb.

During a recent test with a client, I was unable to successfully migrated the schema and provide the same schema due to unique indexes defined for utf8 VARHAR(255) fields.

Here is the problem. …