just a note here...seems like it is a better practice not to use the DB role in the dns name for the db server. It is possible to change the DB role while going and will be annoying to find out that your application stops connecting to the servers because somewhere in its configuration files the DB url had the old role name written. If using 'mysql' only this will not happen. After all you can only have a single mysql role in a farm anyway
On Sat, Sep 12, 2009 at 5:11 AM, Sebastian Stadil <[email protected]>wrote: > I have edited this page ( > http://wiki.scalr.net/How_to.../Setup_a_MySQL_cluster) to make it clearer. > > Let us know if there is still confusion. > > > On Thu, Sep 10, 2009 at 11:30 PM, Arie Fishler <[email protected]> wrote: > >> u r right. scalr adds the role names as well to the dns config so all >> these options work. >> >> On Fri, Sep 11, 2009 at 9:02 AM, Akshay Rao <[email protected]> wrote: >> >>> I actually use my role name and everything works fine. The DB url I use >>> is int-<db_role_name>-master.MYDOMAIN.com. I can ping it and resolve it >>> just fine. >>> >>> >>> >>> On Fri, Sep 11, 2009 at 1:53 AM, Arie Fishler <[email protected]>wrote: >>> >>>> u use >>>> int-msyql-master.MYDOMAIN.com<http://int-msyql-master.mydomain.com/>and >>>> replace the domain ONLY with yours (mysql word stays as is for all >>>> roles) >>>> >>>> Regarding usernames and passwords - u manage ALL yourself. u get to >>>> start with an empty db >>>> >>>> >>>> On Fri, Sep 11, 2009 at 1:54 AM, kenvogt <[email protected]>wrote: >>>> >>>>> >>>>> I can't figure out from the docs the correct way to make an internal >>>>> connection from an app server to the database servers. In various >>>>> places it seems to say that I can use the hostnames int- >>>>> mysql.MYDOMAIN.com and int-msyql-master.MYDOMAIN.com (where MYDOMAIN >>>>> is replaced by my domain name). However, I could read you to mean that >>>>> "-mysql" would be replaced with the rolename (in my case mysqllvm64) >>>>> which would mean using the hostnames int-msyqllvm64.MYDOMAIN.com and >>>>> int-msyqllvm64.MYDOMAIN.com. Whichever I should use, must I create >>>>> MySql usernames and passwords on both of the correct hostnames or do >>>>> they already exist? >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
