Find Jobs
Hire Freelancers

Create PostgreSQL master to master database replication , RDMS

€30-250 EUR

Zaprt
Objavljeno pred približno 4 leti

€30-250 EUR

Plačilo ob dostavi
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
ID projekta: 23568049

Več o projektu

7 ponudb
Projekt na daljavo
Aktivno pred 4 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
7 freelancerjev je oddalo ponudbo s povprečno vrednostjo €152 EUR za to delo
Avatar uporabnika
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 knowledge of mail server like zimbra, sendmail, web server like Apache, shell scripting, Virtualization like Citrix Xen server, kvm, vmware. I have also done Tally 6.3 Certification. Knowledge of installing and hosting the PHP based application. Knowledge of installation of SSL of Apache and Tomcat. I have knowledge of mysql and oracle database as well. Knowledge of security compliance rule DISA STIGs, PCI-DSS. Knowledge of devops tools like docker, vagrant, jenkins, github etc. Knowlege of Amazon AWS cloud services,windows 2003, 2008, 2012. I have completed the "AWS Solution architect -Associate" training program. Able to create VPC, public-private subnet, route table, Internet gateway, network acl, instance Migration, updation. I have deployed node.js application over SAAS based platform heroku and have done dockerization of node.js app. Cross compilation of source code over Linux for various OS and architecture. Installation of middleman over ubuntu 18.04 Worked on AWS lightsail service to increase the VM size. Tally ERP9 Implementation in SAAS based cloud to let the user access their account from any location. Installation and configuration of pfsense firewall. Thanks
€201 EUR v 7 dneh
4,5 (29 ocen)
5,0
5,0
Avatar uporabnika
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 experience in web systems and on Windows and Linux platforms. In your description we have a divergence, because whenever the resource is restarted it must load the DB content in the cloud again, but with this no type of local grounding will be maintained, because the information from the cloud server will always prevail over the local replica. Could you explain it better? Because if you need local changes to be replicated in the database in the cloud, you will need a bi-directional configuration, which in my understanding would be a cluster and not just replication. Regards, Pascoal Freitas
€300 EUR v 5 dneh
5,0 (5 ocen)
3,2
3,2
Avatar uporabnika
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 have been excellent with JAVA,C#,C/C++ and PHP programming language along with MySQL with XAMPP Server. I also build application for Cloud computing and High performance computing as I also have knowledge regarding Hadoop, MPI, OpenMP (distributed frameworks) and also have build applications in CUDA C++ and OpenCL. I also have experience with the most famous framework ASP.NET. My most expertise are in JAVA where I have built countless projects for semester projects and Final year project. You may find many developers in this field however we assure that you will not be able to find a team like us. We not only ensure the code is quality wise but we also assure that the code we write are optimised and we ensure that the program performs right operation under right environment i.e. we create programs that are defect free. You may also find freelancers that cost low but they do not put their 100% which then shows in the software and leads to an unhappy customer. We ensure reasonable price are put as tag on the job and we ensure in order to give the write product. We highly appreciate your time, if you are interested kindly let me know
€30 EUR v 7 dneh
4,9 (3 ocen)
2,4
2,4
Avatar uporabnika
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 / 2 / 4 / 5 / 6 / 7 / 8, ReactJS - Redux, Jquery),VUE.js,ASP.NET. - CSS, CSS3, Twitter Bootstrap, Less, Sass, Scss, Responsive, Material. - Mobile apps: React Native,Ionic, Swift, ObjectiveC. - Page speed optimize *Backend Skills: - Python (Django), ROR, PHP (Framework: CAKEPHP, Yii, Laravel, Ci), Node.js, C#. - MVC, OOP, CURL, MongoDB, Postgres, MySQL, Rest APIs. *Other skills: - Git, Heroku, SVN, Bitbucket, HG, Linux, Mac - Vagrant, VirtualBox, Gulp, Grunt - AMZ S3, AWS EC2 FREE support after delivery up to 4-6 weeks4 years experience in Reactjs / Redux / Angular / Nodejs / PHP / Django / Backned - Frontend development!
€140 EUR v 7 dneh
4,2 (4 ocen)
2,5
2,5
Avatar uporabnika
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 Graphic Development, Digital marketing too. and had completed a number of projects with some great graphics and User Interface so far. I have all the required skills and experience you need for the above Job. I have strong command over: * WordPress, PHP, Wordpress themeing, Plugin Development * Android and IOS all kind of mobile apps development *Responsive theme Design * HTML5, CSS3 , Jquery, Bootsrtap, Git, * Widget Development * Other CMS: Magento, Joomla, Expression Engine, Drupal etc. * I’m honest & trustworthy, dependable & fast learner. * I’ve over 7 years experience in Wordpress Website designing/development. * I am available 40 hours a week for your job. You can be assured of a quality communication and the quality of the work provided from my end. I’m looking forward to hearing from you soon. Thank you for considering my cover letter.
€90 EUR v 7 dneh
4,0 (1 ocena)
2,4
2,4
Avatar uporabnika
I will help to make GEO level master to master replication
€160 EUR v 7 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava LATVIA
Riga, Latvia
5,0
5
Plačilna metoda je verificirana
Član(ica) od avg. 27, 2017

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.