New answers tagged database
Everything I wrote here continues to be true: Third-party SSD solutions in ProLiant Gen8 servers I'll add that you should avoid consumer SSDs for this purpose, and possibly try to avoid SATA devices if you can. My solution to the SSD interoperability issue has been to move to PCIe-based SSDs or leverage the SSD caching features of the RAID controllers to ...
In the my.cnf you need to add the socket path in two places: In the [mysql] and in the ->[client]<- section. Here is a typical global option file: [client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 socket=/tmp/mysql.sock
using MS SQLServer 2012, you need to perform 3 basic steps first, generate .sql file containing only the structure of the source DB => right click on the source DB and then Tasks then Generate Scripts => follow the wizard and u can save the .sql file locally Second, replace in .sql file the source db with the destination one => right click on the destination ...
I'm coming from a web development background, so my initial instinct for part (a) is to write a separate Node program that performs all these tasks in succession. Is that all there is to it, or is there a better way? Nothing wrong with that. You schedule it with cron to run it on the desired scheduled.
1) I'm pretty sure there isn't any pre-available automatic way to achieve this. One day AWS Lambda will probably be capable, when it is taught how to receive an event after the RDS backup has occurred. 2) I think you've misunderstood what the RDS backups do. They actually take a snapshot of the RDS instance (i.e. the hidden EC2 instance on which the RDS ...
Don't reinvent the wheel. Use logstash to get your logs off your systems. Have logstash send the logs to elasticsearch. Use the kibana front end for analytics. This combination is so common it's known as the ELK stack. And it's all open source.
If binary logging is enabled, you can use SHOW BINLOG EVENTS statement or the mysqlbinlog utility to search the binary logs for DROP statements.
Top 50 recent answers are included