If you are like me and love to keep up with the latest news in the Database, SQL and Cloud world, this is your place. Here is a short list of the blogs posts that got my attention during the past week. I hope you like them!
How to take and restore a snapshot on AWS RDS MySQL Instance: “In this article, we will see the steps to create a snapshot of the existing RDS MySql Instance. Then we will see the steps to restore the snapshot which creates a new RDS Instance. At last, we will clean up the instances and snapshots. “
Options to Run MySQL Server in OCI (and use MySQL Analytics Service): “If you started looking at running your MySQL database on the cloud and thought that taking your data to Oracle Cloud Infrastructure (OCI) is an option (and wondering about integrating to the new MySQL Acnalytics service), well that is probably the natural choice, because MySQL can integrate easily with OCI services like cloud backups in OCI Object Storage service and OCI keyring for transparent data encryption. I will share a few options with advantages of every solution, so to put the idea into practice.
- MySQL Database Service (MDS)
- MySQL on the OCI Marketplace
- MySQL on OCI do-it-yourself”
Babelfish for Aurora PostgreSQL: “Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of SQL Server to PostgreSQL or Aurora PostgreSQL can be challenging due to incompatibilities in data types, and in functions. What is promised in Babelfish is that it will create a layer between standard SQL Server TSQL and PostgreSQL to be that translation layer similar in concept to the fictional Babelfish translator from the Hitchhikers Guide to the Galaxy book.”
Joining fans and artists in perfect harmony with Cloud SQL: “We’re hearing today from Songkick, a U.K.-based concert discovery service owned by Warner Music Group. Annually, Songkick helps over 175 million music fans from all around the world to track their favorite artists, discover concerts and live streams, and buy tickets with confidence online and via their mobile apps and website. Here’s how the team was able to streamline their process and open up new potential by moving their data from physical servers to the cloud. ”
And this is it. I hope you enjoyed reading them as much as I did. Have a nice weekend and keep yourself healthy!