SkySQL™ Cloud Data Suite now comes with 4 nodes system on AWS Plus: AWS tips & tricks, updated administration console, new video tour & more

As with all new open source software products, updates are a continuous process and we’ve been busy since the launch of the SkySQL™ Cloud Data Suitelast September! Here is a snapshot of the latest developments with our Cloud Data Suite, a collection of software components that provides a highly available database solution in a cloud environment, based on MySQL & MariaDB, deployable in the Amazon Cloud, i.e. AWS.

read more

I may not work on many MySQL related things any more but there are some MySQL ecosystem events that I am participating in.

First there is Percona Live London.  This event is on the 3rd and 4th of December at The Millennium Gloucester Conference Centre.  At this event I will be giving a talk on MySQL Compatible Open Source Connectors.  This will cover alternatives to the standard connectors and how to use them, it will be useful if you find the licensing behind the standard connectors prohibiting.  There is also a 40% off discount code you can use when registering, simply enter the promo code "Come2mytalk".

On the 2nd and 3rd of February is FOSDEM.  At …

The M of the LAMP stack and the #1 database for Web-based applications, MySQL is also an extremely popular choice as embedded database.

Access our Resource Kit to discover the top reasons why:

• 3,000 ISVs and OEMs rely on MySQL as their embedded database
• 8 of the top 10 software vendors and hundreds of startups selected MySQL to power their cloud, on-premise and appliance-based offerings
• Leading mobile and SaaS providers ensure continuous service availability and scalability with lower cost and risk using MySQL Cluster.

Learn how you can reduce costs and accelerate time to market while increasing performance and reliability. Access white papers, webinars, case studies and other resources in our …

B-Tree Index As MySQL's default index type, a b-tree index is reasonably fast to insert new items into, and is fast at looking up individual items or even ranges.  The index is stored as a branching tree, so looking up any one item is not an expensive operation.  Each level of branching allows an order of magnitude more items.  It's not always the best solution, but in some cases it may be the

If you plan to use the MySQL Workbench Migration Wizard to migrate databases from PostgreSQL to MySQL you first need to configure an ODBC driver to connect to your PostgreSQL server.

In this post I’ll cover how to set up and configure psqlODBC, the official ODBC driver for PostgreSQL.

Installing the psqlODBC Driver

The procedure is different for every platform so make sure to follow the instructions that correspond to the OS where you have MySQL Workbench installed. The driver needs to be installed in that machine, as explained in the MySQL Workbench documentation.

Windows

If you are running MySQL Workbench on Windows download the MSI package for psqlODBC. Go to its download page ( …

2013 is near… and so is the next FOSDEM edition !

This year again, MySQL will be represented by its Community.
If you want to discuss with friends of MySQL it’s the place to be in
February !

Like every year, FOSDEM takes place the first week-end of February in
Brussels.

We will again have a room in the H building (100 seat). The MySQL &
Friends dev room will be open all day Sunday, February 3rd.

Call for Papers is open until December 21st here.

This year all submissions will be reviewed by a committee that will
create the schedule.
The committee is composed by :

* Andrew Hutchings (HP)
* Andrew Morgan (Oracle)
* Sergey Petrunia (MariaDB) …

For those who do not read opensqlcamp group — CfP for FOSDEM 2013 conference is open!

Original email from lefred:

“2013 is near… and so is the next FOSDEM edition !

This year again, MySQL will be represented by its Community.
If you want to discuss with friends of MySQL it’s the place to be in
February !

Like every year, FOSDEM takes place the first week-end of February in
Brussels.

We will again have a room in the H building (100 seat). The MySQL &
Friends dev room will be open all day Sunday, February 3rd.

Call for Papers is open until December 21st

https://docs.google.com/a/percona.com/spreadsheet/viewform?formkey=dHF5VXdwa2FGUHIzTGI3ZGE4MkpaS2c6MA#gid=0

This year all submissions will be reviewed by a committee that will
create the schedule.
The committee is composed by :

* Andrew Hutchings (HP)
* Andrew …

Money has proclaimed being a Database Administrataor as being the fifth best job in America. And they are telling the world exactly what we do, well as best they can in very few words.

What they do all day? It’s no understatement to say that corporate America is in the middle of an information explosion. Somebody has to keep track of it all. A database administrator (DBA) minds all the data in a company’s storehouse, keeps it safe and makes sure it’s easily accessible.

But what if you are not a DBA already?

How to get the job? A degree in computer science is recommended, followed by years of experience. Many employers require certification in the most widely used programs, including MySQL, Oracle and DB2. And since the technology is always changing, re-training is a constant.

So why would …

Three ways to rename a MySQL database 1. Table renaming For InnoDB, the following seems to work: create the new empty database, then rename each table in turn into the new database: RENAME TABLE old_db.TABLE TO new_db.TABLE; After the rename you have to adjust the permissions of the table! To generate a script to generate [...]

Last month Ubuntu 12.10 was released and we tried to install MySQL Workbench on it. So we went to http://www.mysql.com/downloads/workbench/ and downloaded the .deb file for the most recent Workbench version (5.2.44 as of this writing). We then opened the .deb file with the Ubuntu Software Center application and tried to install it. Unfortunately the following message appeared:

Dependency is not satisfiable: libctemplate0

The problem here is that the libctemplate package provided by Ubuntu 12.10 corresponds to a higher version (libctemplate2). Installing this version instead wouldn’t work since MySQL Workbench is linked against the older one. We’ll handle this dependency issue in future releases, but here’s a workaround:

Download the …