running MySQL on a different server

[Niki Kraus]

hi all!

at the moment, everything is installed on the same server - dimSTAT and MySQL, but I want to change this.

How do I configure dimSTAT if the database is running on a different standalone server?

Which config file is that, I can't find it.

what I did so far -

$ /data/dimSTAT/apps/mysql/data # mv dim /var/adm/Old_Default

$ /data/dimSTAT/apps/mysql/data # mv dim_00 /var/adm/

$ /data/dimSTAT/apps/mysql/data # gtar czf /tmp/mydata.tgz .

Now I could install the database backup file on a new server.

But what then?

using MySQL v3.23, dimSTAT v5.8

-- Nick

[Dimitri]

Hi Nick

sorry, but it'll not work separately..
in fact it was possible since move to MySQL 5.5 in dim_STAT v.9.0, and
I've even tried to convert all "shell command line" functions into SQL
queries (like "shos databases", etc.).. -- but it's not always working
in most of situations (like when MySQL server is off, or there are
some errors happened, etc.)..

so, today, in several places in the code a "physical" access to data
files is required (for ex. when a new database is created it'll use a
simple "cp -rp" rather data import, and so on..)

while "generally" it's possible, just the code should be modified to
get it working properly :-)

BTW, what kind of gain you're expecting by separating MySQL and Web
servers in dim_STAT?..

Rgds,
-Dimitri

> --
> You received this message because you are subscribed to the Google Groups
> "dim_STAT" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dimstat+u...@googlegroups.com.
> To post to this group, send email to dim...@googlegroups.com.
> Visit this group at http://groups.google.com/group/dimstat?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

[Alan Impink]

Hi Nick, Dimitri!

Not sure if this is 'acceptable', but I once was able to accomplish this using the 'socat' command.  It redirected the socket file (mysql.sock) to a network socket (host:3306).  I had to do this because of a disk space issue in an 'emergency' situation.   Not ideal, but in a pinch it helped.

Alan

---

From: Dimitri <dimit...@gmail.com>
To: dim...@googlegroups.com
Sent: Friday, February 22, 2013 10:46 AM
Subject: Re: [dim_STAT] running MySQL on a different server

> email to dimstat+unsub...@googlegroups.com.

> To post to this group, send email to dim...@googlegroups.com.
> Visit this group at http://groups.google.com/group/dimstat?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

--
You received this message because you are subscribed to the Google Groups "dim_STAT" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+unsub...@googlegroups.com.

[Dimitri]

Alain,

there is a much more simple solution to access "external" database via
hostname and port ;-)

all you need is just to edit a cookie variable within your browser:
dim_STAT_BASE
supposing its value is "BMK" (for ex.) - just change it into
"BMK@host:port" to access "BMK" database on remote server ;-)

several web browsers allow you to edit cookies, as well you can simply
change it directly within URL and then it'll be saved within a cookie
automatically by dim_STAT..

However, as mentioned before, it'l not give you a full functionality
on the "remote" MySQL server..

Rgds,
-Dimitri

>> email to dimstat+u...@googlegroups.com.

>> To post to this group, send email to dim...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/dimstat?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "dim_STAT" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> email to dimstat+u...@googlegroups.com.

> To post to this group, send email to dim...@googlegroups.com.
> Visit this group at http://groups.google.com/group/dimstat?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> You received this message because you are subscribed to the Google Groups
> "dim_STAT" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> email to dimstat+u...@googlegroups.com.

[Alan Impink]

Wish I had thought of that...   :)

Thanks,

Alan

---

From: Dimitri <dimit...@gmail.com>
To: dim...@googlegroups.com

Sent: Friday, February 22, 2013 11:48 AM

>> email to dimstat+unsub...@googlegroups.com.

>> To post to this group, send email to dim...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/dimstat?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "dim_STAT" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> email to dimstat+unsub...@googlegroups.com.

> To post to this group, send email to dim...@googlegroups.com.
> Visit this group at http://groups.google.com/group/dimstat?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> You received this message because you are subscribed to the Google Groups
> "dim_STAT" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> email to dimstat+unsub...@googlegroups.com.

> To post to this group, send email to dim...@googlegroups.com.
> Visit this group at http://groups.google.com/group/dimstat?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

--
You received this message because you are subscribed to the Google Groups "dim_STAT" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+unsub...@googlegroups.com.

[Niki Kraus]

ok thank you.

Reason was that we have a dedicated MySQL cluster, and I wanted to switch by consolidating onto it.

The current server is smaller and has not very powerful I/O ..  and has less power if there's also running MySQL on it.

-- Nick