0
votes
1answer
28 views

MySQL Replication across two mounts on AWS Amazon Linux

Recently we took advantage of the SSD instance stores available on AWS. While these are great, they obviously get deleted when the instance dies. Obviously the performance of non Provision IOPS is ...
1
vote
1answer
121 views

Fail safe SSH tunnel Ubuntu (always up)

I need your advise for a very important technical issue on our project. We need to have a SSH tunnel always up between our two servers. We have a MySQL database replication process going between those ...
1
vote
2answers
72 views

What is the best time to set the IP address for a server headed to a server colocation facility?

What is the best time to set the IP address for a server? I have a server that I am going to install the OS on and then I am going to send it to a server colocation facility. The server is going to ...
3
votes
1answer
366 views

MySQL master-slave lag replication

Our company is using TokuDB on production and we are having a lot of problems trying to mitigate lag on our slave. Is very strange, because we're talking about very few rows... but with a few data it ...
1
vote
1answer
102 views

Migrate to mysql replication server without interuption

I have a 3 apache2 / tomcat servers in a load balanced setup. Each tomcat server is connecting to a MySQL v5.0 database (all 3 share it). I created on the same network a MySQL v5.5 semisynchronus ...
2
votes
2answers
375 views

MySQL binary logging

My server is telling my that binary logging is disabled. When I do a mysqladmin variables, I see this: log_bin | OFF. This is my configuration file: [mysqld] ...
0
votes
1answer
68 views

Aggregating data from multiple MySQL servers

I have 10 MySQL servers and each one holds a database that needs to be replicated to a single, centralised MySQL server. The complexity is that each server must replicate its database to the same ...
2
votes
1answer
276 views

Replication stops

I have 2 CentOS 5.5 servers runnig Mysql 5.5, configured as master-master replication. When on one server i have network problems, on another i see messages in log: 111105 2:38:30 [Note] Stop ...
1
vote
2answers
195 views

mysql master master master

I have n servers and I am planning to setup n master servers using master-master configuration. What architecture will be the best one ? Also I need to take care of auto-increment table things... ...
0
votes
1answer
47 views

msyql replication time

I am planning to setup mysql master-master or master-slave configuration. Yet to be decided. But my question is, is there any way to specify in the slave or master saying that it needs to check for ...
2
votes
3answers
270 views

mysql replication master master

is it recommended to do mysql master-slave cluster or master-master cluster? do I need a 3rd party tool in order to do a master-master mysql cluster for the virtual IP? (I thought to use heartbeat ...
0
votes
1answer
59 views

how mysql replication

I'm doing mysql replication (master - slave). There are a few questions Can I assign replication for some databases and not all databases that are on master (for example, ON master server there are ...
0
votes
1answer
533 views

MySQL - Why would SHOW SLAVE HOSTS cause a binlog dump?

We're getting loads of binlog files in our MySQL 5.0.x. We have a normal master/slave replication thing going with 1 master, 1 slave. Looking at /var/log/mysql.log, nearly 90% of the time the ...
0
votes
2answers
160 views

Lots of tiny mysql-bin.NNNN files

We're using mysql 5.0.somethin with a binary log and replication. However /var/log/mysql is full of lots of tiny 141 byte sized mysql-bin.NNNNN files. using mysqlbinlog I can see that they are empty ...
41
votes
9answers
47k views

How can I export the privileges from MySQL and then import to a new server?

I know how to export/import the databases using mysqldump & that's fine but how do I get the privileges into the new server. For extra points, there are a couple of existing databases on the new ...