Hi Dominic, I need to understand how did you configure your mysql role. Seems to me you created some kind of mix of mysql and EBS not exactly the way it should be.
Edit the farm that contains the mysql role, select the mysql role. On the Mysql Settings tab - which storage engine is selected? EBS? On the EBS tab, do you have "Do not use EBS" selected. If this is so. You are ok. Mysql data is indeed stored where you specified and all is actually handled for you. This means that the Mysql is running on the EBS mounted to your instance. You actually do not have to do anything special to make it happen. Also...the way the slaves are configured they are not using the EBS of the master directly but rather replicate using the Mysql mechanism for master and slaves. Again...this is totally automatic....all configuration is performed by scalr. On Sun, Mar 29, 2009 at 1:08 AM, domhol <[email protected]> wrote: > > Hi Arie, > > would you be able to give me instructions for how to do this. > Currently my databases are stored in: > > /mnt/mysql-data/mysql/ > > Also, I see in scalr control panel that there is automatically an ebs > drive attached to the master server. How can I determine where this > is attached? Also, how do I ensure that all slave servers have access > to the ebs drive I attach to the master, or a snapshot at least? > > Cheers, > > Dominic > > On Mar 28, 9:50 am, Arie Fishler <[email protected]> wrote: > > When you set up your db through the mysql lvm role you need to tell it > that > > you want it to use the EBS engine. DO NOT use the EBS tab for it. > > > > When you specify it this way you actually do not have to do anything > > else....and it works nicely out of the (scalr) box. > > > > If your has 2 instances...second one (ant any additional) will serve as > > slaves and again, automatically be generated from your master. From my > > experience this works fine. > > > > On Fri, Mar 27, 2009 at 11:08 PM, domhol <[email protected]> > wrote: > > > > > Hi All, > > > > > so I have launched master and slave mysql instances, which have > > > managed to connect to, from my app instance. However, do the mysql > > > servers automatically store there contents on ebs, if I have mounted > > > it to /mnt/storage or is there another step I need to do. > > > > > Also, how do I ensure that the slaves are mounting a snapshot of the > > > database? > > > > > Cheers, > > > > > Dominic > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
