June 16, 2020

1939 words 10 mins read

What is Azure Database for PostgreSQL?

What is Azure Database for PostgreSQL?

PostgreSQL is the most advanced open source database system and it’s used by a number of organisations to run mission-critical workloads – including Microsoft’s Azure cloud service. However, the Azure Database for PostgreSQL is a slightly different story.  Known as a managed implementation of a service running on Azure cloud infrastructure, Azure Database for PostgreSQL allows customers to quickly

develop applications using PostgreSQL, as well as the native tools, drivers, and libraries which are attached to it, without the need to take control of the instances.  Users can deploy it either as a Single Server or Hyperscale (Citus) which is currently in preview mode, pending full release.  Azure Database for PostgreSQL – Single Server The Single Server model is the primary deployment method for PostgreSQL databases on Azure. The configuration strongly resembles PostgreSQL and in its on-premise version, users can mockup a single PostgreSQL server as the main host for multiple databases. What is more, it is also a fully managed service which offers a 99.99% performance guarantee and includes built-in back as well as numerous encryption features. SEE MORE The key challenges of migrating databases to the cloud SEE MORE How does a SQL injection attack work? SEE MORE What is SAP HANA? Similarly to the majority of the cloud tools offered by Microsoft, the configuration can be done in the Azure portal as well as the Azure CLI. Moreover, the single server option allows developers to host a single database per server, meaning that they are able to maximise resource usage or even share these resources with multiple databases.  Unfortunately to some, Azure Database for PostgreSQL admins do not have full superuser permissions. The user who holds the highest-privilege role available in the service is the azure_pg_admin. The superuser attributes are assigned to the azure_superuser, a role belonging to the managed service.  Service users are not able to access this role or its associated privileges Azure Database for PostgreSQL - Hyperscale (Citus) (preview) If you have a database which is over 100GB and requires maximum performance, you might want to consider Azure’s newest PostgreSQL deployment model. Also known as the ‘Hyperscale (Citus) (preview)’ hosting type, this method uses technology from Citus Data, a company that Microsoft acquired in January 2019. Hyperscale (Citus) uses database sharding technology, which splits data into smaller component parts and distributes them across a large number of compute nodes which are grouped together into a cluster. This cluster offers more storage capacity and CPU utilisation than a standard single-server PostgreSQL deployment would be able to. Big companies like Facebook and Google use database sharding within their data centres, but one of the advantages of Hyperscale (Citus) is that sharding is handled automatically, without the tenant application needing to be taught how to do it. The system parallelises SQL queries and other operations across available servers, with a central ‘coordinator node’ handling query routing, aggregation and planning, and ‘worker nodes’ storing data. When the coordinator receives a request from the application, it routes the query to the relevant worker node(s), depending on where the data in question is stored. Caveat emptor, however; as Hyperscale (Citus) is in public preview, it does not offer an SLA at the time of writing. Pricing There are three pricing tiers available for the single server version of Azure Database for PostgreSQL, with each setting out the various provisions that a customer may expect from these packages. These are termed Basic, General Purpose, and Memory Optimised. While all tiers offer computing power provisioned in virtual cores, or vCores, and each uses fifth-generation chips based on Intel’s Broadwell 2.3 GHz processors, the number of cores and the memory available varies.  The entry-level tier, for instance, offers either one or two rentable vCores, combined with 2GB memory, for £0.026 per hour and £0.051 per hour each. General Purpose and Memory Optimised configuration both offer far more memory and vCores, and are priced more steeply, with the maximum configuration available for £4.179 per hour.  Elements of the servers’ configuration can be changed and adjusted after they’re established, however, and there are a number of factors which combine to influence how much the system will end up costing. You could, for example, ramp up the number of vCores deployed, the storage capacity, and the length of time that backups are retained. Users can also interchange between the different pricing tiers, between General Purpose and Memory Optimised setups, for example. The final pricing also depends on the type of package you take out and how you want to pay for it, whether it be pay as you go, or annual billing, which generally cost less as you pay more upfront. This annual discounting is not available on the basic level, however. The full breakdown of available tiers is listed below, with fuller pricing information available on through Microsoft. . Understanding the tiers Pricing tierBasic General Purpose Memory Optimised Compute generation Gen 5 Gen 5 Gen 5 vCores 1, 2 2, 4, 8, 16, 32, 64 2, 4, 8, 16, 32 Memory per vCore 2GB 10GB 20GB Storage capacity Up to 1TB Up to 16TB Up to 16TB Storage type Azure Standard Storage Azure Premium Storage Azure Premium Storage

Each tier provides a free back up of up to 100% of your provisioned server storage. You can increase your backup retention period, however, this will increase the amount of backup storage consumed by the server, and so you will be charged extra. Basic The entry-level tier is primarily designed for low-priority workloads that don’t require a great deal of performance. This can include test/dev environments or intermittently-accessed applications. General Purpose As the name suggests, the general-purpose tier is where most workloads will naturally fall, and encompasses most enterprise PostgreSQL use-cases. It offers a balance of performance and economy. Memory Optimised The highest tier is reserved for applications like financial transaction databases or analytics engines where low latency is paramount. For this reason, it makes heavy use of in-memory computing. While the Basic tier does not provide an IOPS guarantee, other tiers have IOPS scale with the provisioned storage size in a 3:1 ratio. Benefits of Azure Database for PostgreSQL The database cloud service has a number of advantages. Built-in high availability: The service provides built-in high availability with no additional setup, configuration or extra cost. This means there is no need to set up further virtual machines and configure replication to guarantee high availability for a PostgreSQL database. Security: All data including backups are encrypted on disk by default. Also, the service has SSL enabled by default, so all data in-transit is encrypted. Scalability: The service allows users to scale compute on the fly without application downtime in one step. Automated backups: Users do not need to independently manage storage for backups. The service offers up to 35 days retention for automated backup.

Date: 2019-09-30

URL: http://feeds.itpro.co.uk/~r/ITPro/Today/~3/RbmknMEUhDs/what-is-azure-database-for-postgresql


46 million Animal Jam accounts leaked after comms software breach (2020-11-13) The company behind the popular kids game Animal Jam has revealed that 46 million useraccounts have been leaked online after an access keyfor a server waslifted from one of its Slack channels WildWorks the parent company of Animal Jam said it was made aware of the breach byalert databaseHaveIBeenPwned which said user data had been shared on the dark web site Raidforums SEE MORE What to do in case o.. 46 million Animal Jam accounts leaked after comms software breach
HP EliteDesk 705 G5 Desktop Mini review: Small in size, big in value (2020-11-09) Were big fans of small computers and between the Raspberry Pi 400 and this diminutive desktop weve been spoilt for choice recently Unlike the Pi however the 5th-generation HP EliteDesk 705 is unabashedly enterprise-focused setting its sights solely on large-scale business deployments with a number of IT-friendly features HP EliteDesk 705 G5 review: Design The EliteDesk 705 is a small form-factor S.. HP EliteDesk 705 G5 Desktop Mini review: Small in size, big in value
Philips Brilliance 328P6 review: A brilliant monitor for a great price (2020-11-06) Philips has embraced the idea of docking monitors with gusto with this P Line monitor here including an RJ-45 Ethernet port along with four USB-A ports: as long as you have a laptop that will charge via the 60W USB-C connection you can reduce the clutter on your desk to that one wire If you arent too fussy about aural output you should also be happy with the pair of 3W speakers; theyre far from au..
Microsoft warns of growing “digital divide” between state and private schools (2020-12-04) Just 1% of public primary schools are able to provide hardware for pupils to take home compared to 38% of private schools according to a new surveyby Microsoft The figures were only slightly better for secondary level with just 7% of state schools able to provide devices for students against 20% of private schools SEE MORE The coronavirus pandemic has transformed the workplace more than any disrup..
How do I fix the Windows 10 Start Menu if it’s frozen? (2019-10-14) When Microsoft decided to bring back the Start Menu with its Windows 10 operating system the move was applauded by users who had struggled to embrace the controversial Start Screen introduced with Windows 8 A central launching point for various tasks this iconic feature has been part of the software since Windows 95 and over the years has become a staple of the operating system The Start Menu is u..
Snapchat now allows you to display subscriber numbers (2020-11-04) Snapchat has added a new feature that allows users to display the number of followers or subscribers they have Users can function on or off as they please The addition of the subscribers display option was first reported by Tubefilter SEE MORE Snapchat introduces two-factor auth but users wont care SEE MORE Snapchat hack prompts release of updated messaging app SEE MORE Snapchat founder devastated..
Foreign Office appoints Joe White as US tech envoy (2020-12-04) Tech entrepreneur and investor Joe White has been appointed as Her Majestys Consul-General to San Francisco and also Britains technology envoy to the US It is the first time the two roles have been merged together as the Foreign Office looks to boost relations between the twotech sectors SEE MORE Biden win would be good for global tech SEE MORE TLA: UKs startup ecosystem needs government support S..
Can you put SSDs in a NAS? (2017-09-21) MostNAS drives will accept 25in drives which means it is entirely possible topopulate them with SSDs But is this a wise idea? The main allure of solid-state storage is its excellent performance - but in this context thats debateable A gigabit Ethernet connection can only manage transfer speeds up to around 110MB/sec so unless youre willing to spend serious money on 10GbE hardware youll see no adva..
What is public key infrastructure (PKI)? (2020-05-27) One of the most important elements of digital encryption and cryptography is public key infrastructure PKI which is an essential component of security technology PKI governs the management and deployment of digital certification and public key encryption by establishing the roles policies and procedures required This crucial element is normally deployed to keep information conveyed through digital..
Outcomes4Me raises $4.7M for its AI-powered breast cancer care app (2020-11-18) Outcomes4Me a free mobile app and platform for cancer patients to navigate cancer treatment and care has raised $47 Million in a funding round led by Asset Management Ventures Others participating in the funding round included Sierra Ventures Merstal Ltd and the National Cancer Institute Outcomes4Me said itll use the funds to expand its reach to a larger number and variety of breast cancer patient..