On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Dear Johan,
>
> Need your help again in understanding How mysql reads symlink.
>
> As you said below, I have created symlinks in default mysql directory.
> and try to read that symlink file as a database. B
Dear Johan,
Need your help again in understanding How mysql reads symlink.
As you said below, I have created symlinks in default mysql directory.
and try to read that symlink file as a database. But mysql is not reading
that file as Database. Is there any settings which I need to change.
Thanks
I'm not really clear on what you hope to accomplish by putting two virtual
servers on the same host ?
On Wed, Nov 25, 2009 at 1:35 PM, Götz Reinicke - IT-Koordinator <
goetz.reini...@filmakademie.de> wrote:
> majk.sko...@eventim.de schrieb:
> >> -Ursprüngliche Nachricht-
> >> Von: Götz
majk.sko...@eventim.de schrieb:
>> -Ursprüngliche Nachricht-
>> Von: Götz Reinicke - IT-Koordinator
>> [mailto:goetz.reini...@filmakademie.de]
>> Gesendet: Mittwoch, 25. November 2009 12:05
>> An: mysql@lists.mysql.com
>> Betreff: Virtual servers, Raid 10 or Raid 01 - your opinions?
>>
>> H
> -Ursprüngliche Nachricht-
> Von: Götz Reinicke - IT-Koordinator
> [mailto:goetz.reini...@filmakademie.de]
> Gesendet: Mittwoch, 25. November 2009 12:05
> An: mysql@lists.mysql.com
> Betreff: Virtual servers, Raid 10 or Raid 01 - your opinions?
>
> Hi,
Hi,
> I do get two new Sun Fire X
Decidedly RAID 10 - that is, a concatenation of mirrors. You get a lot more
redundancy that way.
Raid 01:
[A+B+C+D]
[E+F+G+H]
Here, a single disk lost in each concatenation (so two in total) loses you
the set. Probability is 1/8 * 4/7 (0.0714).
Raid 10:
[A] [B] [C] [D]
[E] [F] [G] [H]
Here, y
Obviously raid 10 would be better choice!.
Recommended for safety and performance.
Thanks,
Krishna Ch. Prajapati
On Wed, Nov 25, 2009 at 4:34 PM, Götz Reinicke - IT-Koordinator <
goetz.reini...@filmakademie.de> wrote:
> Hi,
>
> I do get two new Sun Fire X4170 servers with 8 SAS 300GB HDs, 24 G
Thanks Johan,
It was really a great help. I'll try to implement it. I dont want to opt
for multiple mysql instances option as thats not feasible.
I'll get back to you all if it works fine.
Thanks again.
--
Best Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 11:55
Hi,
This thing puzzles me for quite some time and I wasn't successful in
finding a clear answer anywhere - I would be grateful for some
help.
Here is a db example:
table_1
id
some_field_01
[...]
some_field_20
table_2
itemid (table_1_id)
value
Let's say that the table_2 is used to store some pr
On Wed, Nov 25, 2009 at 12:05 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> At a time mysql can point to one data directory. For your task you can have
> n number of mysql installation with different data directory. After that
> you
> can use federated storage engine to perform y
On Wed, Nov 25, 2009 at 11:55 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi Johan,
>
> I am Sorry. If I have complicated the senerio But, this still not fix my
> purpose.
>
> What I want is - From your example :-
>
> /data/disk1/mysql/db1 (directory)
> /db2 (dir
Hi,
I do get two new Sun Fire X4170 servers with 8 SAS 300GB HDs, 24 GB RAM
each.
Right now, we do not have a lot of data in our databases (5 small LAMP
servers), which should be consolidated.
(The second Sun Fire X4170 will be the Webserver-Sun, the DB-Traffic
will have his own gbit switch (Web
Hi Manasi,
At a time mysql can point to one data directory. For your task you can have
n number of mysql installation with different data directory. After that you
can use federated storage engine to perform your task.
Thanks,
Krishna Ch. Prajapati
On Wed, Nov 25, 2009 at 12:19 PM, Manasi Save <
Hi Johan,
I am Sorry. If I have complicated the senerio But, this still not fix my
purpose.
What I want is - From your example :-
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
You don't need to move any databases. Look at this structure:
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
/db5 (symlink to /data/disk2/mysql/db5)
/db
Well Waynn,
In this case I need to move all the existing databases to new location
right. Which I don't want to do. Is it possible that I create sym link
between two and use both.
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save <
>
On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Thanks Waynn,
>
> I could not get your point of using symlinks. Because as per my knowledge
> symlink will store same data which is there in original directory.
> and What do you mean by "The limit for fil
Thanks Waynn,
I could not get your point of using symlinks. Because as per my knowledge
symlink will store same data which is there in original directory.
and What do you mean by "The limit for files is significantly higher than
> directories."
Can you elaborate it more.
Thanks in advance.
Rega
I fixed this by using symlinks for the directories for the underlying
databases. The limit for files is significantly higher than
directories.
Waynn
On 11/24/09, Manasi Save wrote:
> Hi All,
>
> I have asked this question before But, I think I am not able to describe
> it better.
>
> Sorry for a
19 matches
Mail list logo