Đã Đóng

Create PostgreSQL master to master database replication , RDMS

Hello there!

I would like to receive assistance (instruction based) to create a master to master replication of the PostgreSQL 10 database.

I am looking for something similar like global transaction identifier based replication (this is how it's called in MySQL). I hope there must be something analogous in PostgreSQL.

Currently, I am running a PostgreSQL 10 database server in the cloud (digital ocean) on the top of CentOS 8. 1 CPU, 1GB RAM, 2GB SWAP, 25GB disk. It's not an RDS service.

The content in the database server is tiny (currently less than 1GB of data with the plans to grow up to 9GB). The database server runs multiple databases inside. Each database is a Relational Database.

I would love to have a master to master replication with a "ground" instance. It's a workstation like Linux box. 4 CPUs, 32GB RAM.

Ideally, when a new database (not table) is created (in a cloud or at the "ground") it should be replicated to the other node.

The "groud" instance is running Debian 9 (stretch) based Linux distro. Runs "MX Linux 18" more precisely.

The whole idea of replication is to connect a local application (web-based) to the local database engine.

I guess it's configurable to instruct the database engine at system startup to serve all content in memory. So I can access the data in the database with the very best access time.

The local "ground" database will be used mostly for reads only, but a couple of inserts/deletes may occur sometimes (while foreign keys ON).

The cloud instance is online all the time but the "ground" instance can be offline for 7 days.

The "ground" instance must be capable to keep up with the cloud instance once it's back online. The quality of the network is 200Mbit up/down.

My expectation is: once the workstation has a fresh boot, it will "download" all the updates while sustaining everything in memory.

The architecture should be scalable so if I decide to have 2 different workstations (not online at the same time) it should be capable to replicate the content again from master (cloud) instance.

To complete the project I hope to receive instructions in a pure text document containing comments per command.

Plus some explanation per option installed regarding the database tuning config per machine.

In response please include some keywords from the project description so I will know I'm talking to a real person.

Kindly include a tiny note of how the project will be implemented. Introduce some downsides, if any. What advantages can be used if a more recent version of the PostgreSQL server is used?

Thank you very much for reading so far. Looking forward to hear from you,

Aigars

Kĩ năng: Linux, Quản trị cơ sở dữ liệu, PostgreSQL, Quản trị hệ thống

Xem nhiều hơn: create search database business phone numbers, php create small database, create excel database can posted forums, project create music database, create access database vbs, create mysql database iis, autocad 2008 create object database, joomla component create application database, create online database post csv, php create install database script, create website database, create webstore database, wordpress create plugin database access, create mysql database phpmyadmin, create sitemap database, joomla database replication, phpfilenavigator create mysql database

Về Bên Thuê:
( 3 nhận xét ) Riga, Latvia

ID dự án: #23568049

9 freelancer đang chào giá trung bình €167 cho công việc này

PeterLi0529

"To complete the project I hope to receive instructions in a pure text document containing comments per command." Hi there. Thank you for your posting. I am familiar with PG HA, Disaster Recovery, Load balancing and Thêm

€250 EUR trong 7 ngày
(8 Nhận xét)
5.2
android2014213

I am experienced in debian9 and Postgresql replication. Please checkout my profile. Dear Hiring Manager, I am Redhat Certified Engineer. I have 8 years of experience as a Linux System Administrator. I posses good kno Thêm

€201 EUR trong 7 ngày
(17 Nhận xét)
4.4
psfreitas

Hello, I am interested in carrying out your project. With this follows proposal for execution of the work as its description. I work with IT consulting and support, and work directly with cloud environments. I have ex Thêm

€300 EUR trong 5 ngày
(4 Nhận xét)
3.0
rflurey

Hi, I am a very experienced DBA by trade and have worked with multi-national companies in global teams supporting clustered and HA Postgres installations up to the latest version (including Deutsche Telekom in 901 phy Thêm

€190 EUR trong 3 ngày
(2 Nhận xét)
2.7
hsh564cf84accd96

I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in programming and development I Thêm

€30 EUR trong 7 ngày
(3 Nhận xét)
2.4
vaibhavAP

5 years experience in Reactjs / Redux / Angular /Vue / Nodejs / ASP.NET / PHP / Django / Backned - Frontend development! All of our programming skills: *Front-end: - HTML, HTML5, JSON. - JAVASCRIPT (Ajax, AngularJS Thêm

€140 EUR trong 7 ngày
(4 Nhận xét)
2.5
techobrie

I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 15 years of experience in Web Designing and Development, AI, Mobile Development and various exepertise in Graph Thêm

€90 EUR trong 7 ngày
(1 Nhận xét)
2.4
c810605

Hi, sir. Thanks for your post. I've experience in React.js and the use of Redux. And I've used both react-d3 and react-highchart. I've used react-highchart for showing highstock graph (in cryptocurrency exchange pr Thêm

€140 EUR trong 7 ngày
(0 Nhận xét)
0.0
hemanth48049

I will help to make GEO level master to master replication

€160 EUR trong 7 ngày
(0 Nhận xét)
0.0