We finish our series on data types by talking about ENUM, SET and all the different sql modes.

Conferences
The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies, will be held in Buenos Aires from Tuesday, June 26th through Thursday, June 28th at the Puerto Madero Hilton Hotel.

MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps.

read more

Here’s a quick Python script for adding columns for all tables in your EER model. This will create a create_time and update_time columns in all tables, but you can modify it to your needs. To execute:

1. go to Scripting -> Scripting Shell…
2. click the New Script toolbar icon at the top left corner
3. select Python Script and specify some name for the script file
4. click Create
5. copy/paste the script there
6. click the Execute toolbar button

Make sure to backup your model before running this!

The code

# get a reference to the schema in the model. This will get the 1st schema in it.
schema = grt.root.wb.doc.physicalModels[0].catalog.schemata[0]
# iterate through all tables
for table in schema.tables:
    # create a new column object and set its name
    column = grt.classes.db_mysql_Column()
    column.name = "create_time"
    # add it to the table …

Yesterday I was asked by a customer for the reason why he had failed to achieve scale with a state-of-the-art "shared-storage" cluster. "It's a scale-out to 4 servers, but with a shared disk. And I got, after tons of work and efforts, 130% throughput, not even close to the expected 400%" he said.

Well, scale-out cannot be achieved with a shared storage and the word "shared" is the key. Scale-out is done with absolutely nothing shared or a "shared-nothing" architecture. This what makes it linear and unlimited. Any shared resource, creates a tremendous burden on each and every database server in the cluster.

In a previous post, I identified database engine activities such as buffer management, locking, thread locks/semaphores, and recovery tasks - as the main bottleneck in the OLTP …

A Columbus, Ohio lawmaker wants to ensure that the public quickly becomes aware of online security breaches.

The legislation bill, soon to be introduced, will require state agencies, businesses, and institutions to report any database security breach to the Ohio attorney general’s office if any Ohio resident’s personal information was accessed.
The bill is jointly sponsored by a Dayton, Ohio, lawmaker.

The proposal also would require that the security breach report be filed no later than 40 days following its discovery. The attorney general’s office would compile the breaches into a public, searchable database.

However, many small and medium organizations suffer from lack of visibility are not even aware that they have been breached.

If …

Edited to add - this is in Percona's patched 5.5, not in Oracle's 5.5.

We have only recently started using MySQL 5.5 here at Mozilla, and while there are features I have known about for a while, I usually hear about them early on and file them as “oh yeah, that is coming later!”. Like how right now we are learning about all the neat stuff in MySQL 5.6. Well, I am sure I knew about the addition of the Rows_read and Rows_sent fields to the PROCESSLIST information, but it was only today that I really am using it.

I am doing an export of a large table, and I did a SHOW PROCESSLIST to see:

Id: 651130
User: export
Host: localhost
db: puppet_dashboard
Command: Query
Time: 1246
State: Sending data
Info: SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FROM `resource_statuses` …

With NoSQL and Hadoop, the database world has undergone a revolution. The fighting reached its peak a couple of years ago, but things have calmed down since, and now is a good time to take stock of old and new style data management technologies.

From this revolution, we can learn a lot about what databases should, and should not be. At the end of this post, I propose a system, called Optiq, that would restore to NoSQL/Hadoop systems some of the good features of databases.

Learning from history

Revolutions tend to follow patterns. George Orwell allegorized the progress of the Russian Revolution in his novel Animal Farm. He described the injustices that were the trigger for the revolution, the new egalitarian value system …

Earlier this week, Andrew Morgan wrote a piece on running MySQL Cluster on Raspberry Pi. Since the term “Cluster” is hideously overloaded, I’ll note that we’re talking about the NDB cluster storage engine here, a very specific architecture originally acquired by MySQL AB from Ericsson (telco).

Raspberry Pi is a new single-board computer based on the ARM processor series (same stuff that powers most mobile phones these days), and it can run Linux without any fuss. Interfaces include Ethernet, USB, and HDMI video, and the cost is $25-50. I’m looking to use one for the front-end of a MythTV setup (digital video recorder and TV system), I can just strap the Raspberry Pi to the back of a TV or monitor to do its …

There are some variables that can affect the replication behavior and sometimes cause some big troubles. In this post I’m going to talk about read_buffer_size and how this variable together with max_allowed_packet can break your replication.

The setup is a master-master replication with the following values:

max_allowed_packet = 32M
read_buffer_size = 100M

To break the replication I’m going to load the 4 million rows with LOAD DATA INFILE:

MasterA (test) > LOAD DATA INFILE '/tmp/data' INTO TABLE t;
Query OK, 4510080 rows affected (26.89 sec)

After some time the SHOW SLAVE STATUS on MasterA gives us this output:

Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event 'mysql-bin.000002' at 74416925, …

Thanks to all who attended my webinar today. The session was recorded and will be available to watch for free soon here.

There were a lot of great questions asked during the session, so I’d like to take this opportunity to try to answer a few of them:

Q: Is there an easy way to leverage the xtrabackup SST and IST in an xtradb cluster to take your full and incremental backups of the cluster’s databases?

Well, if you noticed, all the current SST methods are just commonly used backup tools, and the SST is, in reality, just doing a full backup. So I’m not sure there’s much to leverage with SST.

The straight-forward to way to backup XtraDB Cluster (IMHO) would to simply do run your backup of choice on a node and optionally keep the node out …

The South East LinuxFest is this weekend (June 7-9) in Charlotte, North Carolina and SkySQL will be attending the conference both as a sponsor and with talks. 

read more