mysql_legacy¶
MySQL module (legacy).
Todo
replace with a proper MySQL module that uses a Python MySQL client, preferably in a parallel way.
- exception spicerack.mysql_legacy.MysqlLegacyError[source]¶
Bases:
SpicerackError
Custom exception class for errors of this module.
- class spicerack.mysql_legacy.MysqlLegacy(remote: spicerack.remote.Remote, dry_run: bool = True) None [source]¶
Bases:
object
Class to manage MySQL servers.
Initialize the instance.
- Parameters:
remote (
spicerack.remote.Remote
) -- the Remote instance.dry_run (
bool
, default:True
) -- whether this is a DRY-RUN.
- check_core_masters_heartbeats(datacenter: str, heartbeat_dc: str, heartbeats: dict[str, datetime.datetime]) None [source]¶
Check the current heartbeat values in the core DB masters in DC are in sync with the provided heartbeats.
- Parameters:
datacenter (
str
) -- the name of the datacenter from where to get the heartbeat values.heartbeat_dc (
str
) -- the name of the datacenter for which to filter the heartbeat query.heartbeats (
dict
[str
,datetime.datetime
]) -- a dictionary with the section namestr
as keys and heartbeatdatetime.datetime
for each core section as values.
- Raises:
spicerack.mysql_legacy.MysqlLegacyError -- on failure to gather the heartbeat or convert it into a datetime.
- Return type:
- check_core_masters_in_sync(dc_from: str, dc_to: str) None [source]¶
Check that all core masters in dc_to are in sync with the core masters in dc_from.
- Parameters:
- Raises:
spicerack.remote.RemoteExecutionError -- on failure.
- Return type:
- get_core_dbs(*, datacenter: str | None = None, section: str | None = None, replication_role: str | None = None, excludes: tuple[str, ...] = ()) spicerack.mysql_legacy.MysqlLegacyRemoteHosts [source]¶
Get an instance to operated on the core databases matching the parameters.
- Parameters:
datacenter (
typing.Optional
[str
], default:None
) -- the name of the datacenter to filter for, accepted values are those specified inspicerack.constants.CORE_DATACENTERS
.replication_role (
typing.Optional
[str
], default:None
) -- the repication role to filter for, accepted values are those specified inspicerack.mysql_legacy.REPLICATION_ROLES
.section (
typing.Optional
[str
], default:None
) -- a specific section to filter for, accepted values are those specified inspicerack.mysql_legacy.CORE_SECTIONS
.excludes (
tuple
[str
,...
], default:()
) -- sections to exclude from getting.
- Raises:
spicerack.mysql_legacy.MysqlLegacyError -- on invalid data or unexpected matching hosts.
- Return type:
- get_core_masters_heartbeats(datacenter: str, heartbeat_dc: str) dict[str, datetime.datetime] [source]¶
Get the current heartbeat values from core DB masters in DC for a given heartbeat DC.
- Parameters:
- Return type:
- Returns:
A dictionary with the section name
str
as keys and their heartbeatdatetime.datetime
as values. For example:{'s1': datetime.datetime(2018, 1, 2, 11, 22, 33, 123456)}
- Raises:
spicerack.mysql_legacy.MysqlLegacyError -- on failure to gather the heartbeat or convert it into a datetime.
- get_dbs(query: str) spicerack.mysql_legacy.MysqlLegacyRemoteHosts [source]¶
Get a MysqlLegacyRemoteHosts instance for the matching hosts.
- Parameters:
query (
str
) -- the Remote query to use to fetch the DB hosts.- Return type:
- set_core_masters_readonly(datacenter: str) None [source]¶
Set the core masters in read-only.
- Parameters:
datacenter (
str
) -- the name of the datacenter to filter for.- Raises:
spicerack.remote.RemoteExecutionError -- on Remote failures.
spicerack.mysql_legacy.MysqlLegacyError -- on failing to verify the modified value.
- Return type:
- set_core_masters_readwrite(datacenter: str) None [source]¶
Set the core masters in read-write.
- Parameters:
datacenter (
str
) -- the name of the datacenter to filter for.- Raises:
spicerack.remote.RemoteExecutionError -- on Remote failures.
spicerack.mysql_legacy.MysqlLegacyError -- on failing to verify the modified value.
- Return type:
- class spicerack.mysql_legacy.MysqlLegacyRemoteHosts(remote_hosts: spicerack.remote.RemoteHosts) None [source]¶
Bases:
RemoteHostsAdapter
Custom RemoteHosts class to execute MySQL queries.
Initialize the instance.
- Parameters:
remote_hosts (
spicerack.remote.RemoteHosts
) -- the instance to act on the remote hosts.
- run_query(query: str, database: str = '', success_threshold: float = 1.0, batch_size: int | str | None = None, batch_sleep: float | None = None, is_safe: bool = False) collections.abc.Iterator[tuple[ClusterShell.NodeSet.NodeSet, ClusterShell.MsgTree.MsgTreeElem]] [source]¶
Execute the query via Remote.
- Parameters:
query (
str
) -- the mysql query to be executed. Double quotes must be already escaped.database (
str
, default:''
) -- an optional MySQL database to connect to before executing the query.success_threshold (
float
, default:1.0
) -- to consider the execution successful, must be between 0.0 and 1.0.batch_size (
typing.Union
[int
,str
,None
], default:None
) -- the batch size for cumin, either as percentage (e.g.25%
) or absolute number (e.g.5
).batch_sleep (
typing.Optional
[float
], default:None
) -- the batch sleep in seconds to use in Cumin before scheduling the next host.is_safe (
bool
, default:False
) -- whether the command is safe to run also in dry-run mode because it's a read-only command that doesn't modify the state.
- Raises:
spicerack.remote.RemoteExecutionError -- if the Cumin execution returns a non-zero exit code.
- Return type:
collections.abc.Iterator
[tuple
[ClusterShell.NodeSet.NodeSet
,ClusterShell.MsgTree.MsgTreeElem
]]