Re: multi master auto syncing when servers back on line

2012-06-06 Thread Andrew Moore
Joey, sounds like you've got a lot of testing to do before you can deploy and support this in production yourself with out fear of shooting yourself in the foot. Whilst you're trialling things, you could try 'XtraDB Cluster' from percona. A On Wed, Jun 6, 2012 at 5:09 AM, Joey L

Re: multi master auto syncing when servers back on line

2012-06-06 Thread Joey L
But andrew do you have an answer for me why i am getting this error ? thanks On Wed, Jun 6, 2012 at 9:09 AM, Andrew Moore eroomy...@gmail.com wrote: Joey, sounds like you've got a lot of testing to do before you can deploy and support this in production yourself with out fear of shooting

Re: multi master auto syncing when servers back on line

2012-06-06 Thread Joey L
Can you tell me what permissions are needed for the user to run these utilities so i can sync the tables ? I have only assigned them replication slave right. thanks On Wed, Jun 6, 2012 at 9:09 AM, Andrew Moore eroomy...@gmail.com wrote: Joey, sounds like you've got a lot of testing to do before

Connect to MySQL server from a c++ application

2012-06-06 Thread Simon Walter
What is the most stable and performant way to connect to a MySQL server from a c++ application? I've been using libmyodbc via unixODBC running under Debian squeeze. Suffice it to say, I am sorely disappointed. First of all the libmyodbc driver that's included with Debian is quite old.

Re: Connect to MySQL server from a c++ application

2012-06-06 Thread Lars Nilsson
On Wed, Jun 6, 2012 at 10:41 PM, Simon Walter si...@gikaku.com wrote: However, memory leaks are not acceptable. So I am open to suggestions. What do other c++ programmers use? I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work. Commercial and not open source, but it's