示例#1
0
 def init_mysql(self):
     # read hosts
     sql_read_hosts = self.dbconfig.get("mysql_read_server", ["127.0.0.1"])
     sql_read_hosts = [(host, 3306) for host in sql_read_hosts]
     self.debug("MySQL read hosts: %s", sql_read_hosts)
     # write hosts
     sql_write_hosts = self.dbconfig.get("mysql_write_server", ["127.0.0.1"])
     sql_write_hosts = [(host, 3306) for host in sql_write_hosts]
     self.debug("MySQL write hosts: %s", sql_write_hosts)
     # credentials
     user = self.dbconfig.get("mysql_user", "metagam")
     password = self.dbconfig.get("mysql_password")
     database = self.dbconfig.get("mysql_database", "metagam")
     self.debug("MySQL database: %s", database)
     self.debug("MySQL user: %s", user)
     # connect
     primary_host_id = self.conf("global", "mysql_primary_host_id", 0) % len(sql_read_hosts)
     if hasattr(self, "_sql_read"):
         self._sql_read.set_servers(sql_read_hosts, user, password, database, primary_host_id)
     else:
         self._sql_read = MySQLPool(sql_read_hosts, user, password, database, primary_host_id=primary_host_id)
     primary_host_id = self.conf("global", "mysql_primary_host_id", 0) % len(sql_write_hosts)
     if hasattr(self, "_sql_write"):
         self._sql_write.set_servers(sql_write_hosts, user, password, database, primary_host_id)
     else:
         self._sql_write = MySQLPool(sql_write_hosts, user, password, database, primary_host_id=primary_host_id)
示例#2
0
 def init_mysql(self):
     # read hosts
     sql_read_hosts = self.dbconfig.get("mysql_read_server", ["127.0.0.1"])
     sql_read_hosts = [(host, 3306) for host in sql_read_hosts]
     self.debug("MySQL read hosts: %s", sql_read_hosts)
     # write hosts
     sql_write_hosts = self.dbconfig.get("mysql_write_server",
                                         ["127.0.0.1"])
     sql_write_hosts = [(host, 3306) for host in sql_write_hosts]
     self.debug("MySQL write hosts: %s", sql_write_hosts)
     # credentials
     user = self.dbconfig.get("mysql_user", "metagam")
     password = self.dbconfig.get("mysql_password")
     database = self.dbconfig.get("mysql_database", "metagam")
     self.debug("MySQL database: %s", database)
     self.debug("MySQL user: %s", user)
     # connect
     primary_host_id = self.conf("global", "mysql_primary_host_id",
                                 0) % len(sql_read_hosts)
     if hasattr(self, "_sql_read"):
         self._sql_read.set_servers(sql_read_hosts, user, password,
                                    database, primary_host_id)
     else:
         self._sql_read = MySQLPool(sql_read_hosts,
                                    user,
                                    password,
                                    database,
                                    primary_host_id=primary_host_id)
     primary_host_id = self.conf("global", "mysql_primary_host_id",
                                 0) % len(sql_write_hosts)
     if hasattr(self, "_sql_write"):
         self._sql_write.set_servers(sql_write_hosts, user, password,
                                     database, primary_host_id)
     else:
         self._sql_write = MySQLPool(sql_write_hosts,
                                     user,
                                     password,
                                     database,
                                     primary_host_id=primary_host_id)
示例#3
0
class Instance(Loggable):
    """
    This is an executable instance. It keeps references to all major objects
    """
    def __init__(self, insttype, cls, addopt=[]):
        Loggable.__init__(self, "mg.core.processes.Instance")
        self.insttype = insttype
        self.cls = cls
        self.init_modules()
        self.init_cmdline(addopt)
        self.init_logger()

    def init_modules(self):
        self.modules = set()

    def init_cmdline(self, addopt):
        parser = optparse.OptionParser()
        parser.add_option("-c", "--config", action="store", help="Configuration file")
        for opt in addopt:
            parser.add_option(*opt[0], **opt[1])
        (options, args) = parser.parse_args()
        self.cmdline_options = options
        self.cmdline_args = args

    @property
    def config(self):
        try:
            return self._config
        except AttributeError:
            pass
        self.init_config()
        return self._config

    @property
    def instaddr(self):
        try:
            return self._instaddr
        except AttributeError:
            pass
        self.init_config()
        return self._instaddr

    def get_instid(self):
        try:
            return self._instid
        except AttributeError:
            pass
        self.init_config()
        return self._instid

    def set_instid(self, val):
        if not hasattr(self, "_instid"):
            self.init_config()
        self._instid = val

    instid = property(get_instid, set_instid)

    @property
    def config_filename(self):
        try:
            return self._config_filename
        except AttributeError:
            pass
        self.init_config()
        return self._config_filename

    def init_config(self):
        self._config = ConfigParser.RawConfigParser()
        self._config_filename = self.cmdline_options.config or CONFIG_FILE
        self._config.read(self._config_filename)
        self._instaddr = self.conf("global", "addr")
        if not self._instaddr:
            raise RuntimeError("Config key global.addr not found")
        self._instid = "%s-%s" % (self.insttype, self.conf("global", "id", self.instaddr))

    def conf(self, section, option, default=None):
        try:
            return self.config.get(section, option)
        except ConfigParser.NoSectionError:
            return default
        except ConfigParser.NoOptionError:
            return default

    def confint(self, section, option, default=None):
        try:
            return self.config.getint(section, option)
        except ConfigParser.NoSectionError:
            return default
        except ConfigParser.NoOptionError:
            return default

    def init_logger(self):
        if not getattr(logging, "mg_initialized", False):
            logging.mg_initialized = True

            modlogger = logging.getLogger("")
            modlogger.setLevel(logging.DEBUG)

            # syslog
            syslog_channel = logging.handlers.SysLogHandler(address="/dev/log")
            syslog_channel.setLevel(logging.DEBUG)
            formatter = Formatter(unicode(self.insttype + " cls=%(name)s %(message)s"))
            syslog_channel.setFormatter(formatter)
            filter = Filter()
            syslog_channel.addFilter(filter)
            modlogger.addHandler(syslog_channel)

            # stderr
            stderr_channel = logging.StreamHandler()
            stderr_channel.setLevel(logging.DEBUG)
            filter = StderrFilter()
            stderr_channel.addFilter(filter)
            formatter = Formatter(unicode("%(asctime)s " + self.insttype + " cls=%(name)s %(message)s"))
            stderr_channel.setFormatter(formatter)
            modlogger.addHandler(stderr_channel)

    @property
    def dbpool(self):
        try:
            return self._dbpool
        except AttributeError:
            pass
        self.init_cassandra()
        return self._dbpool

    @property
    def sys_conn(self):
        try:
            return self._sys_conn
        except AttributeError:
            pass
        self.init_cassandra()
        return self._sys_conn

    def init_cassandra(self):
        if not hasattr(self, "_dbpool"):
            cass_hosts = []
            for host in re_comma.split(self.conf("global", "cassandra", "127.0.0.1").strip()):
                cass_hosts.append((host, 9160))
            self.debug("Cassandra seed hosts: %s", cass_hosts)
            self._dbpool = CassandraPool(cass_hosts, primary_host_id=0)
        # get actual database cluster configuration from the database itself
        self._sys_conn = self._dbpool.sys_connection()
        try:
            ring = self._sys_conn.cass.describe_ring("main")
        except InvalidRequestException as e:
            pass
        else:
            cass_hosts = []
            for ent in ring:
                for ip in ent.endpoints:
                    cass_hosts.append((ip, 9160))
            self.debug("Cassandra hosts: %s", cass_hosts)
            self._dbpool.set_host(cass_hosts, primary_host_id=self.conf("global", "cassandra_primary_host_id", 0) % len(cass_hosts))

    def close_cassandra(self):
        if hasattr(self, "_dbpool"):
            delattr(self, "_dbpool")
            delattr(self, "_sys_conn")

    @property
    def dbconfig(self):
        try:
            return self._dbconfig
        except AttributeError:
            pass
        db = self.dbpool.dbget("int", mc=None, storage=1)
        self._dbconfig = DBConfigGroup(db, uuid="sysconfig", silent=True)
        return self._dbconfig

    @property
    def mcpool(self):
        try:
            return self._mcpool
        except AttributeError:
            pass
        mc_hosts = self.dbconfig.get("memcached", ["127.0.0.1"])
        mc_hosts = [(host, 11211) for host in mc_hosts]
        self.debug("Memcached hosts: %s", mc_hosts)
        if hasattr(self, "_mcpool"):
            self._mcpool.set_hosts(mc_hosts)
        else:
            self._mcpool = MemcachedPool(mc_hosts)
        return self._mcpool

    def close_memcached(self):
        if hasattr(self, "_mcpool"):
            delattr(self, "_mcpool")

    @property
    def sql_read(self):
        try:
            return self._sql_read
        except AttributeError:
            pass
        self.init_mysql()
        return self._sql_read

    @property
    def sql_write(self):
        try:
            return self._sql_write
        except AttributeError:
            pass
        self.init_mysql()
        return self._sql_write

    def init_mysql(self):
        # read hosts
        sql_read_hosts = self.dbconfig.get("mysql_read_server", ["127.0.0.1"])
        sql_read_hosts = [(host, 3306) for host in sql_read_hosts]
        self.debug("MySQL read hosts: %s", sql_read_hosts)
        # write hosts
        sql_write_hosts = self.dbconfig.get("mysql_write_server", ["127.0.0.1"])
        sql_write_hosts = [(host, 3306) for host in sql_write_hosts]
        self.debug("MySQL write hosts: %s", sql_write_hosts)
        # credentials
        user = self.dbconfig.get("mysql_user", "metagam")
        password = self.dbconfig.get("mysql_password")
        database = self.dbconfig.get("mysql_database", "metagam")
        self.debug("MySQL database: %s", database)
        self.debug("MySQL user: %s", user)
        # connect
        primary_host_id = self.conf("global", "mysql_primary_host_id", 0) % len(sql_read_hosts)
        if hasattr(self, "_sql_read"):
            self._sql_read.set_servers(sql_read_hosts, user, password, database, primary_host_id)
        else:
            self._sql_read = MySQLPool(sql_read_hosts, user, password, database, primary_host_id=primary_host_id)
        primary_host_id = self.conf("global", "mysql_primary_host_id", 0) % len(sql_write_hosts)
        if hasattr(self, "_sql_write"):
            self._sql_write.set_servers(sql_write_hosts, user, password, database, primary_host_id)
        else:
            self._sql_write = MySQLPool(sql_write_hosts, user, password, database, primary_host_id=primary_host_id)

    def close_mysql(self):
        if hasattr(self, "_sql_read"):
            self._sql_read.close_all()
            self._sql_write.close_all()
            delattr(self, "_sql_read")
            delattr(self, "_sql_write")

    @property
    def appfactory(self):
        try:
            return self._appfactory
        except AttributeError:
            pass
        self.init_appfactory()
        return self._appfactory

    def init_appfactory(self):
        self._appfactory = ApplicationFactory(self)

    def close_appfactory(self):
        if hasattr(self, "_appfactory"):
            delattr(self, "_appfactory")

    @property
    def int_app(self):
        try:
            return self._int_app
        except AttributeError:
            pass
        self._int_app = Application(self, "int", storage=1)
        self.appfactory.add(self.int_app)
        return self._int_app

    def close_app(self):
        if hasattr(self, "_int_app"):
            delattr(self, "_int_app")

    def close_all(self):
        self.close_app();
        self.close_appfactory()
        self.close_mysql()
        self.close_memcached()
        self.close_cassandra()

    @property
    def daemons_dir(self):
        try:
            return self._daemons_dir
        except AttributeError:
            pass
        mgDir = os.path.abspath(mg.__path__[0])
        self._daemons_dir = "%s/bin" % os.path.dirname(mgDir)
        return self._daemons_dir
示例#4
0
class Instance(Loggable):
    """
    This is an executable instance. It keeps references to all major objects
    """
    def __init__(self, insttype, cls, addopt=[]):
        Loggable.__init__(self, "mg.core.processes.Instance")
        self.insttype = insttype
        self.cls = cls
        self.init_modules()
        self.init_cmdline(addopt)
        self.init_logger()

    def init_modules(self):
        self.modules = set()

    def init_cmdline(self, addopt):
        parser = optparse.OptionParser()
        parser.add_option("-c",
                          "--config",
                          action="store",
                          help="Configuration file")
        for opt in addopt:
            parser.add_option(*opt[0], **opt[1])
        (options, args) = parser.parse_args()
        self.cmdline_options = options
        self.cmdline_args = args

    @property
    def config(self):
        try:
            return self._config
        except AttributeError:
            pass
        self.init_config()
        return self._config

    @property
    def instaddr(self):
        try:
            return self._instaddr
        except AttributeError:
            pass
        self.init_config()
        return self._instaddr

    def get_instid(self):
        try:
            return self._instid
        except AttributeError:
            pass
        self.init_config()
        return self._instid

    def set_instid(self, val):
        if not hasattr(self, "_instid"):
            self.init_config()
        self._instid = val

    instid = property(get_instid, set_instid)

    @property
    def config_filename(self):
        try:
            return self._config_filename
        except AttributeError:
            pass
        self.init_config()
        return self._config_filename

    def init_config(self):
        self._config = ConfigParser.RawConfigParser()
        self._config_filename = self.cmdline_options.config or CONFIG_FILE
        self._config.read(self._config_filename)
        self._instaddr = self.conf("global", "addr")
        if not self._instaddr:
            raise RuntimeError("Config key global.addr not found")
        self._instid = "%s-%s" % (self.insttype,
                                  self.conf("global", "id", self.instaddr))

    def conf(self, section, option, default=None):
        try:
            return self.config.get(section, option)
        except ConfigParser.NoSectionError:
            return default
        except ConfigParser.NoOptionError:
            return default

    def confint(self, section, option, default=None):
        try:
            return self.config.getint(section, option)
        except ConfigParser.NoSectionError:
            return default
        except ConfigParser.NoOptionError:
            return default

    def init_logger(self):
        if not getattr(logging, "mg_initialized", False):
            logging.mg_initialized = True

            modlogger = logging.getLogger("")
            modlogger.setLevel(logging.DEBUG)

            # syslog
            syslog_channel = logging.handlers.SysLogHandler(address="/dev/log")
            syslog_channel.setLevel(logging.DEBUG)
            formatter = Formatter(
                unicode(self.insttype + " cls=%(name)s %(message)s"))
            syslog_channel.setFormatter(formatter)
            filter = Filter()
            syslog_channel.addFilter(filter)
            modlogger.addHandler(syslog_channel)

            # stderr
            stderr_channel = logging.StreamHandler()
            stderr_channel.setLevel(logging.DEBUG)
            filter = StderrFilter()
            stderr_channel.addFilter(filter)
            formatter = Formatter(
                unicode("%(asctime)s " + self.insttype +
                        " cls=%(name)s %(message)s"))
            stderr_channel.setFormatter(formatter)
            modlogger.addHandler(stderr_channel)

    @property
    def dbpool(self):
        try:
            return self._dbpool
        except AttributeError:
            pass
        self.init_cassandra()
        return self._dbpool

    @property
    def sys_conn(self):
        try:
            return self._sys_conn
        except AttributeError:
            pass
        self.init_cassandra()
        return self._sys_conn

    def init_cassandra(self):
        if not hasattr(self, "_dbpool"):
            cass_hosts = []
            for host in re_comma.split(
                    self.conf("global", "cassandra", "127.0.0.1").strip()):
                cass_hosts.append((host, 9160))
            self.debug("Cassandra seed hosts: %s", cass_hosts)
            self._dbpool = CassandraPool(cass_hosts, primary_host_id=0)
        # get actual database cluster configuration from the database itself
        self._sys_conn = self._dbpool.sys_connection()
        try:
            ring = self._sys_conn.cass.describe_ring("main")
        except InvalidRequestException as e:
            pass
        else:
            cass_hosts = []
            for ent in ring:
                for ip in ent.endpoints:
                    cass_hosts.append((ip, 9160))
            self.debug("Cassandra hosts: %s", cass_hosts)
            self._dbpool.set_host(
                cass_hosts,
                primary_host_id=self.conf("global",
                                          "cassandra_primary_host_id", 0) %
                len(cass_hosts))

    def close_cassandra(self):
        if hasattr(self, "_dbpool"):
            delattr(self, "_dbpool")
            delattr(self, "_sys_conn")

    @property
    def dbconfig(self):
        try:
            return self._dbconfig
        except AttributeError:
            pass
        db = self.dbpool.dbget("int", mc=None, storage=1)
        self._dbconfig = DBConfigGroup(db, uuid="sysconfig", silent=True)
        return self._dbconfig

    @property
    def mcpool(self):
        try:
            return self._mcpool
        except AttributeError:
            pass
        mc_hosts = self.dbconfig.get("memcached", ["127.0.0.1"])
        mc_hosts = [(host, 11211) for host in mc_hosts]
        self.debug("Memcached hosts: %s", mc_hosts)
        if hasattr(self, "_mcpool"):
            self._mcpool.set_hosts(mc_hosts)
        else:
            self._mcpool = MemcachedPool(mc_hosts)
        return self._mcpool

    def close_memcached(self):
        if hasattr(self, "_mcpool"):
            delattr(self, "_mcpool")

    @property
    def sql_read(self):
        try:
            return self._sql_read
        except AttributeError:
            pass
        self.init_mysql()
        return self._sql_read

    @property
    def sql_write(self):
        try:
            return self._sql_write
        except AttributeError:
            pass
        self.init_mysql()
        return self._sql_write

    def init_mysql(self):
        # read hosts
        sql_read_hosts = self.dbconfig.get("mysql_read_server", ["127.0.0.1"])
        sql_read_hosts = [(host, 3306) for host in sql_read_hosts]
        self.debug("MySQL read hosts: %s", sql_read_hosts)
        # write hosts
        sql_write_hosts = self.dbconfig.get("mysql_write_server",
                                            ["127.0.0.1"])
        sql_write_hosts = [(host, 3306) for host in sql_write_hosts]
        self.debug("MySQL write hosts: %s", sql_write_hosts)
        # credentials
        user = self.dbconfig.get("mysql_user", "metagam")
        password = self.dbconfig.get("mysql_password")
        database = self.dbconfig.get("mysql_database", "metagam")
        self.debug("MySQL database: %s", database)
        self.debug("MySQL user: %s", user)
        # connect
        primary_host_id = self.conf("global", "mysql_primary_host_id",
                                    0) % len(sql_read_hosts)
        if hasattr(self, "_sql_read"):
            self._sql_read.set_servers(sql_read_hosts, user, password,
                                       database, primary_host_id)
        else:
            self._sql_read = MySQLPool(sql_read_hosts,
                                       user,
                                       password,
                                       database,
                                       primary_host_id=primary_host_id)
        primary_host_id = self.conf("global", "mysql_primary_host_id",
                                    0) % len(sql_write_hosts)
        if hasattr(self, "_sql_write"):
            self._sql_write.set_servers(sql_write_hosts, user, password,
                                        database, primary_host_id)
        else:
            self._sql_write = MySQLPool(sql_write_hosts,
                                        user,
                                        password,
                                        database,
                                        primary_host_id=primary_host_id)

    def close_mysql(self):
        if hasattr(self, "_sql_read"):
            self._sql_read.close_all()
            self._sql_write.close_all()
            delattr(self, "_sql_read")
            delattr(self, "_sql_write")

    @property
    def appfactory(self):
        try:
            return self._appfactory
        except AttributeError:
            pass
        self.init_appfactory()
        return self._appfactory

    def init_appfactory(self):
        self._appfactory = ApplicationFactory(self)

    def close_appfactory(self):
        if hasattr(self, "_appfactory"):
            delattr(self, "_appfactory")

    @property
    def int_app(self):
        try:
            return self._int_app
        except AttributeError:
            pass
        self._int_app = Application(self, "int", storage=1)
        self.appfactory.add(self.int_app)
        return self._int_app

    def close_app(self):
        if hasattr(self, "_int_app"):
            delattr(self, "_int_app")

    def close_all(self):
        self.close_app()
        self.close_appfactory()
        self.close_mysql()
        self.close_memcached()
        self.close_cassandra()

    @property
    def daemons_dir(self):
        try:
            return self._daemons_dir
        except AttributeError:
            pass
        mgDir = os.path.abspath(mg.__path__[0])
        self._daemons_dir = "%s/bin" % os.path.dirname(mgDir)
        return self._daemons_dir