963 shaares
27 results
tagged
mysql
Finding the right high availability strategy for your business
When it comes to database high availability, how many 9s do you really need? The minimum for most organizations is three 9s. Will that suffice for you, or do you need four? Or is five 9s—less than 1 second of downtime per day—a must?
Finding the right mix of reliability and infrastructure complexity is vital to make the best use of your resources. Let’s take a high-level look at three common approaches, spanning from 99.9% to 99.999% uptime.
When it comes to database high availability, how many 9s do you really need? The minimum for most organizations is three 9s. Will that suffice for you, or do you need four? Or is five 9s—less than 1 second of downtime per day—a must?
Finding the right mix of reliability and infrastructure complexity is vital to make the best use of your resources. Let’s take a high-level look at three common approaches, spanning from 99.9% to 99.999% uptime.
A simple$ whois 179.86.208.206 revealed that the requests were coming from Brazil. Before using iptables to block the offending IP by dropping all packets from that source, I thought I’d take a closer look at the logs to see if there was anything else I missed. I realized that it was multiple IPs making these huge amount of requests. Upon closer inspection I realized that they were all coming from the same user-agent "Mozilla/5.0 Jorgee"
Docker is quickly becoming mainstream, as a method to package and deploy self-sufficient applications in primarily stateless Linux containers. But for a stateful service like a database, this might be bit of a headache. How do we best configure MySQL in a container environment? What can go wrong? Should we even run our databases in a container environment? How does performance compare with e.g. running on virtual machines or bare-metal servers? How do we manage replicated or clustered setups, where multiple containers need to be created, upgraded and made highly available ?
sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a powerful detection engine, many niche features for the ultimate penetration tester and a broad range of switches lasting from database fingerprinting, over data fetching from the database, to accessing the underlying file system and executing commands on the operating system via out-of-band connections.
A couple of different problems can occur if your app isn't managing its database connections carefully
OurSQL est une solution qui est, une fois que l'on a trouvé la procédure, assez facile à mettre en place. Elle permet d'utiliser MySQL de la même manière que MySQLdb sous Python2, qui est le connecteur de référence.
En ce qui concerne les performances, la solution n'est pas forcément parfaite, mais largement suffisante pour tous les besoins. Lorsque le module MySQLdb sera enfin livré, il n'y aura qu'un seul paramètre de connection à changer (adap) pour effectuer la transition. Dans l'intervale, on se sera évité le développement en Python 2 et la réécriture en Python3.
En ce qui concerne les performances, la solution n'est pas forcément parfaite, mais largement suffisante pour tous les besoins. Lorsque le module MySQLdb sera enfin livré, il n'y aura qu'un seul paramètre de connection à changer (adap) pour effectuer la transition. Dans l'intervale, on se sera évité le développement en Python 2 et la réécriture en Python3.
This script backs up all databases on the server it’s running on. Usually ran as a cron job.
Code pour programmeurs : Python, GUI, Databases, Interfaces graphiques...