Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Monday, 8 June 2020

Now Europe (Frankfurt) region can use Amazon Aurora Serverless with PostgreSQL compatibility

Amazon Aurora is a completely organized relational database which unites the performance and availability of high-end commercial databases with the ease and cost-efficiency of open source databases. Aurora Serverless is an on-demand, auto-scaling configuration for Amazon Aurora (MySQL-compatible and PostgreSQL-compatible editions), where the database will automatically start up, shut down, and scale capacity up or down based on your application's needs. It's an easy, cost-efficient alternative for unusual, irregular, or uncertain workloads. Further, you do not have to provide or handle database capacity while using Amazon Aurora Serverless. Only you have to create an endpoint using the Amazon RDS Management Console, and Aurora Serverless manages the remaining. Only you have to pay for the database resources you utilize, on a per-second basis and you don't charge for the database instance except if it's really ongoing. Amazon Aurora Serverless with PostgreSQL compatibility feature is now accessible in Europe (Frankfurt) region. With this feature expansion, it is currently available in the US East (N. Virginia), US East (Ohio), US West (Oregon), EU (Ireland), EU (Frankfurt) and Asia Pacific (Tokyo) regions. To know more information on Aurora Serverless, read AWS Blog, the Aurora Serverless product page, and in the Aurora documentation.

Tuesday, 18 February 2020

Journey Through Cloud With AWS

Introduction to AWS
AWS is a company which provides on-demand cloud computing platforms and APIs to individuals their customers. This company provides you with cloud services where you can store your data securely and access it later through the internet. They provide a set of primitive abstract technical infrastructure and distributed computing building blocks, tools and help their clients build applications with increased scalability, flexibility and reliability.

AWS Feature
AWS provides their clients with a wide variety of services which help them experience an amazing cloud journey. They offer a set of cloud-based products including compute, storage, databases, analytics, networking, management tools, IoT, security. They help businesses grow faster, lower IT costs, and scale. AWS can be very beneficial to companies with heavy workloads by helping them in setting up an online database and securing all their data on these databases.


  • Data Lake and Analytics
  • AWS provides the most comprehensive set of services to build your data lake analytics solution, to move, store and analyse your data. Import your data from on-premises in no time on highly secure data lake with a capacity of storage to exabytes. Analytics services provided by AWS helps in analysing the data with the broadest selection of services, through which we can predict future outcomes, and prescribe actions for rapid response.

  • Compute
  • Compute is the most basic step of building an organisation, whether you are building an enterprise, cloud-native or mobile-based applications. Compute service provided by AWS allows you to develop, deploy, run and scale your applications and workloads. AWS is working to be the compute platform at a global level, and are investing to support any workload and business need.

  • Databases
  • AWS offers 15 different purpose-built database engines, from which one can choose according to the needs of their workloads and business. They provide relational databases which are 3-5 times faster than other alternatives, in which you can scale your database’s compute and storage resources easily. AWS offers cluster monitoring to keep your workloads up to focus on higher-value application development.

  • Management Tools
  • AWS management services give their client the ability to innovate faster and maintain control over their costs simultaneously. AWS offers to manage and govern AWS as well as non-AWS resources. Clients have the freedom to enable, provision and operate their environment for both business agility and governance control, and the end to end operational efficiency is provided by AWS.

  • Internet of Things
  • AWS IoT services provide local data collection and analysis, and it is the only service provider to provide data management along with rich analytics. AWS provides services for all layers of security which include preventative security mechanisms, encryption and access control to device data. AWS IoT is built on secure cloud infrastructure and integrates with services through which we can build complete solutions.

  • Networking and Content Delivery
  • AWS provides the most secure set of networking services, with essential security features by isolating resources and encrypting data. AWS delivers the highest network availability with 3 times fewer network downtime from networking issues when compared to other service providers. It delivers customer applications and content anywhere over a private network with consistent high performance.

  • Security
  • Securing the data and workloads is the most important feature of AWS cloud, it provides services to protect your data and workloads from unauthorised access. Encryption, key management and threat detection continuously monitor and protect your accounts and data. AWS provides you with the feature create rules based on which the access is filtered to protect your web applications. AWS continuously monitors the network activity and account behaviour on your cloud environment to detect any kinds of threat and secures your application usage.

Conclusion
AWS is a company that provides a highly secured cloud computing and database to its customers. Securing your data into AWS clouds comes with a wide range of services, which are continuously monitored to provide you with a threat free cloud environment. AWS provides management tools to easily manage all your business data and workloads, which also helps in growing your business faster, lowering your IT costs both at the same time. It provides 3 times faster services when compared with other service providers, and helps their client build applications with higher flexibility and reliability.

Thursday, 26 December 2019

Amazon Aurora obtainable in the AWS Americas (São Paulo) AWS Region

Amazon Aurora is completely organised by Amazon Relational Database Service (RDS), which automates lengthy administration processes like hardware provisioning, database setup, patching, and backups. Amazon Aurora is a MySQL and PostgreSQL-compatible relational database designed for the cloud, which merges the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora is up to 5X quicker than standard MySQL databases and 3X faster than standard PostgreSQL databases. Amazon Aurora gives the security, availability, and reliability of commercial databases at 1/10th the cost. Now Amazon Aurora is available to users in the AWS Americas (São Paulo) region with MySQL compatibility and Amazon Aurora with PostgreSQL compatibility. Aurora automatically and constantly observes and backs up your database to Amazon S3, allowing granular point-in-time recovery. To get further information about Amazon Aurora, read documentation and to get the complete list of AWS Region where Aurora is available, refer AWS Region Table.

Monday, 21 October 2019

AWS Glue gives power to apply custom certificates for JDBC Connections

AWS Glue is an entirely organized extract, transform, and load service (ETL Service) which helps to make it easier and cost-effective to classify your data, clean it, enrich it, and transfer it securely between different data stores. AWS Glue contains a central metadata repository known as the AWS Glue Data Catalog. This Glue Data Catalog is an ETL engine which automatically produces Python or Scala code, and a flexible scheduler that takes care of dependency resolution, job monitoring, and retries. There is no infrastructure required to setup or manage as AWS Glue is serverless. Now custom certificates can be used in AWS Glue during JDBC connections to join to your data sources from Glue ETL jobs and crawlers. You may choose to apply custom certificates because you got a certificate from a third party supplier, or since the default certificates supported by AWS Glue do not fulfil your needs. Earlier, you were solely allowed to implement the default certificates offered by AWS Glue. Now this feature is accessible in every region where AWS Glue is available. Read the documentation to know further.

Wednesday, 25 September 2019

Data API Assisted By Amazon Aurora Serverless PostgreSQL

You can access Amazon Aurora Serverless PostgreSQL with the help of built-in Data API, that allows you to access Aurora Serverless with web services-based applications. Specially, Amazon Aurora can be accessed seamlessly from AWS Lambda, AWS AppSync, and AWS Cloud9. The Data API lets you concentrate on creating your applications excluding all troubles of handling database connections or connection pools. Rather, you can use SQL commands against Amazon Aurora Serverless cluster by only calling HTTPS API endpoint offered by the Data API. The Data API handles database connections and returning data. As Data API holds database credentials saved in AWS Secrets Manager, you don’t require to give credentials in API calls. The users utilizing AWS Lambda, the Data API gives a certain method to access your database excluding the extra raised for Lambda functions to be initiated in Amazon VPC. Integration with the AWS SDK gives programmatic interface to run SQL statements with parameters, transaction execution, and batch updates. Data API is accessible US East (N.Virginia, Ohio), US West (Oregon), Asia Pacific(Tokyo) and Europe(Ireland) AWS Regions. And it supports PostgreSQL-compatible and MySQL-compatible Aurora Serverless databases. To get further information to start with Data API containing directions, refer documentation.

Friday, 9 August 2019

Now Amazon Aurora Multi-Master is widely accessible

Amazon Aurora is completely organized by Amazon RDS, that automates lengthy administration activities such as hardware provisioning, database setup, patching, and backups. Amazon Aurora (Aurora) is a relational database engine which is compatible with MySQL and PostgreSQL. Amazon Aurora is up to 5X faster than standard MySQL databases and 3X faster than standard PostgreSQL databases. Also it contains a high-performance storage subsystem. Now Amazon Aurora Multi-Master is widely accessible, permitting you to generate several read-write instances of your Aurora database over different Availability Zones, that allows uptime-sensitive applications to get constant write accessibility via instance failure. In the instance failure or Availability Zone failure case, Aurora Multi-Master allows the Aurora database to retain read and write accessibility with zero application downtime. There is no necessity for database failovers to restart write operations with Aurora Multi-Master. To know how to create extremely accessible MySQL applications with the help of Amazon Aurora Multi-Master, read this blog. This feature is obtainable on Aurora MySQL 5.6 in US East (N. Virginia), US East (Ohio), US West (Oregon), and EU (Ireland) AWS Region. Refer this documentation to get detailed information on Aurora Muti-Master. With the few click in Amazon RDS Management Console or download the latest AWS SDK or CLI, you can create Amazon Aurora Multi-Master.

Wednesday, 7 August 2019

Now Amazon RDS for Oracle offers new instance sizes

Amazon RDS makes it simple to set up, operate, and scale Oracle Database deployments in the cloud. You can deploy several editions of Oracle Database with Amazon RDS within minutes with cost-efficient and re-sizable hardware capacity. Amazon RDS lets you concentrate on application development by handling lengthy database administration activities covering provisioning, backups, software patching, monitoring, and hardware scaling. Now, Amazon RDS for Oracle db.m5 and db.r5 instance classes are accessible in new 8xlarge and 16xlarge sizes. With assistance of these new instance sizes, users who are now working with either m4.10xlarge, m4.16xlarge, r4.8xlarge, or r4.16xlarge now have a better way to the modern generation of instances. M5 instances are the recent generation of normal basic instances and give better performance across latest generation M4 instances. Whereas R5 instances are the current generation of memory optimized instances which give 5% extra memory per vCPU and up to 20% improved CPU performance over R4 instances. You can start using AWS Management Console, AWS RDS CLI, and AWS RDS API. To get information of pricing and regional availability, refer Amazon RDS for Oracle pricing page.

Thursday, 4 July 2019

Now Amazon Aurora Provides Cloning Across AWS Accounts

Amazon Aurora is a completely organized relational database service (RDS) which is compatible with MySQL and PostgreSQL that customized to get benefit of that rapid distributed storage. Amazon Aurora covers a high-performance storage subsystem. The storage expands automatically up to 64 terabytes as required. Besides, Amazon Aurora automates and standardizes database clustering and replication. Now you can share your Amazon Aurora DB clusters with different AWS accounts for fast and efficient database cloning. Database cloning is faster than restoring a snapshot and don’t need any extra space while creating. You just need to pay for extra storage if you do data modifications in the cloned DB cluster. When you have different accounts for production and testing then cross-account database cloning could be helpful. The clone can utilize to certify schema modifications, check distinct parameters, and execute analytic queries on production data without giving straight access to the production account or affecting the performance of the production database. To get further details on database cloning, refer Aurora documentation and to create a cross-account database clone, refer AWS Management Console. Aurora integrates with AWS Resource Access Manager (RAM), allowing you to safely share DB clusters with multiple accounts for cloning. To get the complete of AWS Regions where this feature of Aurora and RAM are accessible, refer the AWS Region Table.

Friday, 10 May 2019

AWS AppSync Allows Extra Visibility into Performance and Health of GraphQL Operations

AWS AppSync clarifies application development by allowing you build an adaptable API to safely access, operate, and merge data from one or more data sources. AppSync is an organized service which works on GraphQL to make it simple for applications to obtain precisely the data they required. With this new feature, AWS AppSync allows you to effectively know the performance of your GraphQL requests and utilization characteristics of your GraphQL schema fields. You can simply spot resolvers with great latencies that may be the basic reason of a performance problem. Besides, you can notice the minimum and maximum often used fields in your schema and analyze the effect of deploring GraphQL fields. Now AWS AppSync frees log events in a compeletely structured JSON format. This allows smooth integration with log analytics services like Amazon CloudWatch Logs Insights and Amazon Elasticsearch Service, and other log analytics solutions. Further, AWS AppSync attached new fields to log events to boost your visibility into the performance and health of your GraphQL operations. To know detailed, read the release blog and the AWS AppSync.

Monday, 22 April 2019

Amazon Aurora Serverless Provides Sharing and Cross-Region Copying of Snapshots

Amazon Aurora (Aurora) is an entirely organized relational database engine that's compatible with MySQL and PostgreSQL. MySQL and PostgreSQL unites the speed and reliability of high-end commercial databases with the lucidity and cost-efficiency of open-source databases. The code, tools, and applications you utilize with your current MySQL and PostgreSQL databases can be used with Aurora. Now sharing snapshots of Aurora Serverless DB clusters with other AWS accounts or publicly is possible. Besides, AWS providing the potential to replicate Aurora Serverless DB cluster snapshots over AWS regions. Authorized AWS accounts can restore a DB cluster straight from the shared DB cluster snapshot without replicating it. DB cluster snapshots could be divided for a diversity of scenarios, for example, when you use disparate AWS accounts for detachment of development and production environments, share data with partners, or associate publicly on research projects. Cloning DB cluster snapshots to other AWS region enables you to retain a replica of your data for disaster recovery or for database migration. To know how to share or copy your DB cluster snapshots, visit AWS management console or use AWS SDK or CLI. And to get more information about Amazon Aurora, refer documentation

Unlocking Enterprise Knowledge: Building Scalable RAG Solutions on AWS

Is your enterprise AI assistant delivering generic or outdated answers? You are not alone. While Large Language Models (LLMs) are powerful, ...