MySQL Router 8.0.16 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users, MySQL Router 8.0.16 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.16. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

MySQL Router 8.0.15 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users, MySQL Router 8.0.15 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.15. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

MySQL Shell 8.0.15 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users, MySQL Shell 8.0.15 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle's dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8.0.15

MySQL Shell 8.0.14 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users, MySQL Shell 8.0.14 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle's dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8.0.14

MySQL Router 8.0.14 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users, MySQL Router 8.0.14 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.14. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

MySQL Router 8.0.13 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users, MySQL Router 8.0.13 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.13. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

MySQL Shell 8.0.12 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users, MySQL Shell 8.0.12 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle's dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8.0.12

Re: MySQL server has gone away

Am 03.04.2017 um 21:22 schrieb Mahmood N: well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! on a proper server you have a local smtpd like postfix listening on 127.0.0.1 and hence you can send thousands of messages within seconds

Re: MySQL server has gone away

>well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! Anyway, thanks.  Regards, Mahmood On Monday, April 3, 2017 11:37 PM, Reindl Harald wrote: Am 03.04.2017 um 20:41 schrieb Mahmood N: > Good news! > > I

Re: MySQL server has gone away

Am 03.04.2017 um 20:41 schrieb Mahmood N: Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. well, who did set it that low?

Re: MySQL server has gone away

Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. Regards, Mahmood On Monday, April 3, 2017 10:32 PM, Mahmood N wrote: Dear reindl, I tested with both 5 and 1 and see the log

Re: MySQL server has gone away

Dear reindl, I tested with both 5 and 1 and see the log files are empty. I am really confused about that error and it is taking more than 2 weeks about that! Regards, Mahmood

Re: MySQL server has gone away

Am 03.04.2017 um 19:45 schrieb Mahmood N: So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty WTF - you had it set to 5 seconds 2 hours ago i am out here... Am 03.04.2017 um 18:11 schrieb Mahmood N: > The my.conf file contains >

Re: MySQL server has gone away

So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty.  Regards, Mahmood

Re: MySQL server has gone away

>since when is phpinfo() - the *real* active configuration be it changed >by some config snippet, vhost-configuration or even ini_set() - the same >than a random file in /etc? Sorry I totally didn't understand that sentence... Regards, Mahmood

Re: MySQL server has gone away

Am 03.04.2017 um 19:26 schrieb Mahmood N: given that a reasonable server should be able to handle hunredts to thousands of requests per second anything above 1 second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit

Re: MySQL server has gone away

>given that a reasonable server should be able to >handle hunredts to thousands of requests per second anything above 1 >second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit the email test, the refresh time for that

Re: MySQL server has gone away

quests per second anything above 1 second is a alert sign I restarted the mysql server (/etc/init.d/mysql restart on ubuntu) and tested the email page one again. I again see that error message on the browser, however, the log files are empty. look also in phpinfo() for mysqlnd and mysql params

Re: MySQL server has gone away

query_cache_size = 16M thread_cache_size = 8 max_allowed_packet = 8M I restarted the mysql server (/etc/init.d/mysql restart on ubuntu) and tested the email page one again. I again see that error message on the browser, however, the log files are empty.  Regards, Mahmood

Re: MySQL server has gone away

Am 03.04.2017 um 17:52 schrieb Mahmood N: Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one

Re: MySQL server has gone away

Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one terminal and at the same time, submit a test

Re: MySQL server has gone away

On 4/3/2017 8:15 AM, Mahmood N wrote: When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor. Commands end with

Re: MySQL server has gone away

When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 30912

Re: MySQL server has gone away

I'd suspect the underlying query is poorly designed for the amount of data you have stored. If you have access to the mysql server you could connect to it using any mysql client and run 'show full processlist' to see the query as that page is trying to load. The query is probably in the 'sending

Re: MySQL server has gone away

of the page becomes high (in the order of 3-5 minutes) and at the end, I see this message Debug info: MySQL server has gone away SELECT id, sid, state, userid, lastip, timecreated, timemodified FROM mdl_sessions WHERE sid = ? [array ( 0 => 'jqfbgd5b0q6e2l81bb5gb87mn3', )] Error code: dmlrea

Re: MySQL server has gone away

email plugin and execute the command, the refresh >time of the page becomes high (in the order of 3-5 minutes) and at the >end, I see this message >Debug info: MySQL server has gone away >SELECT id, sid, state, userid, lastip, timecreated, timemodified FROM >mdl_sessions

MySQL server has gone away

Hi,I am using Moodle which itself uses SQL for the database. Problem is that, when I run the email plugin and execute the command, the refresh time of the page becomes high (in the order of 3-5 minutes) and at the end, I see this message Debug info: MySQL server has gone away SELECT id, sid

compile problem with newest version of mysql-server

Hi all, Recently, I got the newest version of mysql-server from the github, Bug I got some compile problem as follows: cmake -DCMAKE_INSTALL_PREFIX=/u04/my3306 \ -DMYSQL_DATADIR=/u04/my3306/data -DMYSQL_USER=mysql \ -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1

Re: Specking a small MySQL server

- Original Message - From: Richard Reina gatorre...@gmail.com Subject: Specking a small MySQL server somewhat of an energy hog and is due to be replaced. I was considering replacing it with a lap-top so as to conserve energy and because a laptop has a built in battery backup

Specking a small MySQL server

I have used MySQL for about twelve years as a database on our private LAN that has only a handful of users at a time that query about a dozen databases. The current server is an old rack-mounted machine that is somewhat of an energy hog and is due to be replaced. I was considering replacing it

Cannot build static mysql server

I try to cpmpile mysql-with no shared, but have an error when configuring: mkdir -p ~/src/mysql/bld \ cd ~/src/mysql/bld \ (make clean; rm ~/src/mysql/bld/CMakeCache.txt; echo 1) \ cmake .. -DCMAKE_INSTALL_PREFIX=/opt/mysql -DBUILD_CONFIG=mysql_release -DMYSQL_DATADIR=data

Why MySQL-server-5.5.37 install fail?

I'm newbie to mysql and I want to install mysql under Centos 5.8 using MySQL-server-5.5.37-1.linux2.6.i386.rpm, I use following command to intall mysql #[root@master software]# rpm -ivh MySQL-server-5.5.37-1.linux2.6.i386.rpm Preparing

Re: Why MySQL-server-5.5.37 install fail?

Am 04.05.2014 08:29, schrieb EdwardKing: I'm newbie to mysql and I want to install mysql under Centos 5.8 using MySQL-server-5.5.37-1.linux2.6.i386.rpm, I use following command to intall mysql #[root@master software]# rpm -ivh MySQL-server-5.5.37-1.linux2.6.i386.rpm Preparing

Re: Why MySQL-server-5.5.37 install fail?

Hello, mysqladmin and mysql command-line client is included in MySQL-client package. mysql_secure_installation is included in MySQL-server but it's a perl script which calls mysql command-line client internally. Thus, you should install MySQL-client-*.rpm and try again. Regards, 2014-05-04

mysql server does not start

i made a different datadir and gave ownership and rights to mysql and trsted with su that mysql can read host.frm still errno 13: cannot acess ./mysql/host.frm my datadir comtains the mysql dir/schema pls help! i run ununtu thanks nicu

Questions about building a dedicated MySQL server.

I am looking at building a dedicated MySQL server... was wondering about the downside to using SSD drives? My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1) configuration. Is this a good idea? I was originally thinking about going Raid5(3+1) and Raid 1 (Mirrored

Re: Questions about building a dedicated MySQL server.

On 17-03-2014 16:21, Mister Vlad wrote: I am looking at building a dedicated MySQL server... was wondering about the downside to using SSD drives? My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1) configuration. Is this a good idea? I was originally thinking about going

Install mysql server using RPM

Hi all, I am trying installing Mysql server using RPM bundle rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm rpm -i MySQL-client-5.6.16-1.el6.x86_64.rpm next i would like to start the server, i followed the mysql docs: The server RPM places data under the /var/lib/mysql directory. The RPM also

Re: Install mysql server using RPM

issue: mysql at the command prompt and let me know. also post the output of ls /var/lib On Mon, Mar 3, 2014 at 1:53 PM, Asma rabe asma.r...@gmail.com wrote: Hi all, I am trying installing Mysql server using RPM bundle rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm rpm -i MySQL-client-5.6.16

Re: Install mysql server using RPM

- Original Message - From: Asma rabe asma.r...@gmail.com Subject: Install mysql server using RPM rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm rpm -i MySQL-client-5.6.16-1.el6.x86_64.rpm I seem to recall that Oracle's Debian -server package included the clients already. You may

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014/1/7 h...@tbbs.net 2014/01/06 17:07 +0100, Reindl Harald what about look in the servers logfiles most likely max_allowed_packet laughable low Is this then, too, likly when the server and the client are the same machine? I left this out, that it only then happens when the client has

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014/01/06 17:07 +0100, Reindl Harald what about look in the servers logfiles most likely max_allowed_packet laughable low Is this then, too, likly when the server and the client are the same machine? I left this out, that it only then happens when the client has been idle, and right

ERROR 2013 (HY000): Lost connection to MySQL server during query

Now that I installed 5.6.14 on our Vista machine, when using mysql I often see that error-message, which under 5.5.8 I never saw. What is going on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

Am 06.01.2014 15:36, schrieb h...@tbbs.net: Now that I installed 5.6.14 on our Vista machine, when using mysql I often see that error-message, which under 5.5.8 I never saw. What is going on? what about look in the servers logfiles most likely max_allowed_packet laughable low

Lost connection to MySQL server - need help.

(): Lost connection to MySQL server at 'reading initial communication packet', system error: 111 I stopped the server and restarted it and everything seems to work OK for hours but when the load start to increase, the errors begin to appear again. Today I noticed that after I starte phpMyAdmin

Re: Lost connection to MySQL server - need help.

You might want to comment bind-address= 127.0.0.1 in your my.cnf and restart mysql server. On 12/10/13 10:49, Jørn Dahl-Stamnes wrote: Hello, I got a strange problem related to a production server. It has been working OK for months, but yesterday it start to fail

Re: Lost connection to MySQL server - need help.

On Saturday 12 October 2013 12:01, nixofortune wrote: You might want to comment bind-address= 127.0.0.1 in your my.cnf and restart mysql server. It does not explain why it works under low load and not under high load. However, I seem to have found something. When I started

Re: Lost connection to MySQL server - need help.

= 127.0.0.1 in your my.cnf and restart mysql server. It does not explain why it works under low load and not under high load. However, I seem to have found something. When I started phpMyAdmin and selected one of the database, the server went away again and I found this in /var

Re: Lost connection to MySQL server - need help.

On Saturday 12 October 2013 13:07, Andrew Moore wrote: Could be a crash related to innodb data dictionary being out of sync. Could be a bug. Seems like a bug yes. However, we had a strange situation yesterday when we had several processes in the state copying to tmp table (if i remember the

Re: Lost connection to MySQL server - need help.

Am 12.10.2013 17:02, schrieb Jørn Dahl-Stamnes: On Saturday 12 October 2013 13:07, Andrew Moore wrote: Could be a crash related to innodb data dictionary being out of sync. Could be a bug. Seems like a bug yes. However, we had a strange situation yesterday when we had several processes

Re: Lost connection to MySQL server - need help.

On Saturday 12 October 2013 17:36, Reindl Harald wrote: so someone did optimize table on a large table you do yourself not a favour restarting the server in such a moment 7 hours before the server was shut down, we did a alter table to add a primary key to a table that is read-only from the

Re: Lost connection to MySQL server - need help.

Am 12.10.2013 19:45, schrieb Jørn Dahl-Stamnes: On Saturday 12 October 2013 17:36, Reindl Harald wrote: so someone did optimize table on a large table you do yourself not a favour restarting the server in such a moment 7 hours before the server was shut down, we did a alter table to add a

Re: Lost connection to MySQL server - need help.

We had a similar issue a bit back - and although it sounds similar - based on your followups it probably isnt, but will just toss this out there anyhows. We were experiencing connection timeouts when load would ramp up. Doing some digging we learned that our firewall between the servers

Re: Lost connection to MySQL server - need help.

sounds like a scheduler issue did you try deadline? http://en.wikipedia.org/wiki/Deadline_scheduler on Linux systems pass elevator=deadline as kernel param Am 12.10.2013 20:58, schrieb Chris McKeever: We had a similar issue a bit back - and although it sounds similar - based on your followups

Why ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)?

hi all: I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql client in 192.168.23.73. I use this way: mysql -h 192.168.27.72 -u root -p the ERROR message is: ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111

Re: Why ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)?

Assuming Linux, check where it's listening using netstat -lptn. lx lxlenovos...@gmail.com wrote: hi all: I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql client in 192.168.23.73. I use this way: mysql -h 192.168.27.72 -u root -p the ERROR message is: ERROR 2003 (HY000

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013/5/22 Tim Callaghan tmcallag...@gmail.com Rafal, I don't believe TRIM is supported for XFS. I tried this two weeks ago and worked pretty well: http://xfs.org/index.php/FITRIM/discard Manuel.

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

- Original Message - From: Rick James rja...@yahoo-inc.com Subject: RE: Mysql server - which filesystem to choose? Is it really that important nowadays? ext does less well with simultaneous IOPs than xfs. Possibly, but how much less (and which ext)? Without numbers that's not very

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

Thanks for the information, I'll give it a try myself. On Thu, May 23, 2013 at 5:02 AM, Manuel Arostegui man...@tuenti.com wrote: 2013/5/22 Tim Callaghan tmcallag...@gmail.com Rafal, I don't believe TRIM is supported for XFS. I tried this two weeks ago and worked pretty well:

Mysql server - which filesystem to choose? Is it really that important nowadays?

Hi All. I use mysql/perconna/maria on my production CentOS 6 Linux servers. I currently try to choose the default filesystem for partitions with mysql data. Some time ago (previous dba) reiserfs was the choice but now it is not in the kernel and the main author is in prison. From what I've read

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013/5/22 Rafał Radecki radecki.ra...@gmail.com Hi All. I use mysql/perconna/maria on my production CentOS 6 Linux servers. I currently try to choose the default filesystem for partitions with mysql data. Some time ago (previous dba) reiserfs was the choice but now it is not in the kernel

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

Rafal, I benchmark a lot on various hardware and software configurations. When I started 2 years back I went along with the general consensus that XFS is faster than ext4 for MySQL. I recently had the opportunity to see how much of a difference, if any, it made. I didn't find much, especially

RE: Mysql server - which filesystem to choose? Is it really that important nowadays?

ext does less well with simultaneous IOPs than xfs. -Original Message- From: Manuel Arostegui [mailto:man...@tuenti.com] Sent: Wednesday, May 22, 2013 12:22 AM To: Rafał Radecki Cc: mysql@lists.mysql.com Subject: Re: Mysql server - which filesystem to choose? Is it really

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

the file works fine, in about 12 sec/77 sec. I read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10 minutes). What is the exact error message? Which client are you using to do the query? It's strange that the query

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

; The query without exporting the file works fine, in about 12 sec/77 sec. I read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012/07/26 06:52 +0530, Dhaval Jaiswal SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n' as above give your join condition before INTO OUTFILE. Right: MySQL server writes into some directory where it is, not where MySQL client

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

Thanks! On Thu, Jul 26, 2012 at 12:05 AM, h...@tbbs.net wrote: 2012/07/26 06:52 +0530, Dhaval Jaiswal SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n' as above give your join condition before INTO OUTFILE. Right: MySQL

Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

the file works fine, in about 12 sec/77 sec. I read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10 minutes). I'm

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10 minutes). I'm wondering: a) What is going on? b) How do I

Re: i need advice on redundancy of mysql server.

...@gmail.com] Sent: Monday, June 11, 2012 7:26 AM To: mysql@lists.mysql.com Subject: i need advice on redundancy of mysql server. I am running a site with about 50gig myisam databases which are the backend to different websites. I can not afford any downtime and the data is realtime. What

Re: i need advice on redundancy of mysql server.

- Original Message - From: Joey L mjh2...@gmail.com It sounds like you are all consultants. Hehe. I'm not :-p A lot are, though, because the combined technical knowledge on this list draws in consultants looking for stuff, and having experienced consultants on the list in turn

Re: i need advice on redundancy of mysql server.

Does really Master-Master replication provide load balancing feature? since, each node need to replicate to other node, and MySQL replication still a is single threaded replication , it mean there is only single replication thread sql_thread for DML queries. eg. There is two node with master

RE: i need advice on redundancy of mysql server.

solution. First decide what 'keeps you up at night'. -Original Message- From: Joey L [mailto:mjh2...@gmail.com] Sent: Monday, June 11, 2012 7:26 AM To: mysql@lists.mysql.com Subject: i need advice on redundancy of mysql server. I am running a site with about 50gig myisam databases

Re: i need advice on redundancy of mysql server.

It sounds like you are all consultants. On Mon, Jun 11, 2012 at 4:46 PM, Baron Schwartz ba...@xaprb.com wrote: Yeah -- that was an unintentional omission. There are solo consultants like Ronald Bradford too. On Mon, Jun 11, 2012 at 3:14 PM, Andrew Moore eroomy...@gmail.com wrote: Not

Re: i need advice on redundancy of mysql server.

Joey, I can not afford any downtime and the data is realtime. This is a very good reason for asking help to consultants. If you ask What is the best method for this setup? master-master or master-slave? then the simple answer is master-slave, for any mysql setup, that is the only safe mysql

i need advice on redundancy of mysql server.

I am running a site with about 50gig myisam databases which are the backend to different websites. I can not afford any downtime and the data is realtime. What is the best method for this setup? master-master or master-slave? What are the best utilities to create and maintain this setup? as far

Re: i need advice on redundancy of mysql server.

when u say redudency. Do u just want replication like master-slave, which will be active-passive or Master-master which be active-active. master-slave, will work just a DR, when ur current master fails you can failover the slave, with NO LOAD balancing. Master-master allows load balancing. On

Re: i need advice on redundancy of mysql server.

On 6/11/2012 10:36 AM, Ananda Kumar wrote: ... Master-master allows load balancing. Why do people keep replication rings as if they are the best possible configuration? A master-slave relationship also permits load balancing and is easier to maintain and recover in the event of a node

Re: i need advice on redundancy of mysql server.

I understand ..I am looking for load balancing - something that i do not have to worry about if one server goes down - the other server will be up and running by itself and i can bring back the other server later on when i have time. On Mon, Jun 11, 2012 at 10:36 AM, Ananda Kumar

Re: i need advice on redundancy of mysql server.

That's not a description of 'load balancing'; it is a high availability solution you're looking for. On Mon, Jun 11, 2012 at 4:43 PM, Joey L mjh2...@gmail.com wrote: I understand ..I am looking for load balancing - something that i do not have to worry about if one server goes down - the other

Re: i need advice on redundancy of mysql server.

You listed a lot of things - but no solution - i am looking for master - master configuration. Any tools you have used ? Anything concrete you can offer? thanks On Mon, Jun 11, 2012 at 11:39 AM, Shawn Green shawn.l.gr...@oracle.com wrote: On 6/11/2012 10:36 AM, Ananda Kumar wrote: ...

Re: i need advice on redundancy of mysql server.

Sorry new to this part - but I am looking for both. I have setup similar configuration using other technologies. I was asking the group for recommendations - concrete ones ? Can you offer up any ? On Mon, Jun 11, 2012 at 11:54 AM, Andrew Moore eroomy...@gmail.com wrote: That's not a description

Re: i need advice on redundancy of mysql server.

On 6/11/2012 12:02 PM, Joey L wrote: You listed a lot of things - but no solution - i am looking for master - master configuration. Any tools you have used ? Anything concrete you can offer? There is no one-size-fits-all approach to the problem you are attempting to solve. However, there are

Re: i need advice on redundancy of mysql server.

Ultimately, if you intend to use MyISAM, you must keep in mind that it eliminates some of your options. One problem is that MyISAM is very slow to repair after a crash. Remember, if a crash can happen, it eventually will, it's just a question of when. And MyISAM doesn't have recovery -- it only

Re: i need advice on redundancy of mysql server.

Not forgetting Pythian http://www.pythian.com, Baron ;) On Mon, Jun 11, 2012 at 8:12 PM, Baron Schwartz ba...@xaprb.com wrote: Ultimately, if you intend to use MyISAM, you must keep in mind that it eliminates some of your options. One problem is that MyISAM is very slow to repair after a

Re: i need advice on redundancy of mysql server.

Yeah -- that was an unintentional omission. There are solo consultants like Ronald Bradford too. On Mon, Jun 11, 2012 at 3:14 PM, Andrew Moore eroomy...@gmail.com wrote: Not forgetting Pythian, Baron ;) On Mon, Jun 11, 2012 at 8:12 PM, Baron Schwartz ba...@xaprb.com wrote: Ultimately, if you

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

On 06/08/2012 01:55 AM, Claudio Nanni wrote: Hi, you guys don't like the official API? http://dev.mysql.com/downloads/connector/c/ That's C isn't it? I think there is also a C++ connector. I'm interested to hear how that performs. It seems like a waste of time to write a bunch of

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

Simon, yes it is C, C++ here: http://dev.mysql.com/downloads/connector/cpp/ I did not work with this libraries and to be honest I do not know about their performances, If you have the chance it would be extremely useful for the community having some tests done with both APIs. Cheers Claudio

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

On 06/07/2012 12:29 PM, Lars Nilsson wrote: On Wed, Jun 6, 2012 at 10:41 PM, Simon Waltersi...@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.

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

On Thu, Jun 7, 2012 at 3:08 AM, Simon Walter si...@gikaku.com wrote: On 06/07/2012 12:29 PM, Lars Nilsson wrote: I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work. Commercial and not open source, but it's cross-platform and supports a dozen or so different databases. It

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

Hi, you guys don't like the official API? http://dev.mysql.com/downloads/connector/c/ Cheers Claudio 2012/6/7 Lars Nilsson chamael...@gmail.com On Thu, Jun 7, 2012 at 3:08 AM, Simon Walter si...@gikaku.com wrote: On 06/07/2012 12:29 PM, Lars Nilsson wrote: I've been happy using SQLAPI++

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

There is also libdrizzle. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

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

On Thu, Jun 7, 2012 at 12:55 PM, Claudio Nanni claudio.na...@gmail.com wrote: Hi, you guys don't like the official API? http://dev.mysql.com/downloads/connector/c/ Cheers Claudio Personally? Not really. For instance, memory leaks are not acceptable according to Simon's expressed desire.

Connect to MySQL server from a c++ application

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

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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

of file /var/run/mysqld/mysqld.sock On Wed, Apr 11, 2012 at 9:48 AM, Larry Martell larry.mart...@gmail.com wrote: On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar bugcy...@gmail.com wrote: Hi Guys, I am using debian squeeze it's working good, I am trying to install mysql-server. mysql

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Il 11/04/2012 10:51, Ganesh Kumar ha scritto: Hi Guys, I am using debian squeeze it's working good, I am trying to install mysql-server. mysql-server installation successfully but didn't start root@devel:~# /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar bugcy...@gmail.com wrote: Hi Guys, I am using debian squeeze it's working good, I am trying to install mysql-server. mysql-server installation successfully but didn't start service root@devel:/var/run# more /etc/mysql/my.cnf |grep socket

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

mysql-server. mysql-server installation successfully but didn't start service root@devel:/var/run# more /etc/mysql/my.cnf |grep socket # Remember to edit /etc/mysql/debian.cnf when changing the socket location. socket = /var/run/mysqld/mysqld.sock socket = /var/run

  1   2   3   4   5   6   7   8   9   10   >