Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 41 1 Older Entries

Displaying posts with tag: howto (reset)

Friday Tips #2: Migrating JSF 1.2 + RichFaces to Java EE 6, Embedded and Arquillian, EJB 3.1 Timer, ...
Employee_Team +0 Vote Up -0Vote Down

Here are some tips that have been recently published on Java EE 6 & GlassFish:

Migrating JSF 1.2 + RichFaces 3.x to Java EE 6 / GlassFish v3

Mercurial and OpenSolaris and GlassFish

• …



  [Read more...]
Insert data into a VARCHAR field using NDB API: a solution
Employee_Team +1 Vote Up -0Vote Down

You are using MySQL Cluster and crazy enough to digest NDB API? Sick of SQL? Here's a treat: a function to make C/C++ strings ready for inserting into a VARCHAR field. The special thing about them is that the length is prefixed in the first 2 bytes.

void make_ndb_varchar(char *buffer, char *str)
{
  int len = strlen(str);
  int hlen = (len > 255) ? 2 : 1;
  buffer[0] = len & 0xff;
  if( len > 255 )
    buffer[1] = (len / 256);
  strcpy(buffer+hlen, str);
}

Yes, you can use memcpy. Whatever floats your boat.

Lets use this function for a table …

  [Read more...]
Python, oursql and MacOS X 10.6 (Snow Leopard)
Employee_Team +0 Vote Up -0Vote Down

This post explains how to compile oursql and install it on MacOS 10.6. oursql is a Python database interface for MySQL, an alternative to MySQL for Python (i.e. MySQLdb) and MySQL Connector/Python.

First, find out which MySQL you installed. This can be either the 32-bit or the 64-bit version. To make sure, find the …

  [Read more...]
Python, oursql and MacOS X 10.6 (Snow Leopard)
Employee_Team +0 Vote Up -0Vote Down

This post explains how to compile oursql and install it on MacOS 10.6. oursql is a Python database interface for MySQL, an alternative to MySQL for Python (i.e. MySQLdb) and MySQL Connector/Python.

First, find out which MySQL you installed. This can be either the 32-bit or the 64-bit version. To make sure, find …

  [Read more...]
Building MySQL universal binaries using MacOS X 10.6 (Snow Leopard)
Employee +0 Vote Up -0Vote Down

On the eve of 2010.. and your boss wants to stick to these MacOS X 10.5 machines, too stubborn or chicken to upgrade. Some developers still have their old PowerBook laptops and they need MySQL flying on PowerPC machines. To top it all, one guy said he wanted to have 32 and 64-bit in one bite. *Sigh* .. But there is an easy way out! A universal binary!

This post shows you a way to create …

  [Read more...]
MySQL Cluster: Listen and know what's going on
Employee +0 Vote Up -0Vote Down

You're not scared of writing clusterious code and eavesdropping is your favorite pastime at work? You want to know what's going on in your MySQL Cluster but were afraid asking? The MySQL Cluster Management API can help you!

Below you'll find example C-code that will get you started with MGM API. It's rather dull at first, but imagine you, instead of printing the event information, taking action. Imagine you starting another thread where you run some …

  [Read more...]
Want to compile a MySQL Cluster MGM API application?
Employee +0 Vote Up -0Vote Down

Here is a quick way to compile a simple MGM API application. The example will get the state of all nodes in MySQL Cluster and print whether they are connected or not.

All this without a Makefile, we just want to have some simple example on Linux to see how it works. It's basic, maybe, but sometimes useful to just have a peek.

Requirements! We assume that:

  1. you installed
  [Read more...]
Settingup DBT-2
Employee +0 Vote Up -0Vote Down

DBT-2 is a TPC-C like OLTP benchmark, and very popular amongst many MySQL users. It is used by MySQL QA team to test the stability and performance before release. However, steps to setup DBT-2 is a little bit messy, and its README files include some dummy information. So I introduce you these steps below:

1. Download it!

You can download the source code from here: http://osdldbt.sourceforge.net/

2. Required packages

The following perl packages are required to build DBT-2. Unfortunately, configure script doesn't complain even if they are …







  [Read more...]
OpenSolaris, Bazaar and SSH
Employee +0 Vote Up -0Vote Down

Just a small tip for using Bazaar on OpenSolaris: set the BZR_SSH environment variable to openssh if you don't have the Python module Paramiko installed.
For example, in your ~/.bashrc:


export BZR_SSH=openssh


Could be useful if you're pulling MySQL stuff from Launchpad and use …





  [Read more...]
Blueprints Wiki - Best Practices on ZFS, MySQL, Hadoop, and much more
Employee_Team +0 Vote Up -0Vote Down

I just bumped into the Sun BluePrints Wiki and I think it is worth a visit. It is a companion to the BluePrints Blog and part of the move towards Self-Published Content at Sun, which increases agility and responsiveness to user's needs.

The Recent Content page lists chronologically the latest changes. The more recent entries are created in Wiki format, while …

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 41 1 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.