MySQL Sandbox

how to use mysqlsand box

Asked by chaitanya

hi all , this may be a silly question for all the legends here....
but it is a huge problem for me.
can u give me any guidence for how to use this sandbox .
i treied to follow the tutorial given by Giuseppe Maxia. which was given in 2006. overview of using mysql sand box. but i found there are many changes in the recent versions. i am using this to create multiple instances like 7 and to do the circular replication using these instances.
if any one can guide me that is very helpful for me .
thank you
chaitanya

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Sandbox Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:

This question was reopened

Revision history for this message
Giuseppe Maxia (giuseppe-maxia) said : 		#1

The easiest way of getting started is to read this blog post:
http://datacharmer.blogspot.com/2008/07/mysql-20-has-been-released.html

For more info, look at the wiki page that describes the current implementation:
http://forge.mysql.com/wiki/MySQL_Sandbox

A presentation explaining the basic is here:
http://datacharmer.org/presentations/mysqluniv_2008/sandbox_2_0.html

Revision history for this message
chaitanya (bavana-reading) said : 		#2

Dear Giuseppe Maxia ,
i am the happiest person in the whole world just the reason is that i got Reply from you sir.
i have succesfully installed sandbox now the single server sandbox. i am just wondering that i read the ReadMe file where it is mentioned that we can do multiple sandboxes with out any replication between those members.
Actually my requirement is to create 7 multiple instances of mysql and to do circular replication between those instances.
do this requirement can be fulfiled by the mysql sandbox2.0 ?
May the Joy of Thousand Life Times visit your Home.
thanks a lot
chaitanya.

Revision history for this message
Giuseppe Maxia (giuseppe-maxia) said : 		#3

the links mentioned in my previous answer cover also standard and circular replication.
You may also find solace by running
 ./make_replication_sandbox --help

Revision history for this message
chaitanya (bavana-reading) said : 		#4

Thank you very much this solved my problem. thanks a ton.

Revision history for this message
chaitanya (bavana-reading) said : 		#5

Thanks Giuseppe Maxia, that solved my question.

Revision history for this message
chaitanya (bavana-reading) said : 		#6

Dear sir,
i am having one moe question that whether i can create my own database in one of the node?
so that i can be replicated.
and can i enter in the mysql like we go when we install mysql on our os.
can i see the structure of the database in those nodes?
i am sorry i said one question
and there are a lot
thank you
and sorry to trouble you always
chaitanya

Revision history for this message
Giuseppe Maxia (giuseppe-maxia) said : 		#7

This is a general MySQL question. Not a Sandbox issue.
Please ask this question to MySQL Forums (http://forums.mysql.com)

Revision history for this message
Giuseppe Maxia (giuseppe-maxia) said : 		#8

The last request is not Sandbox specific.