|
Hi Ted,
On May 16, 2017, at 8:43 PM, Theodore Petrosky < email@hidden> wrote:
I
thought I could troll my way into something, but you caught me.
My backup needs have always been very small. It’s the beauty of WO to be able to present the user with just enough. I was actually hoping to hear from people that manage BIG data. maybe not as big as iTunes, but I still big.
what kind of strategy do you have when your data is in the terabyte or petabyte range?
We use Oracle databases, and utilize their backup solution. We also use their replication technology to keep two other databases up-to-date, using the co-located one as a read-only query database (our apps have connections to this for certain types of
queries) and the one in a separate city as a disaster recovery system. With these two available to quickly switch to in the case of losing the primary database, the backups are used more for the type of emergency where we need to restore a copy of a table
to some previous state.
Thanks for not letting me pretend troll you into a distro war. They all work just fine.
— Mark
On May 16, 2017, at 9:17 PM, Matthew Ness < email@hidden> wrote:
Hi
Ted,
Just
on backups and PostgreSQL, it's maybe worth noting that as well as
backups
in the RDS space, it's trivial to also use traditional 'backup'
and
'restore' functionality, if you need to move, replicate, backup
on-premise,
etc.
I
wont be drawn into any flavour-distro wars (!), suffice to say Amazon
linux
meets out requirements.
Regards,
Matt
On
Wed, May 17, 2017, at 10:46 AM, Theodore Petrosky wrote:
No, there are no wars here because we know that postgresql is better in
all ways over MySQL. I mean really, just look at their names one begins
with a ‘p’ and the other an ‘m’. That tells you everything!
Thanks for the info. I am collecting a list of OSs and VMs that I have
successfully installed WO for deployment.
So far, I have Centos on ESXi running on a mac mini. Now using AWS, I
have succeeded with Amazon Linux AMI 2017.03.0 and Red Hat Enterprise
Linux 7.3.
I also found that Centos is available in the AWS VM, so I may give that a
go just to say I did it.
Lots of fun!!!
Thanks again for the info.
Ted
On May 16, 2017, at 7:13 PM, Paul Hoadley <email@hidden> wrote:
On 17 May 2017, at 6:22 am, Theodore Petrosky <email@hidden <mailto:email@hidden>> wrote:
How do you feel about responsiveness, especially postgresql responsiveness?
We haven’t done any serious testing, but PostgreSQL on RDS is quite sufficient for our needs.
I have never had any real experience with MySQL so i don’t want to even ask.
Yeah, at the risk of starting a war, my advice would be if you’re in a position to choose, choose PostgreSQL over MySQL.
--
Paul Hoadley
http://logicsquad.net/ <http://logicsquad.net/>
https://www.linkedin.com/company/logic-squad/
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Matt
http://logicsquad.net
_______________________________________________
Do
not post admin requests to the list. They will be ignored.
Webobjects-dev
mailing list (email@hidden)
Help/Unsubscribe/Update
your Subscription:
This
email sent to email@hidden
_______________________________________________
Do
not post admin requests to the list. They will be ignored.
Webobjects-dev
mailing list (email@hidden)
Help/Unsubscribe/Update
your Subscription:
This
email sent to email@hidden
|