484 reputation
312
bio website healy.net.au
location Western Australia, Australia
age 28
visits member for 3 years, 6 months
seen 10 hours ago

I'm a web developer from Perth, Western Australia. I mainly code in Perl during the day, and at night I'm learning to use Python and the Django Framework. On the odd occasion I'll also fiddle with some PHP when I'm making a Wordpress site for a client. I have experience with *nix server administration, including Linux, Apache, MySQL, Varnish, Cisco, NetApp, AWS products such as EC2, RDS, SQS and much more.


May
19
comment Sync two MySQL databases in two different locations
To use replication, your internal database would need to be accessible over the network from the web host.
May
19
comment Sync two MySQL databases in two different locations
Yes, that will be the easiest path to take in that case.
May
19
answered Sync two MySQL databases in two different locations
May
9
answered Create read only user without being root
May
4
answered MySQL 5.6 showing wrong “second_behind_master”
Apr
24
awarded  Critic
Apr
21
comment How can I store least used table files to a slower drive?
Look in to partitioning for MySQL
Apr
21
accepted Replication from EC2 Master to RDS Slave - Connecting to master
Apr
21
awarded  Benefactor
Apr
21
comment Replication from EC2 Master to RDS Slave - Connecting to master
Since posting my question I've already completed the migration of the production MySQL database (using mysqlbinlog to apply updates missing since the baseline dump) but I've tried the above in a test instance and it worked - thanks!
Apr
15
awarded  Promoter
Apr
14
revised Replication from EC2 Master to RDS Slave - Connecting to master
Added further information
Apr
12
asked Replication from EC2 Master to RDS Slave - Connecting to master
Dec
11
answered How to give a client backups of their data without compromising our database design?
Mar
19
awarded  Notable Question
Jan
11
awarded  Yearling
Aug
3
comment How to import Timestamp from a CSV file
Show us what you're trying to do... What does the CSV data look like? What is your table structure?
Jun
8
awarded  Caucus
May
21
answered Centos 6.2 mysql configuration file help
May
17
answered Replication with only update and insert