Displaying 20 results from an estimated 80000 matches similar to: "Problems with MySQL Replication and Migrations"
2006 Jan 19
3
problems with migrations in sql server
Is anyone using migrations with a SQL Server database who might be able to
lend me a hand? I''ve used migrations with MySql in the past and haven''t
run into any issues so forgive When I run rake migrate nothing is actually
getting updated in my database. I created a migration using
./script/generate migration AddFooTable and updated the migration to look as
follows:
class
2007 May 21
0
Migrations : change schema_info table name ?
Hi,
my company uses only 1 database for all the developments, so it is a big
problem for using migrations in Rails because of the schema_info table.
How can I solve this problem? Is there a way to change the schema_info
table name?
Thanks.
Nicolas.
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are
2007 Sep 26
0
Fwd: error with schema_info when doing multiple migrations
Posting to merb list in case it is a merb problem. (?!??)
The error still happens with sequel 0.2.1.
---------- Forwarded message ----------
From: Kevin Williams <kevwil at gmail.com>
Date: Sep 23, 2007 10:26 AM
Subject: error with schema_info when doing multiple migrations
To: sequel-talk at googlegroups.com
I tried to post an issue to the project site but it kept giving me 500
server
2006 Mar 08
3
migrations schema_info table, Rails Recipes Bug?
I have the rails recipes book and i was going through the migrations
recipe. Everything seemed to work except for the last part in trying to do
a rake migrate with a migration file version 1 and the schema_info version
set to 0. Without the force attribute, the rake migration fails, as
expected.
So the recipe says to run this:
ruby script/runner
2007 May 01
0
RE: Voicemail on Different Server (MySQL Replication split thread)
> Having master and slave servers in the same switch fabric is the only
> situation in which I would consider replication.
>
> The cases that I described were with machines in separate subnets.
> Replication simply doesn't work that well when there is significant
> latency. Did they mention that in your HA class?
>
We setup lab scenarios of replicating databases in
2007 Oct 06
2
near-realtime file system replication
Whats available for doing near-realtime master->slave file replication
between two CentOS systems?
Cronjobs running rsync won't cut it.
Ideally, I'd like something that works like SLONY-I does for Postgres
databases, where all file system block level transactions on the master
get replicated to the 2nd system on a 'as fast as practical' basis (a
second or two of lag
2015 Mar 12
0
mysql replication - problems
On Thu, Mar 12, 2015 at 8:57 AM Tim Dunphy <bluethundr at gmail.com> wrote:
> Hey everybody,
>
> I'm trying to get mysql master/slave replication to work under SSL. I've
> created the certs for both the slave and the master. I've configured the
> master and slave my.cnf. And it does appear that replication is actually
> working.
>
> Master is actually
2011 Feb 14
0
Puppet configuration for MySQL master-slave replication
I ''m a beginner to puppet . I know only basic stuffs about puppet.
I would like to create a puppet configuration in which the master''s
configuration can be tweaked so as to perform replication and new mysql
slave nodes will be automatically configured to become replica
I''m able to perform some basic operations on MySQL server using this
article [
2006 Apr 20
0
Migrations that don''t affect schema_info.version?
Hi,
I am wondering whether it is possible to write and use migrations that
do not change the schema_info.version.
I would like to use the migration syntax to do certain tasks that don''t
affect the schema like populating tables with sample data during
development.
Ingo
--
Posted via http://www.ruby-forum.com/.
2014 Aug 13
2
MySQL - replication - how to restore master?
Hello,
We have MySQL running as a master which is replicating to a single slave
server. We are, however, considering what is required when a 'disaster'
of some sort happens to either server. By disaster, this could be some
event which requires the entire server to be rebuilt, and which would
usually include restoring from nightly backups directories such as
'/var/lib/mysql' and
2003 Nov 05
0
Linux and Replication: Reducing Cost and Risk in Migrations - Web Seminar Invitation
Sybase Presents
"Linux and Replication: Reducing Cost and Risk in Migrations"
Date: Tuesday, November 18, 2003
Time: 10:00 a.m. PST/1:00 p.m. EST
Duration: One hour
Linux. Low cost platform. High performance. So, the question with Linux is no longer "why", but "how". During this Web Seminar, you'll learn how to use replication to successfully migrate to Linux.
2006 Jul 04
4
MySQL error when running rake migrate
Running rails 1.1 and MySQL 5 on Kubuntu. I moved the same rails project
from one machine to another. To set up the database I try to run `rake
migrate` but I am greeted with the error/stack trace below. Any idea why
this could be? It doesn''t seem to be a permissions problem--I can login
to the database as my application just fine. I tried downgrading MySQL
to v4.1 because that is
2015 Mar 12
3
mysql replication - problems
>
> The mysqld process runs as the mysql user. It's parent which is the
> mysqld_safe runs as the root user. That being said the mysql user needs
> to have at least read permission to the locations where the ssl files are
>
> located. By default on Centos the /etc/pki/CA/private directory has its
> directory permissions to only allow the root user. If the mysql
2005 Dec 14
3
Plugin w/ Migrations and/or Fixtures?
I''m working on a plugin which needs to add both schema and data to the app
database, and I''m trying to figure out the best way to do it. I''d like to use a
db migration to modify the schema and load the data from a YAML fixture, but
Rails doesn''t seem to support migrations for plugins. To do so, the schema_info
table would need to change to include a
2005 Dec 23
1
Better way to import initial migration?
On a rails app that I''m developing I converted a regular old .sql file
into a rails migration. Since I generated the migration in my
development environment, it created the schema_info table for me.
However, when I updated my production environment and tried running
rake migrate it complained that schema_info doesn''t exist. Is there a
rake task for getting around this yet, or
2018 Mar 02
0
geo-replication
Hi Kotresh,
I am expecting my hardware to show up next week.
My plan is to run gluster version 3.12 on centos 7.
Has the issue been fixed in version 3.12?
Thanks a lot for your help!
/Marcus
On Fri, Mar 02, 2018 at 05:12:13PM +0530, Kotresh Hiremath Ravishankar wrote:
> Hi Marcus,
>
> There are no issues with geo-rep and disperse volumes. It works with
> disperse volume
> being
2018 Feb 21
0
Geo replication snapshot error
Hi,
Thanks for reporting the issue. This seems to be a bug.
Could you please raise a bug at https://bugzilla.redhat.com/ under
community/glusterfs ?
We will take a look at it and fix it.
Thanks,
Kotresh HR
On Wed, Feb 21, 2018 at 2:01 PM, Marcus Peders?n <marcus.pedersen at slu.se>
wrote:
> Hi all,
> I use gluster 3.12 on centos 7.
> I am writing a snapshot program for my
2012 May 02
0
down to the nitty gritty, mysql replication
Almost done with my centos handbook project on my server.
Last two things are related, backups.
Looking for anyone who feels like chiming in on mysql backups...this is
what I am thinking at this point.
Mysql backup system for all websites
----------------------------------------------------
Each website is on a separate server, each running mysql, no site is
related to the others.
A server
2015 Sep 02
0
Verify that user replication between master and slave through the logs?
On 01/09/15 22:50, Elias Pereira wrote:
> Hello guys,
>
> On my other e-mail does not properly explain what I was looking for.
>
> I made the data replication between two domain controllers Samba 4. At this
> point everything is okay. When I create a user, for example in master,
> after a few seconds the slave already have this user.
>
> What I want to know is how can I
2006 Mar 16
1
Use Migrations in modules in separate source trees?
We have a scenario where we have a core engine with module add-ons. What
modules that will be used differ from deployment to deployment. Each of
these modules might need different things in the db (both structure and
data) and I want each module to be in charge of its own db structure.
Each module is contained in its own source directory and what modules to
use is determined in the build