Blog

I’m seeing a lot of tutorials that claim I have to pick just one of the nodes in my master-master replicated PXC to act as master for an async slave using vanilla mysql replication, and if something goes wrong it’s “easy to change the master to one of the other nodes.” That’s all well andRead more

I have a strange situation I’m are trying to resolve. I’ve googled around but I haven’t found a clear answer so I thought I’d pose it to the good people at DBA on StackEx to get a second opinion. We have a Master server(server1) that has a Hot Standby attached(server2). This runs great (using SR).Read more

I need to create a MySQL slave instance which replicates the data from a MariaDB master. I guess it won’t work. Any advices on how to create this replica architecture using MariaDB and MySQL? I am also investigating and considering using tungsten https://github.com/vmware/tungsten-replicator. Did anybody has experience on it?Read more

Mysql Server-1,Server-2,Server-3 is running as Galera and server-2 is slave. Mysql Server-4 is master. my.cnf file master side is : [MYSQLD] binlog-format=ROW log-bin=binlog server-id=1 and also master side: CREATE USER ‘rep’@’ip slave’ IDENTIFIED BY ‘pass’; GRANT REPLICATION SLAVE ON *.* TO ‘rep’@’ip slave’; FLUSH PRIVILEGES; and my.cnf file Slave side is : [MYSQLD] binlog-format=ROW log-bin=binlogRead more

I have a table now. It has 7 seven partitions, and each day I truncate a partition(not delete, just empty the partition). I have a use case where I would like to have a full backup of the table as well. The backup I want to keep is obviously on some other instance preferably aRead more

I have a master-slave replication for a schema products which is being replicated with binlog_do_db = products. one of the the tables in the master schema is being archived by calling a stored procedure which is in schema products_archive.The data is moved to a different schema on the same database from products to products_archive. STARTRead more

I’m new to the postgresql. Come across this issue and has been scratching my head for couple of days now. Can someoen explain below behavior. I have 2 postgresql-10 servers, one master one slave. Master has following config wal_level = replica max_wal_senders = 10 wal_keep_segments = 10 … Replication works when both servers are online.Read more

I have to setup a MySQL slave on an other infrasctructure. It will become the Master once that other infrasctructure is ready. Mysql 5.6.29 Slave A in old infrasctructure Slave B in new one I dumped the Slave A database by performing a STOP SLAVE;, FLUSH TABLES WITH READ LOCK then the mysqldump and restartedRead more

I am using MySQL to store log data from a number of sensors on-board a boat, and would like to replicate that database to a read only instance of MySQL on a web server. The web server has a static ip, but the log server will have a dynamic ip address from behind different routersRead more

I’ve enabled streaming replication in my postgres 9.5.10 installed from ubuntu xenial repo. I want to enable load balance for pgpool-2 (3.7.0 amefuriboshi) installed from sources. So I have this pgpool.conf: https://pastebin.com/qWWgejQN As you can see, I set both nodes, turned off replication, turned on master/slave mode and set it to stream. And also IRead more