424 reputation
821
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 6 months
seen 4 hours ago

I'm an Oracle certified Database Administrator

I've worked extensively with both Oracle and Postgres, in various roles from DBA to developer. I have a basic working experience with SQL Server and MySQL.


Jul
4
comment Website high availability without load-balancer?
@MadHatter is there an obvious alternative that doesn't involve IP sharing between locations (which is out of our budget range)?
Jul
4
comment Website high availability without load-balancer?
@Nathan DNS caching is an issue with the current setup, are you saying it would be worse?
Jul
4
asked Website high availability without load-balancer?
Jul
2
awarded  Curious
Jul
1
awarded  Talkative
Mar
22
comment RAID 0 InnoDB speed - Comparing 8 x 7,200 RPM drives or 4 x 15,000 RPM drives
8x7200 will have roughly the same average rotational latancy as 4x15k. However rotational latency isn't the only variable in seek time, plus there's a whole bunch of other factors affecting overall performance.
Mar
5
awarded  Nice Answer
Mar
1
answered Software RAID10 for later growth
Jan
23
revised Set up RDS on multiple servers using PowerShell
the server names seem to need to be fully qualified
Jan
23
accepted Set up RDS on multiple servers using PowerShell
Jan
23
suggested approved edit on Set up RDS on multiple servers using PowerShell
Jan
23
comment Set up RDS on multiple servers using PowerShell
Just what I was looking for, thanks. I'd seen that guide but not read through it properly (maybe because of the small writing!).
Jan
22
asked Set up RDS on multiple servers using PowerShell
Jan
11
accepted Splitting up RDS roles
Jan
11
comment Splitting up RDS roles
I've edited in my rationale, thanks for the questions.
Jan
11
revised Splitting up RDS roles
rationale explanation
Jan
10
asked Splitting up RDS roles
Oct
24
awarded  Notable Question
Oct
9
awarded  Notable Question
Sep
26
comment Slow software raid with SSDs
sorry, all three configurations: you'd need to show that both drives function the same on their own…