Two parameter store values using the same KMS key alias, one decrypts and the other raises an Access Denied exception, while the corresponding IAM role has access to that KMS key ARN.
With migration to MicroServices architecture, it is extremely critical for us to control which user/service has access to which other services and which actions are permitted or should be denied.
When facing a technical problem, being technology agnostic enables you to pick the best tool for the job. You can also break a problem in to several smaller components and pick the best suitable technology for each.
Software Architecture is responsibility of everyone in the team. Everyone should have a firm understanding of the architecture of the application.
Have you ever wanted two lists of dictionaries, if they have the same value for one specific field?
By default, Memory Engine uses Hash index type to index the table, which will make it pretty much unusable and very slow performer for prefix matches and range look-ups.
When it comes to choose your MySQL replication setup you have the choice between Asynchronous replication or Semi-Synchronous replication.The way these two differ is interesting and would be very useful when you are choosing your architecture.
If you have ever wondered how to select a random string value from a list of given string in MySQL?
You may have been in a situation which you may need to figure out what is the PRIMARY key field of a given table. Or even if it is a compound key what are the columns building the PRIMARY key. This usually helps a lot when you’re making some generic tools to do some jobs on a given table.
Notes to consider when using MySQLdb API for Python to use String Formatted Parameterized placeholders.
MySQL Trigger is a powerful tool to provide the data consistency and accuracy among your tables or Database in general. The only disadvantage among Triggers is that they’re not able to update the same table they’re based on.
MySQL FEDERATED Table is a proxy to a regular table located in another DB server. You will see the table as a local table while it’s being located in another MySQL Database Server.