Historically it is tradition to start learning a new programming language by writing a 'Hello World' application.  While this is not a new language, we are certainly opening up a new communication channel so the title seemed appropriate.

MySQL has and continues to be the world's most popular open source database.  It  has millions of users and processes billions of records every day. The breath and scope of it's reach is truly staggering.  While many consider MySQL to be targeted primarily at Linux and other Unix variants, you may be surprised to find out that Windows is the most popular development *and production* platform for MySQL.  Take a second and go back and read that sentence again.

 Oracle has been very clear in it's commitment to MySQL and especially MySQL on Windows.  My name is Reggie Burnett and I lead a team that is on the front line of this effort.  My team and I are working on …

Historically it is tradition to start learning a new programming language by writing a 'Hello World' application.  While this is not a new language, we are certainly opening up a new communication channel so the title seemed appropriate.

MySQL has and continues to be the world's most popular open source database.  It  has millions of users and processes billions of records every day. The breath and scope of it's reach is truly staggering.  While many consider MySQL to be targeted primarily at Linux and other Unix variants, you may be surprised to find out that Windows is the most popular development *and production* platform for MySQL.  Take a second and go back and read that sentence again.

 Oracle has been very clear in it's commitment to MySQL and especially MySQL on Windows.  My name is Reggie Burnett and I lead a team that is on the front line of this effort.  My team and I are working on …

Weather is changing and so is the technology. They both never remain the same. There are lots of variations in both of them. Technological storms and innovative rains are making the blogging grounds more fertile, and this Log Buffer Edition is also sprinkling some seeds in Log Buffer #238. Oracle: He blogs less, but when [...]

You probably remember the world of new possibilities introduced to MySQL 5.5. If you do, you probably would agree that no API is useful by itself.

This is why you need authentication plugins that fit the largest possible number of authentication setups.

I can only guess what these authentication solutions look like for your server. But chances are that your OS has a pretty good idea on how best to authenticate users in it. This is why we've decided to hook MySQL to the two most widely used OS authentication APIs : Pluggable Authentication Modules (a.k.a PAM) and the Windows Security Support Provider Interface

Let's …

You probably remember the world of new possibilities introduced to MySQL 5.5. If you do, you probably would agree that no API is useful by itself.

This is why you need authentication plugins that fit the largest possible number of authentication setups.

I can only guess what these authentication solutions look like for your server. But chances are that your OS has a pretty good idea on how best to authenticate users in it. This is why we've decided to hook MySQL to the two most widely used OS authentication APIs : Pluggable Authentication Modules (a.k.a PAM) and the Windows Security Support Provider Interface

Let's …

Lateral SQL Injection in Oracle Database

Overview
=======

In order to get the system date in Oracle, you able to query for sysdate field in table dual.
SQL> select sysdate from dual;
SYSDATE
————–
15-SEP-11

SYSDATE format is set in: nls_date_format.

Following the publication: Lateral SQL Injection: A New Class of Vulnerability in Oracle, (http://www.databasesecurity.com/dbsec/lateral-sql-injection.pdf) published by David Litchfield, FEB/2008.

This post provides an overview and a demonstration on how this issue is still easily exploitable in Oracle Database.

Vulnerability
=========

Nls_date_format allows input of any string without filtering.
Example:  alter session set nls_date_format = ‘”the time is:”… hh24:mi’

After running that command, the SYSDATE will …

Last week we concluded our first Oracle Technology Network Sys Admin Day in Sacramento (CA). Well, it was actually the second Sys Admin Day, but the first one that had two parallel tracks of sessions about both Oracle Linux and Oracle Solaris.

I helped preparing for the event by creating the Linux lab handbook as well as the VirtualBox appliance of Oracle Linux 6.1 that was used for the exercises. Unfortunately I could not be there in person, but it would have been pointless for me to go on an intercontinental flight just for one day.

From the feedback we've received so far, the attendees really enjoyed the event and were positively surprised about the depth and quality of the practical hands-on lab sessions.

If you've missed the first one and happen to live …

Lee Margulin, Database Administrator at Zappos.com, talks about how Zappos uses Tungsten to replicate data between Oracle and MySQL. Tungsten Replicator is a high performance, open source, data replication engine for MySQL. It offers a set of features that surpass any open source replicator available today: global transaction IDs to support failover, flexible transaction filtering, extensible

Intro
The open source Tungsten Replicator is very powerful. It's exciting to see how a flexible initial design allows to push the boundaries of replication with each new release. The recently published System of Record approach for multi-master databases does exactly this for multi-master databases.

Nevertheless, in today's database environments it is often not enough to move data, however well it is done, between the nodes of a single DBMS vendor like MySQL.  There is an entirely new set of challenges that appear when Oracle joins the Enterprise room.

Free MySQL learning Part II from Oracle University

Register now!