Reputation
514
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
3 13
Newest
 Nice Answer
Impact
~30k people reached

Jan
2
awarded  Nice Answer
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