3 messages in com.mysql.lists.clusterRe: Replicating MySQL Users
FromSent OnAttachments
Burhan Khalid12 May 2008 02:49 
ewen fortune12 May 2008 03:01 
Geert Vanderkelen14 May 2008 00:04 
Subject:Re: Replicating MySQL Users
From:ewen fortune (ewen@gmail.com)
Date:05/12/2008 03:01:47 AM
List:com.mysql.lists.cluster

Hi Burhan,

The mysql.user table is not replicated across SQL nodes and it is not recommended to change the storage engine for the mysql.* tables.

Best to create the users manually.

Ewen

On Mon, May 12, 2008 at 11:49 AM, Burhan Khalid <b.kh@kuwaitnet.net> wrote:

Hello Everyone:

How do you replicate mysql user accounts (authentication data) across the SQL/API nodes? Shall I set the table type for the user and priviledge tables to NDBCLUSTER manually or is there something else at work here?

Thanks, Burhan Khalid