Slight adjustment to some of the times + added the MySQL community reception (read  vodka!). Oracle OpenWorld (San Francisco) starts on Sunday 2nd October (including some MySQL community sessions) through Thursday 6th October. MySQL has a lot of sessions this year as well as 3 demo booths.

This year I’m going to be involved in 3 public sessions – if you’re attending, please come along and say hello!

• Getting the Most Out of MySQL on Windows – 13:15 on Tuesday (Marriott Marquis – Golden Gate C2)
• Building Highly Available and Scalable Real-Time Services with MySQL Cluster – 10:15 on Wednesday (Marriott Marquis – Golden Gate C1)
• NoSQL Access to MySQL: The Best of Both Worlds – 11:45 on Wednesday (Marriott Marquis – Golden Gate C1)
• MySQL Community Reception – 19:00 …

In our last episode we found out how to connect to a MySQL server.  This time we learn how to lay out a database and start creating it. For this, and following episodes, we will be looking at creating a database to support an online bookshop.

Creating the database

Using the mysql command line client, you can connect to the server and then create the database.  We need a name for the database, and in this case we'll call it 'bookshop'.   We'll also create a user who is specifically allowed to add and update the database, but not alter its structure:

mysql> CREATE DATABASE `bookshop`;
Query OK, 1 row affected (0.01 sec)

mysql> GRANT INSERT, SELECT, UPDATE, DELETE ON `bookshop`.* to 'bookuser'@'localhost' identified by 'bookpass';
Query OK, 0 rows affected (0.00 sec) …

I was checking a third party server, and I needed to find if there were tables without primary keys. This is important to know, not only because the lack of primary keys affects performance and data accuracy in general, but also because in row-based replication performance can degrade beyond belief when updating tables without primary keys.Anyway, I did not remember off the bat any method to get this information from a server with thousands of tables, and thus I went to find a solution on my own.My first instinct called for using the COLUMNS table from the INFORMATIOn_SCHEMA, and so I came up with this query, where I sum the number of columns that are inside either a PRIMARY or UNIQUE key and filter only the ones where such sum is zero (i.e. no primary or unique keys):

select 
 …

I wonder whether Java/JDBC developers would prefer it if there was a way to access all SQL database metadata through a data structure as simple as a built-in Java object. This is how we provided access to our own metadata to Lua: tuple spaces are exported as nested Lua objects, with methods or members used to query properties and configuration parameters, iterators to go after the whole data set, built-in metamethods integrating our user-defined types with the rest of language primitives ("for" loops, print and length operator, and so on).

Hey, to print the whole configuration down in Lua one can do this:

for name, value in pairs(box.cfg) do print(name, "=", value) end

To grab a handle on an an index in a given tuple space on just writes:

index = box.space[0].index[2]
tuple = index.find(key)
for field in ipairs(tuple) do print(field) end

And Lua, as a more modern …

I know most articles are more about DBA issues, however, being a MySQL DBA means that you have several hats that you can where– data architect, application developer, MySQL source developer, and often good old fashioned DBA. I recently had an interesting problem with a particular project I was working on that required the MySQL source code developer hat that I used to wear much more often during the black vodka era of working for MySQL AB.

This was case of a custom storage engine a client has, and whenever I would try to use statement-based replication, I would encounter an error upon running DML statements on the master:

ERROR 1598 (HY000): Binary logging not possible.
Message: Statement-based format required for this statement,
but not allowed by this combination of engines

Despite having worked on several storage engines, written Federated/FederatedX, I couldn’t remember what about a storage engine pertains to …

While the online content catalog and schedule builder are great tools to help plan out what sessions I want to see at Oracle OpenWorld, what I really want is a matrix of only the MySQL content, preferably in a matrix that easily shows all the sessions per time period.

So I decided to make the matrix myself - view the HTML online at http://technocation.org/files/doc/2011_OOW_MySQL_Content.html

Or download a PDF (one page per day) at  …

In this article I will describe how to test the plain and the encrypted SMTP/POP3/IMAP and HTTP protocols with telnet and the openssl s_client command.

list of references

For a complete list of available commands for the used protocols check the RFCs please:

• RFC – Post Office Protocol – Version 3
• RFC – Simple Mail Transfer Protocol
• RFC – INTERNET MESSAGE ACCESS PROTOCOL – VERSION 4rev1
• RFC – Hypertext Transfer Protocol — HTTP/1.1

SMTP sending mail

In the first example I will open a telnet connection to a SMTP Server on …

Would you like to work with the biggest websites and social networks in the world? Do you want to support large enterprises with their database initiatives? Would you like to assist ISVs and OEMs providing the technology that powers their products?

In the MySQL Sales Consulting organization we do just that.

Oracle is hiring for a MySQL Sales Consultant in the S.F. Bay Area to support MySQL partners, customers and prospects, evangelize our products, assist marketing and cooperate with product management to shape the future of MySQL.

Sound interesting? We're actively looking for senior professionals to join the team, so apply now!

Would you like to work with the biggest websites and social networks in the world? Do you want to support large enterprises with their database initiatives? Would you like to assist ISVs and OEMs providing the technology that powers their products?

In the MySQL Sales Consulting organization we do just that.

Oracle is hiring for a MySQL Sales Consultant in the S.F. Bay Area to support MySQL partners, customers and prospects, evangelize our products, assist marketing and cooperate with product management to shape the future of MySQL.

Sound interesting? We're actively looking for senior professionals to join the team, so apply now!

I just started a Colorado MySQL meetup group. This is long overdue !
If your in the Colorado area feel free to join and we can work on getting some meetings started.
http://www.meetup.com/Colorado-MySQL-Meetup-Group/http://www.facebook.com/#!/groups/mysqlcolorado/