Surely if it is “Meet the MySQL Experts” podcast it should include the experts that are also part of the wider MySQL ecosystem, not just the ones inside Oracle?

Otherwise it probably should be “Meet the Oracle Experts”.

(also, the answer to "why isn't it meet the Oracle experts?" is because then you wouldn't find it by searching for "MySQL". "Meet the MySQL experts at Oracle" is a bit long and awkward.

Also, perhaps they'll interview community members when appropriate, such as when they put a community feature back into MySQL. Such as an interview with a patch submitter plus the person who decided "yes, let's put that in".

And I'll iterate again, Oracle already sponsors a community podcast, so if you'd like the Oracle community podcast to interview a MySQL Expert, let us know what topic and whom you'd like us to interview. www.oursqlcast.com has an "About" link where you can find contact information.

Thanx for the shout-out! If you have a promo blurb we'll play it on the podcast, and we'll be sure to mention it in our news section.

Also, LinuxJedi -- Yes, it's "Meet the MySQL Experts at Oracle" -- because Oracle is producing it! If Percona did a "Meet the MySQL Experts" you probably wouldn't see any Oracle personnel showing up on the podcast (though you would see other community/corporate folks like Ronald Bradford, SkySQL folks, etc).

Is the name potentially misleading? Yes. Is it *intentionally* misleading? Absolutely not, and I can say this with certainty because if Oracle intended to mislead people to think it wasn't just folks who work for the MySQL part of Oracle, you wouldn't have seen this description, and you would have to listen to several podcasts before realizing that hey, they're only going inside Oracle.

LinuxJedi, there's a very large team of MySQL Experts at Oracle, working hard to drive MySQL innovation in different areas. We got feedback earlier that Oracle should communicate more about the work they do, and we are now doing so via this podcast.

FYI I'm about go offline on vacation now so I will no be able to address any other comment for a while.

Hi Bertrand,

Thanks for your response.

I wasn't debating the content, just the name.

So, to be clear. You are saying that by calling it “Meet the MySQL Experts” all experts are equal, but some are more equal than others?

Thank you for your comment LinuxJedi. A primary objective of this podcast is to share more information with the wider MySQL ecosystem about what the MySQL Experts at Oracle are working on. Perhaps down the road we'll enlarge the scope, but Sheeri and Sarah's OurSQL podcast also gives voice to the wider MySQL ecosystem, so it's a good complement.

If you have two or more database servers containing the same data, how do you know if the objects are identical. Furthermore, how can you be sure the data is the same on all of the servers? What is needed is a way to determine if the databases are in synch - all objects are present, the object definitions are the same, and the tables contain the same data. Synchronizing data can become a nightmare without the proper tools to quickly identify differences among objects and data in two databases. Perhaps a worst case (and more daunting) is trying find data that you suspect may be different but you don’t have any way of finding out.

This is where the new 'mysqldbcompare' utility comes in handy. The mysqldbcompare utility uses the mysqldiff functionality (mysqldiff allows you to find the differences in object definitions for two objects or a list of objects in two databases) and permits you to compare the object definitions and the data …

I love short and consist install instructions. I know this is a MySQL blog but our good friend PostGreSQL has a great GIS library. This is what I learned upgrading our PostGIS system to GIS 1.5. Much thanks to Jeremy Tunnell for give this document it’s start.

Start with CentOS 5.6 x86_64 basic install.

Add the PostgreSQL Yum repository to your system.

$ wget http://yum.pgrpms.org/reporpms/9.0/pgdg-centos-9.0-2.noarch.rpm
 $ rpm -i pgdg-centos-9.0-2.noarch.rpm

Another location for these is DAG. I have to tried these so your results may very.

You will need to exclude the packages CentOS provide by added two lines to the BASE and UPDATE sections of /etc/yum.repos.d/CentOS-Base.repo. They are:

exclude=postgresql*
exclude=geos*

You you are ready to install the needed packages. This includes proj version 4 and geos version 3.

 $ yum install postgresql90-contrib.x86_64
 $ yum …

If you used to write MySQL joins for MySQL versions < 5.0 or upgrade your server from MySQL 4 to MySQL >= 5.0 you maybe run into a problem when you execute the following query:

SELECT *
FROM mytable1, mytable2
INNER JOIN mytable3
ON mytable1.mycolumnname = mytable3.mycolumnname
WHERE mytable1.id = mytable2.id;

#1054 – Unknown column ‘mytable.mycolumnname’ in ‘on clause’

Even though you made sure that the column exists, the problem persists. It can be a very annoying and time-consuming task to track this kind of error down to it’s cause: MySQL starting from version 5.0 tries to be more compliant to ANSI SQL. The tables are beeing joined in a different order. The solution to this problem is actually very simple. Surround the tables in the FROM clause with round brackets:

SELECT *
FROM (mytable1, …

The latest (GA) version of MySQL Cluster Manager is available through Oracle’s E-Delivery site. You can download the software and try it out for yourselves (just select “MySQL Database” as the product pack, select your platform, click “Go” and then scroll down to get the software).

So what’s new in this version

If you’ve looked at MCM in the past then the first thing that you’ll notice is that it’s now much simpler to get it up and running – in particular the configuration and running of the agent has now been reduced to just running a single executable (called "mcmd").

The second change is that you can now stop the MCM agents from within the MCM CLI – for example "stop agents mysite" will safely stop all of the agents running on the …