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 manasi.s...@artificialmachines.com wrote:
Hi All,
I have asked this question before But, I think I am not able to
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.
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 files is
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
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)
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)
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,
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
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 (directory)
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 your
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
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
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 GB
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,
-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 X4170
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?
Hi,
Hi,
I
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 Reinicke
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
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. But
19 matches
Mail list logo