Although Google Cloud SQL has room for improvement by addressing a minor lack of features, its features and services keep it high among other SQL database products. It is very fast compared to others. Since it is cloud-based, maintenance is also easier. Integration capabilities are also more than expected.
Cost Effective & Flexible: Customers can start as low as a single OCPU VM up to 24 OCPUs. Customers pay only for OCPUs and Storage used.
Ease Of Getting Started: Customers can easily create Oracle Certified, full-featured, fully supported 11g, 12c (both 12.1 & 12.2) databases with choice of any database edition.
Built-in High Availability Constructs: Customers can easily deploy 2-node RAC configurations with all the VM shapes. For example: Easily deploy a 2-node RAC configuration with 2 core Virtual Machines and shared block storage of up to 40 TB.
Durable & Scalable Storage: Customers can use remote storage starting at 256GB up to 40 TB. Storage can be scale up with no downtime.
Secure: Customers still get all the advantages of our Oracle IAM for management control and VCN Security lists for securing their database environments.
When we restart the DBaaS instance, it seems like we had to add the NIC network back again. I'm not sure if it's specific to our instance configuration!
It's a great product with ease of use, great scalability and high availability. There's no need to have high effort on administration. Great visibility to what happens on database like CPU, memory, IO. We can also see the performance based on query. Overall good experience and really recommend it to others.
GCP support in general requires a support agreement. For small organizations like us, this is not affordable or reasonable. It would help if Google had a support mechanism for smaller organizations. It was a steep learning curve for us because this was our first entry into the cloud database world. Better documentation also would have helped.
Google SQL was great as a first SQL provision. It quickly enabled the apps to be built and scaled as needed for a while. It was robust and adaptable as needed and easy to export as needed when ready, depending on growth. Cost-wise, it's a good choice and requires little investment to get going.
I would prefer the oracle database as service where my complete implementation is on Oracle Cloud Platform and as BI Implementation where datawarehouse is built on oracle database.
With managed database system, it has given us near 100% data availability
It has also improved web layer experience with faster processing and authentication using database fields
Google Cloud SQL also gels up well with Google Analytics and other analytics systems for us to join up different data points and process them for deeper dives and analysis
Billing on Hosted Environment per hour, OCPU per hour, block volumes, object storage, etc.
Costing & maintenance, patching.
Security & TDE cycles.
Backups & recovery.
The features are complemented by database lifecycle management features, like configuration management, performance management, patch automation, etc. which make the solution complete from a DBaaS administrator’s perspective as well.
Manager 12c covers all the major use cases for DBaaS, which yield significant business benefits and high ROI.
